Item: SQL Server Integration Services
Rating: 9
Author: Shubham Rawat

Use Cases and Deployment Scope

A good tool for SQL server query and data migration. The way it stores data and makes it easier for the user to write queries over the server. Compatibility with different BI tools is awesome as it is easy to integrate Microsoft SQL servers with different BI tools like google data studio and PowerBI.

Pros and Cons

Assists in connecting to several data sources and loading the resulting data.
Less expensive than other ETL tools of same stature.
Does away with the requirement for coding scripts.

There isn't a lot of room for building user-required automation.
Some activities need manual labour, such as exporting multiple tables in CSV format one at a time.

Return on Investment

Able to managed very dense healthcare data in this software.
Creation of data models and automated scripts.

Alternatives Considered

Oracle API Platform Cloud

It is more user-friendly and cost efficient.

Key Insights

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?

Yes

Did implementation of SQL Server Integration Services go as expected?

Yes

Would you buy SQL Server Integration Services again?

Yes

Other Software Used

Oracle Access Management

Likelihood to Recommend

1. Combining and integrating data from a variety of sources.
2.There is no additional necessity to learn anything other than SQL.
3. Assists in the analysis of client data by bringing it all together in one place.
4. Data leaks of clients' personal information are avoided. It is HIPAA compliant and it has very secure server.

Data integration and migration are made easier with this tool.

Overall Satisfaction with SQL Server Integration Services