Microsoft SQL Server Integration Services to Alation Reviews & Product Details

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.

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.

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.

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

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.

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

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.

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

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.

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.

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.

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

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.

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.

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.

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.

I've used the MS SSIS with Atlan and it helped me with managing the data. It tracks the data and processing the data in the better way even with the high volume data. Review collected by and hosted on G2.com.

So , the only issue I faced about it is that setting it up and the integration part is hard. Review collected by and hosted on G2.com.

Microsoft SSIS Services to Alation tool makes the task of injecting data with ease and we can control and manage that data assets effectively while maintaining the data assets quality and governance. Also, User Interface of this tool is good enough. Review collected by and hosted on G2.com.

Look, as it is new tool ,it is continuously improving. Initially, there are issues in UI but later on those bug fixes. Review collected by and hosted on G2.com.