It's been two months since this profile received a new review

Microsoft SQL Server Integration Services to Alation Reviews & Product Details

Value at a Glance

Averages based on real user reviews.

Time to Implement

3 months

Return on Investment

10 months

View More Pricing Information

Top-Rated Alternatives

SolarWinds Database Observability

4.5/5

(210)

Azure Analysis Services

View All Alternatives

Microsoft SQL Server Integration Services to Alation Reviews (84)

G2 reviews are authentic and verified.

Here's how.

UH

Verified User in Health, Wellness and Fitness

Mid-Market (51-1000 emp.)

1/11/2024

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

What problems is Microsoft SQL Server Integration Services to Alation solving and how is that benefiting you?

Previously we were using talend but we were facing scalability isses for our services most of our use is loading huge amount of data to extract Information for our client MIrcosoft SQL integartion services are scalable and are reliable than talend Review collected by and hosted on G2.com.

SS

Shreyansh S.

Intern - Product Analyst

Small-Business (50 or fewer emp.)

5/30/2022

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

SJ

Shruti J.

Salesforce Developer

Small-Business (50 or fewer emp.)

9/1/2021

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

Recommendations to others considering Microsoft SQL Server Integration Services to Alation:

Before all this cloud data migration tool people used to work on ssis for data migration data analysis and SQL query. If you working on sql server you must try this out it's really provides small features which are really helpful at the same time impactful. Review collected by and hosted on G2.com.

What problems is Microsoft SQL Server Integration Services to Alation solving and how is that benefiting you?

Firstly for this no extra learning required if you know sql and have worked on any of its tool before you're good to go. Compared to oracle developer i find this way helpful and easy to work. Features offered by ssis are really good and once you work on it if you switch to another you'll miss it. Review collected by and hosted on G2.com.