2020-03-09 16:03:00 UTC

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
User

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-18 10:14:56 UTC
Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration Tools. Updated: May 2020.
420,062 professionals have used our research since 2012.