Looking for data integration tool

Question

Hi,

I was wondering what ETL tool you would recommend as middleware, ETL, to create data transformation between multiple relational databases, flat and other type of files. Ideally, we are looking for windows based software which is flexible enough to work with different databases and platforms should we switch to a different rdbms. I have used dts in the past and looked at Kettle demo. It seems like they do have similar. Can we use dts, if one of the databases is mysql? Are there any other prefered, easy to use packages?

Thanks,

Answer 1

If you have used DTS, you may well like the newer SSIS from Microsoft. Sql Server Integration Service is significantly better than DTS in most respects.

You can use MySQL through an ODBC driver, so yes that is a possibility.

Answer 2

For best option i will suggest you to use Adeptia ETL Suite which will solve the data transformation, data mapping, data transport needs on any type of databases and applications

Answer 3

SSIS (SQL Server Integration Services) - which is a descendent of DTS - comes with SQL Server. If one of your systems is SQL Server then SSIS is probably a good option simply because it comes bundled with SQL Server and you don't have to buy anything else.

If you don't have access to SQL Server then you will probably need to buy a third party tool. These range from open-source ones such as Kettle or Talend through to expensive proprietary systems like Informatica Powercentre with various price points in between.