2020-03-09T16:03:00Z

What is the biggest difference between SSIS and Pentaho?


I work as a research assistant for a university.

I am currently researching SSIS and Pentaho. What is the biggest difference between the two? Which would you recommend?

Thanks! I appreciate the help.

Guest
22 Answers

author avatar
Consultant

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.

2020-03-18T10:14:56Z
author avatar
Top 5Real User

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:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/13199248-e246-47aa-bab3-b2b73112d991/ssis-as-a-etl-tool-related-query?forum=sqlintegrationservices

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/47aeed76-8466-4e9f-bb48-b912c07145df/ssis-tool-evaluation?forum=sqlintegrationservices

Nowadays SSDT (SQL server data tools) is also getting popularity:

https://docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/ssdt/release-notes-ssdt?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools?view=sql-server-ver15

2020-04-10T03:28:41Z
Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: May 2021.
502,104 professionals have used our research since 2012.