2020-03-09T16:03:00Z

What is the biggest difference between SSIS and Pentaho?

PS
  • 2
  • 257
PeerSpot user
2

2 Answers

Rahul Sahay - PeerSpot reviewer
Real User
Top 10
2020-03-18T10:14:56Z
Mar 18, 2020

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 comparison that may be of interest to you
RS
Real User
2020-04-10T03:28:41Z
Apr 10, 2020

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

Compare products