Microsoft SQL Server Integration Services to Alation Reviews & Product Details - Page 3

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

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.

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

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.

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

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.

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

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.

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

SSIS can be used for extraction, loading, and transformation (ETL) of data by extracting data from multiple sources, such as SQL Server database, Oracle database, and Excel files. Review collected by and hosted on G2.com.

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

Limited Connectors: Compared to other data integration platforms, SSIS offers a limited set of built-in connectors. ...

Learning Curve and User Friendliness: SSIS can have a steep learning curve, and its user interface is not as intuitive or user-friendly as some other data integration tools. Review collected by and hosted on G2.com.

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

RDBMS - it's an awesome product with RDBMS we can achieve anything and everything with the respect to data objects. It's nice interface and has powerful features and helps in performing CRUD operation with ease. also support creation of complex queries and stored procedures to customise and retrieve the data in required format. Easy integration with other software apps using endpoint is another desired feature Review collected by and hosted on G2.com.

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

Product function and performance. Slow performance task Review collected by and hosted on G2.com.

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

It was most helpful in migrating data from different sources to other destinations. Also it helps in wide range of tools and solutions. Review collected by and hosted on G2.com.

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

Performance needs a bit developed so that it will be helpful. Review collected by and hosted on G2.com.

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

The seamless integration that allows for easy synchronization of package lineage and i like it about the improving data visibility and governance. Review collected by and hosted on G2.com.

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

Initial setup can be complex and may require significant time and experience to get through. Review collected by and hosted on G2.com.

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

It was really helpful to visualize and understand the data flows through the ETL processes. Having a centralized vault or repository of data, improved the access and analysis with several teams. Review collected by and hosted on G2.com.

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

The integration required a lot of settings and configurations, some of them really tricky. In order to get the results needed, a couple of third-party tools were considered to get more functionality and then discarded because of the cost and potential compatibility concerns. Review collected by and hosted on G2.com.

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

Integrating SQL services to Alation was very streamlined and user friendly. This was very surprising since most any software that integrates with SQL is difficult and has so many issues but this was simple and satisfying once integrated. Review collected by and hosted on G2.com.

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

I didn't have any dislikes except maybe that I didn't have this sooner. Review collected by and hosted on G2.com.

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

The seamless synchronization between SSIS and Alation significantly enhances data discovery and governance. the intuitive interface and robust metadata management features make it easy to catalog, tag and search data assets, ultimately improving data processing efficiency and collaboration within out team Review collected by and hosted on G2.com.

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

The initial setup process can be challenging due to version compatibility issues and the cost which might be high for smaller organizations. Review collected by and hosted on G2.com.

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

awesome for handling complex ETL tasks, letting you manage data from a bunch of sources and transform it as needed. Review collected by and hosted on G2.com.

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

Depending on the volume and complexity of the data, SSIS can sometimes experience performance issues, which might affect how effectively it works with Alation, especially in real-time scenarios. Review collected by and hosted on G2.com.