Microsoft SQL Server Integration Services to Alation Reviews & Product Details

SSIS makes it super easy to move data around and works great with Alation, making sure all our data and metadata are in sync. Review collected by and hosted on G2.com.

Setting up SSIS to work with Alation can be a bit tricky and takes a while to get right, which can be frustrating. Review collected by and hosted on G2.com.

Easy to work with, especially if you need to migrate data from different sources to other destination. Review collected by and hosted on G2.com.

Complexity of setup, you need to setup a lot of features, however it helps you to build what exactly you need. Review collected by and hosted on G2.com.

Efficient Structure and fast response and implements the best solution for the review. Review collected by and hosted on G2.com.

The only one disadvantage is the support system of this application. Review collected by and hosted on G2.com.

Bring in data from different platforms in the enterprise Review collected by and hosted on G2.com.

Adoption takes a bit of time, but once we had it was easy Review collected by and hosted on G2.com.

Excellent debugging capability during flow execution, seamless integration with Microsoft tools, support to ETL processes, friendly interface and data filtering features. Powerful data governance Review collected by and hosted on G2.com.

Can be confusing sometimes to set up. Limited support to non Microsoft services, data mapping can be complex sometimes. Review collected by and hosted on G2.com.

Encrypt data and send to network. Robust ETL product to extract, transform, and load data as ETL, and it works perfectly with data visualization tools like Power BI. Review collected by and hosted on G2.com.

Support for CRM like Salesforce is a bit less Review collected by and hosted on G2.com.

I like the tool's ease of exploring data, managing objects, and loading data Review collected by and hosted on G2.com.

Some layout options leave me confused when we build the flow Review collected by and hosted on G2.com.

Everything about the tool makes the user experience better. Review collected by and hosted on G2.com.

Query optimization and filtering criteria are the most useful functions for me Review collected by and hosted on G2.com.

It allows you to query large amounts of data. Review collected by and hosted on G2.com.

Performance issues due to its declarative nature. Also, select statements are not dynamic. Review collected by and hosted on G2.com.

SSIS integration with Alation excels in providing a clear and comprehensive understanding of data lineage. Alation automatically captures the metadata from SSIS packages, including data sources, transformations, and destinations Review collected by and hosted on G2.com.

Setting up and maintaining the integration between SSIS and Alation can be somewhat complex, especially for organizations with large and intricate data environments Review collected by and hosted on G2.com.