Great Tool For ETL Design
January 19, 2020

Great Tool For ETL Design

zahit bogus | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

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.
The SQL Server Integration Services (SSIS) ETL tool has a very strong user community. With the error codes, I get access to solutions in the forums. In addition, Microsoft products offer a wide range of consulting services.

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

For enterprise business intelligence projects, the SQL Server Integration Services ETL tool is a logical choice to move your data to the data warehouse on a daily basis. The SSIS ETL tool has enough functions and capabilities to design the data warehouse. If you want to send your JSON data to the database, SSIS does not work here.

SSIS Feature Ratings

Connect to traditional data sources
8
Connecto to Big Data and NoSQL
8
Simple transformations
10
Complex transformations
9
Data model creation
9
Metadata management
10
Business rules and workflow
8
Collaboration
8
Testing and debugging
7
feature 1
7
Integration with data quality tools
9
Integration with MDM tools
8