Great Tool For ETL Design
January 19, 2020
Great Tool For ETL Design
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Server Integration Services
In my department, we design and manage ETL processes. We use SQL Server Integration Services (SSIS) to design a data warehouse. To create a data warehouse, we can make the stage layer and DWH layers with the SSIS ETL tool. We create data marts using aggregate functions in the SSIS ETL tool. In addition, we use the SSIS ETL tool to move data between databases.
- Data migration is pretty fast.
- SQL Server is highly compatible with the database.
- We receive errors in moving JSON data to the database. It does not work efficiently in JSON-related data.
- ODBC connections give a connection error after a certain period of time.
- Paying a license fee to the SSIS ETL vehicle for our enterprise projects increases our costs.
- Because it is a powerful and performance ETL tool, data increases our business productivity.
I used the Pentaho Data Integration (PDI) ETL tool. The PDI ETL tool does not have a public user collection like the SQL Server Integration Services(SSIS) ETL tool. Therefore, you may not be able to find instant solutions for your problems. But it has advantages over the SSIS ETL tool. The PDI ETL tool is open source software and does not charge a license fee.
Do you think SQL Server Integration Services delivers good value for the price?
Yes
Are you happy with SQL Server Integration Services's feature set?
Yes
Did SQL Server Integration Services live up to sales and marketing promises?
I wasn't involved with the selection/purchase process
Did implementation of SQL Server Integration Services go as expected?
Yes
Would you buy SQL Server Integration Services again?
Yes