TrustRadius: an HG Insights company

SSIS Health Care and Social Assistance Reviews & Insights

Score6.5 out of 10

259 Reviews and Ratings

Get a Demo

Community insights

TrustRadius Insights for SQL Server Integration Services are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Efficient Data Synchronization: Users have consistently praised SSIS for its ability to efficiently manage small-scale data synchronization tasks, enhancing productivity in data workflows. The tool's streamlined approach to syncing data has been noted as a time-saving benefit by many reviewers.

Rapid Data Transfer to SQL Server: Several reviewers have highlighted the tool's swift data transfer capabilities to SQL Server, particularly emphasizing its efficient handling of batch processes. This quick data movement feature not only accelerates tasks but also contributes to smoother operations within databases.

Real-Time Message-Based Functionality: Users highly value SSIS for its real-time message-based features and seamless integration with SQL Server and Visual Studio, facilitating agile data processing. The system's agility in handling real-time messages has been commended for improving responsiveness and connectivity across platforms.

SSIS Reviews

4 Reviews
Health Care and Social AssistanceHospital & Health Care3Health, Wellness and Fitness1

Data integration and migration are made easier with this tool.

Rating: 9 out of 10
Incentivized

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

  • 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.

Cons

  • 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.

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.
SR
Shubham Rawat
Data Analyst in Research & Development at DayToDay Health (Hospital & Health Care, 201-500 employees)
Vetted Review
SQL Server Integration Services
2 years of experience
View profile

Great product to consolidate data for SQL Reporting purposes

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

We use SQL Server Integration Services to consolidate data from multiple vendor products. SSIS is the engine that gathers that data and stores it on our main SQL database instance for reporting purposes. It is being used by the enterprise in our organization. It created one pain of glass using SQL Reporting Services to show what systems are in what vendor products - such as agents installed yes/no? Last checking date/time, etc...

Pros

  • If the job fails, we are alerted
  • It has a easy to use GUI to build projects
  • Does well with gathering data from different types of data sets

Cons

  • Converting flat files of data requires a data transformation that is tedious

Likelihood to Recommend

Moving data from one location to another. Also transforming data from one source to another destination. It wouldn't be needed for operating system file management or copying of files.
VU
Verified User
Professional in Information Technology (Hospital & Health Care company, 10,001+ employees)
Vetted Review
SQL Server Integration Services
10 years of experience

SSIS offers what I need for data processing.

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

In my current organization, SSIS is being used by the enterprise data warehouse team. This team uses SSIS to construct data warehouse, prepare data cubes, and fulfill ad-hoc data-related acquisitions.

Pros

  • Presents the flow of data processing very well, making it easy to learn/understand SSIS packages.
  • T-SQL and C# friendly.
  • Comprehensive configuration, logging, and error handling.

Cons

  • Some components are not working very well, including sorting, SCD, etc.
  • Different components could have different syntax or data type definition.
  • Not enough scripting learning materials.

Likelihood to Recommend

For SQL Server users, SSIS would be a natural yet very wise choice. It works quite well with Microsoft bottom layer and offers an easy and more user-friendly way of manipulating data.
VU
Verified User
Analyst in Information Technology (Hospital & Health Care company, 1001-5000 employees)
Vetted Review
SQL Server Integration Services
9 years of experience

SSIS, an ETL tool with a lot of hidden benefits!

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

We are using SQL Server Integration Services for mission critical import, export, and data transformations. It is being used across the whole organization for various business processes. Since we receive numerous file transfers, we have to create many SSIS packages and projects to import, and process the files. In addition, we send numerous files to clients.

We are also using SSIS to transfer data within our environment from server to server. When replication is not required, we prefer to use SSIS to transfer data at specific intervals to reduce overhead on the servers.

Pros

  • File import and export
  • Data transfer from source database to a destination database
  • Database Maintenance tasks

Cons

  • Data cleansing improved
  • Additional database source connections

Likelihood to Recommend

SSIS is used most commonly in a SQL Server Environment. I have seen SSIS used in non SQL Server Environments strictly for the integration portions. SSIS is well suited for file transfers, data transfers, database maintenance, and various business processes that you are looking to automate. The SSIS scheduling allows jobs to run on specific schedules.
VU
Verified User
Administrator in Information Technology (Health, Wellness and Fitness company, 51-200 employees)
Vetted Review
SQL Server Integration Services
5 years of experience