locked
Quality of our data RRS feed

  • Question

  • Hello,

    Thanks for the help on the last question. 
    We have looked at several open source offers in the field of data integration. We are now wanting data quality software to complete our data integration program. 

    Do packages exist to suit our needs? Would you know of innovative data quality programs?

    Thanks to all !
    Wednesday, September 8, 2010 2:33 PM

Answers

  • We are now wanting data quality software to complete our data integration program.  

    Using SSIS you can build your data integration project as per you required.

    SQL Server Integration Services (SSIS) is the best Data integration software I have ever seen. You can have Zero “0” defect data by using SSIS. Now the beauty part of SSIS tool is you have lot more options to make data available as per your business requirement.

    This tool can assure you 100% of data secure and data quality for your needs and requirements. Even you will not lose a single “character/Digit/point data” using this tool and you need to do more analysis and define the development approach to make your error free best ETL process.

    thanks,


    - MS (We are what we repeatedly do, Excellence, then, is not an act, but a habit.)
    Thursday, September 9, 2010 6:04 AM
  • For some tasks, like mailing address validation, you might even want to ship your data outside to a third-party vendor, who will clean it up for you and return you a set you can use to update your database.

    Josh

     

    Monday, September 13, 2010 11:57 PM

All replies

  • Data quality is a wide area, like adress validation, value distribution etc. Which do you mean especially ?

    -Jens


    Jens K. Suessmeyer http://blogs.msdn.com/Jenss
    Wednesday, September 8, 2010 11:17 PM
  • We are now wanting data quality software to complete our data integration program.  

    Using SSIS you can build your data integration project as per you required.

    SQL Server Integration Services (SSIS) is the best Data integration software I have ever seen. You can have Zero “0” defect data by using SSIS. Now the beauty part of SSIS tool is you have lot more options to make data available as per your business requirement.

    This tool can assure you 100% of data secure and data quality for your needs and requirements. Even you will not lose a single “character/Digit/point data” using this tool and you need to do more analysis and define the development approach to make your error free best ETL process.

    thanks,


    - MS (We are what we repeatedly do, Excellence, then, is not an act, but a habit.)
    Thursday, September 9, 2010 6:04 AM
  • There is plenty of software for data quality. To use both data quality and data integration software, I would recommend using Talend : there are both tools to use.

    Both are free, open source and to download from the website. Data quality is an important part of data management.
    Friday, September 10, 2010 1:58 PM
  • For some tasks, like mailing address validation, you might even want to ship your data outside to a third-party vendor, who will clean it up for you and return you a set you can use to update your database.

    Josh

     

    Monday, September 13, 2010 11:57 PM