Microsoft SQL Server Integration Services to Alation Reviews & Product Details

Best used for extracting metadata, Integration with SQL Server Management Studio. Easy to use since it has good documentation Review collected by and hosted on G2.com.

It is somehow hard to use it in Handling Dynamic and Complex Workflows Review collected by and hosted on G2.com.

Microsoft SQL Server Integration Services removes the complexity of building, training, and deploying machine learning models at any scale. It is a very helpful tool for the corporate world. Review collected by and hosted on G2.com.

It can be more user friendly for the users. Review collected by and hosted on G2.com.

It is very useful for the large amount of data in the database. It's easy to do integration and migration of data with security. Review collected by and hosted on G2.com.

I can say the cost is a little on the higher side, and also sometimes it takes time to do the required configuration on the server which seems a complex process. Review collected by and hosted on G2.com.

It s a very user friendly software and easy to access. Overall a great experience. Review collected by and hosted on G2.com.

There is no such thing to not like about. But it would be better if you introduced some features for beginners. Review collected by and hosted on G2.com.

It's essential data migration for on prem data sources. It can easily complete many complex task. Review collected by and hosted on G2.com.

Sometimes faces challenges when connect to data sources which is not natively supported by ssis Review collected by and hosted on G2.com.

it offers comprehensive ELT functionalities and user-friendly. Review collected by and hosted on G2.com.

it has high licensing cost and limitedsupport for non-microsoft data sources. Review collected by and hosted on G2.com.

Microsoft SQL Server Integration Services and Alation serve different but complementary roles in the data management ecosystem. Easy to use and customer-friendly. Review collected by and hosted on G2.com.

Both SQL Server Integration Services and Alation have robust capabilities but come with some challenges. SSIS in maintenance, debugging, and deployment. Alation can be costly and complex to integrate. Review collected by and hosted on G2.com.

Easy to pick up and navigate. Anyone can learn with short amount of time. Review collected by and hosted on G2.com.

The server could sometimes get lags and would have to wait. Review collected by and hosted on G2.com.

It is a great database server, better than it's contemporary by some margin. Review collected by and hosted on G2.com.

Nothing much. It is quite smooth it it's overall function. Review collected by and hosted on G2.com.

Alation serves as a centralized repository for metadata. Integrating SSIS with Alation ensures that all metadata generated by SSIS processes is stored centrally, making it easier to manage and access. Review collected by and hosted on G2.com.

Integration is complex and difficult from the developer's point of view, which creates difficulty in communication between all BUs Review collected by and hosted on G2.com.