Microsoft SQL Server Integration Services to Alation Reviews & Product Details

The most helpful thing is that the integration has made connecting to data so much easier. Extracting, manipulating and loading the data so that it is ready for analysis is now super convenient. You can also track data lineage. Overall, saves a lot of time and manual work, which can be prone to error. Review collected by and hosted on G2.com.

The only real downsideof this is the cost. We are currently in a trial period and we will need to prove the value of the purchase if we hope to keep this integration for the long term. Otherwise, it works great and fits our needs. Review collected by and hosted on G2.com.

One of my personal best aspect of Microsoft SQL SIS to Alation is its robust and versatile ETL (Extract, Transform & Load) capabilities Review collected by and hosted on G2.com.

A notable downside of Microsoft SQL is it's limited focus on Data cataloging and governance while It is powerful for ETL processes and a decent Workflow automation it lacks comprehensive discovery and metadata management. Review collected by and hosted on G2.com.

Being able to obtain complete data traceability is one of the most valuable aspect of combining SSIS with Alation. Users can see the complete data flow from source to destination by combining both. Review collected by and hosted on G2.com.

Two thinks which is complicated. One is difficulty of configuring and maintaining the integration, integrating Microsoft SQL Server Integration Services with Alation might be difficult.

The integration also be affected by upgrades or modifications made to either system, needs continuous administration and troubleshooting. Review collected by and hosted on G2.com.

The helpful aspect of this integration stems from the functionality that it provides if you have a Microsoft heavy organization. In my opinion that is the focal point that your org should focus on this integration. Ask yourself the question - do we currently use other Microsoft products that can leveraged between this server and Alation and how do we conduct the rest of our aligned business processes. Review collected by and hosted on G2.com.

I feel like the SQL server from Microsoft is not really weak or serve as something to dislike. The issue I do take with it is the other side of the coin as it relates to its strength. This integration is not for all businesses or even those that simply uses Alation. Make sure that you use other Microsoft products to get the most bang for your buck - figuratively and literally. Review collected by and hosted on G2.com.

The initial setup ran smoothly, without surprises. The relationship between cost-benefit could be a decisive factor, particularly if support hours are included, but you need to be 100% sure that the features will cover your needs. The lineage data visualization is remarkable but with some limitations. Review collected by and hosted on G2.com.

Alation captured basic data flow but it lacked crucial details about transformations happening within the SSIS packages. Without a way for managing SSIS packages directly from Alation, we needed to switch between platforms very often, a big hole for efficiency. We had to do manual digging whenever we needed to analyze and understand very specific data manipulations but under other circumstances, it could be enough useful. Review collected by and hosted on G2.com.

Microsoft SQL Server Integration Services (SSIS) is a Low code Enterprise level tool with ease of usage and integration. It has graphical Integration Services to convert any type of data. Altation is data analysis too and with these tools the frequency of usage of SSIS is very high and accurate.With Being Low code the implementation is very easy and the support provided is phenomenol. Review collected by and hosted on G2.com.

The pacakage is limited thee are few additional features which can be implemented. Review collected by and hosted on G2.com.

The no of functions it supports is tremndous, have used other tools as well like trino and all but this one is quite OP. Have built warehouse on it and it's easier than spark and all. Also Microsoft customer support is presented all the time so if u got stuck just to raise a ticket and you'll be contacted in an hour or so. Review collected by and hosted on G2.com.

The issue is cost as it's quite expensive Review collected by and hosted on G2.com.

It shows the lineage between Table to File, File to Table and Table to Table of Microsoft SQL Server Integration Services jobs in Alation.

SSIS provides a user-friendly drag-and-drop interface for designing ETL processes.

Microsoft offers comprehensive support and extensive documentation for SSIS.

SSIS is frequently used for daily ETL operations due to its powerful data transformation capabilities.

Ease of Implementation: SSIS implements seamlessly with SQL Server, simplifying deployment within Microsoft environments. Review collected by and hosted on G2.com.

SSIS excels in robust ETL capabilities and seamless integration with the Microsoft ecosystem, unlike Alation, which focuses on data cataloging and metadata management. Review collected by and hosted on G2.com.

It helps in data lineage and impact analysis and improves data discoverability. It improves collaboration, data governance, and compliance. Review collected by and hosted on G2.com.

It's time-consuming to customise and configure and maintaining up-to-date metadata synchronisation between SSIS and Alation is quite challenging. And there are a bit of performance issues when working with large datasets or numerous ETL processes. Review collected by and hosted on G2.com.

some of the potential benefits I see as the biggest strengths of the Microsoft SQL Server Integration Services (SSIS) to Alation integration:

1. No More Pipeline Puzzles

2. Collaboration Gets a Boost

3. Trust Your Data, Unleash Insights

4. Less Documentation, More Time for Fun Stuff Review collected by and hosted on G2.com.

there are also some potential drawbacks to consider:

1. Not all Data Plays Nice

2. Initial Setup Might Take Time

3. Vendor Lock-In Blues

4. Complex Pipelines, Complex Setup

5. Real User Reviews are Scarce Review collected by and hosted on G2.com.