Microsoft SQL Server Integration Services to Alation Reviews & Product Details

Was easy to set up. Support was on the job. Runs seamlessly. Review collected by and hosted on G2.com.

Was a bit tricky at first. But works well now. Review collected by and hosted on G2.com.

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

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

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

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

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

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

While querying our SQL server, it was the go-to tool to create stored procedures, table or query any table from any database. It provides a good UI and is easy to get started. With SSIS, we can 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.

Many things need to be done manually; it's really hard to create any automations there. I remember one scenario where we needed to export hundreds of tables as CSV, so we had to do that one by one, unable to create any automations to do it in one shot. Review collected by and hosted on G2.com.

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

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