Product recommendation depends on the business requirement and use case. Both are good products and well established in the market. Parameters to look for at the time of product selection :
1) License cost
2) Type of data to be handled and integration with source database
3) Are we looking for cloud implementation or on-premises
4) Volume of data that we are looking at with possible transformations
5) Data Quality framework
6) Scalability
7) Customer experience ie support.
I am from MS background and have worked both on cloud version and on-premises version. I was able to achieve my solution using MS.
Product recommendation depends on the business requirement and use case. Both are good products and well established in the market. Parameters to look for at the time of product selection :
1) License cost
2) Type of data to be handled and integration with source database
3) Are we looking for cloud implementation or on-premises
4) Volume of data that we are looking at with possible transformations
5) Data Quality framework
6) Scalability
7) Customer experience ie support.
I am from MS background and have worked both on cloud version and on-premises version. I was able to achieve my solution using MS.
MS SQL Server Integration Services (SSIS) is a part of the commercial MS SQL Server product.
It is not a freeware. Probably Pentaho offers an open source/ freeware edition.
Below may be useful:
social.msdn.microsoft.com/Forums/sqlserver/en-US/13199248-e246-47aa-bab3-b2b73112d991/ssis-as-a-etl-tool-related-query
social.msdn.microsoft.com/Forums/sqlserver/en-US/47aeed76-8466-4e9f-bb48-b912c07145df/ssis-tool-evaluation
Nowadays SSDT (SQL server data tools) is also getting popularity:
docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools
docs.microsoft.com/en-us/sql/ssdt/release-notes-ssdt
docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools