Microsoft SQL Server Integration Services to Alation Reviews (85)

Reviews

Microsoft SQL Server Integration Services to Alation Reviews (85)

4.2
85 reviews

What do users say?

Generated using AI from real user reviews
Users consistently praise the ease of use and seamless integration of Microsoft SQL Server Integration Services with Alation, highlighting its ability to simplify data management and enhance collaboration. Many appreciate how it effectively tracks data lineage and improves data governance, although some note that the initial setup can be complex and may require technical expertise.
Search reviews
Filter Reviews
Clear Results
G2 reviews are authentic and verified.
Here's how.
Verified User in Wine and Spirits
UW
Verified User in Wine and Spirits
Small-Business (50 or fewer emp.)
More Options
"Microsoft implementation"
3.5/5
What do you like best about Microsoft SQL Server Integration Services to Alation?

Very useful and easy to implement and integrate Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server Integration Services to Alation?

A customer support not always efficient ! Review collected by and hosted on G2.com.

Verified User in Health, Wellness and Fitness
UH
Verified User in Health, Wellness and Fitness
Mid-Market (51-1000 emp.)
More Options
"The best fit for my needs!!"
4/5
What do you like best about Microsoft SQL Server Integration Services to Alation?

Effiecient structure and Fast responses and the MS SSIS implements the best solution for alation Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server Integration Services to Alation?

Connectivity issues sometimes( and the tool gets stuck) and support Review collected by and hosted on G2.com.

Shreyansh S.
SS
Shreyansh S.
Intern - Product Analyst
Small-Business (50 or fewer emp.)
More Options
"Useful tool for data integration and migration."
4/5
What do you like best about Microsoft SQL Server Integration Services to Alation?

* Helpful in connecting to various data sources and loading the combined data

* More cost-efficient than other ETL tools of the same stature

* Reduces the need for coding scripts Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server Integration Services to Alation?

* Not much scope for creating user-required automation

* Some tasks require manual labour like exporting numerous tables in csv format has to be done one by one. Review collected by and hosted on G2.com.

Shruti J.
SJ
Shruti J.
Salesforce Developer
Small-Business (50 or fewer emp.)
More Options
"Tool for sql server query and Data migration"
3/5
What do you like best about Microsoft SQL Server Integration Services to Alation?

While querying our SQL server it was the goto tool to create stored procedures, table or query any table from any database. It provides good ui and is easy to get started. With ssis we can query create logics and export the result into csv for data analysis and even this is good for on prem sql servers for data migrations. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server Integration Services to Alation?

Many things need to do manually it's really hard to create any automations there. I remember in one scenario where we need to export 100's of table as csv so need to do that one by one, was unable to create any automations to do it at one shot. Review collected by and hosted on G2.com.

Michele C.
MC
Michele C.
Financial Services Professional
Financial Services
Enterprise (> 1000 emp.)
More Options
"Overall good security to prevent hacking"
4/5
What do you like best about Microsoft SQL Server Integration Services to Alation?

Data is secure with end-to-end encryption; easy to use Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server Integration Services to Alation?

sometimes there are bugs/errors. the UI can be better Review collected by and hosted on G2.com.