Microsoft SQL Server Integration Services to Alation
Information Asset, LLC.Reviews from AWS customer
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
83 reviews
from
External reviews are not included in the AWS star rating for the product.
More commonly use for onprem data migration
What do you like best about the product?
It's essential data migration for on prem data sources. It can easily complete many complex task.
What do you dislike about the product?
Sometimes faces challenges when connect to data sources which is not natively supported by ssis
What problems is the product solving and how is that benefiting you?
Used it for data migration and reporting purposes to pull data from upstream sources.
Useful SQL Integration
What do you like best about the product?
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.
What do you dislike about the product?
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.
What problems is the product solving and how is that benefiting you?
Business processes that the IT team leverages for data governance. I have lived in a heavy Jira ran world in HRIS and IT and this integration helps with protecting our assets. We benefit from this because of strict ordinances tied to changes in the org. Additionally, I am a heavy Power BI user who runs and creates reports for our executive leadership.
Comparative Review: Microsoft SQL Server Integration Services
What do you like best about the product?
Native Integration with SQL Server;
User-Friendly interface;
Predefined Components;
Flexibility e security
User-Friendly interface;
Predefined Components;
Flexibility e security
What do you dislike about the product?
Learning curve expensive
Limited Compatibility, only with Microsoft environment;
Complex log debugging;
Licensing cost more expensive.
Limited Compatibility, only with Microsoft environment;
Complex log debugging;
Licensing cost more expensive.
What problems is the product solving and how is that benefiting you?
Microsoft SSIS and Alation together solve several key problems:
Data integration and transformation;
Data discovery and cataloging;
Collaboration and governance for system admin;
Automation, efficiency and flexibility.
Data integration and transformation;
Data discovery and cataloging;
Collaboration and governance for system admin;
Automation, efficiency and flexibility.
SSIS is an amazing tool, i used it for 6 yrs and actually started out totally researching on my own.
What do you like best about the product?
It helps in data lineage and impact analysis and improves data discoverability. It improves collaboration, data governance, and compliance.
What do you dislike about the product?
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.
What problems is the product solving and how is that benefiting you?
The main problems related to data lineage, metadata management, and data discoverability are solved. This set also provides a good view of data flows, making sure of data governance and compliance, and collaboration across teams.
MSSIS is a Game changer!
What do you like best about the product?
A potential benefit is streamlined data management
What do you dislike about the product?
Nothing specifially there to tell about dislikes
What problems is the product solving and how is that benefiting you?
Integrating SSIS with Alation can centralize data lineage information.
Seamless Data Integration
What do you like best about the product?
SSIS makes it super easy to move data around and works great with Alation, making sure all our data and metadata are in sync.
What do you dislike about the product?
Setting up SSIS to work with Alation can be a bit tricky and takes a while to get right, which can be frustrating.
What problems is the product solving and how is that benefiting you?
SSIS helps us easily integrate and organize data from different sources into Alation, which saves a ton of time and makes our data way more accessible and useful for everyone.
easy application with tons of power
What do you like best about the product?
Easy to pick up and navigate. Anyone can learn with short amount of time.
What do you dislike about the product?
The server could sometimes get lags and would have to wait.
What problems is the product solving and how is that benefiting you?
For us to quickly process data and correct ACH fails. Help me save a tons of time.
Efficient Platform for Data handling
What do you like best about the product?
I really like that this is the most Powerful platform for building high performance data integrations solutions.
and data migration tool that comes with Microsoft SQL server database that used to extract, assemble and transform data.
This integration tool really helps in solving complex business problems and improvesproductivity and efficiency.
The implementation of this tool is super easy to use and on every day basis I am using it frequently.
and data migration tool that comes with Microsoft SQL server database that used to extract, assemble and transform data.
This integration tool really helps in solving complex business problems and improvesproductivity and efficiency.
The implementation of this tool is super easy to use and on every day basis I am using it frequently.
What do you dislike about the product?
So far I have not encountered any major drawbacks with this tool so I really do not feel any cons of this.
What problems is the product solving and how is that benefiting you?
This has really helped inexecutingmultiple tasks on every day basis.
It helps me in migrating data, transform and assemble data including databases and cloud based applications.
It can also encrypt files, send files to other network locations so overall provides consistency and reduce manual errors.
It helps me in migrating data, transform and assemble data including databases and cloud based applications.
It can also encrypt files, send files to other network locations so overall provides consistency and reduce manual errors.
Review all your needs before move forward
What do you like best about the product?
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.
What do you dislike about the product?
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.
What problems is the product solving and how is that benefiting you?
We were looking for a data catalog solution that enables us to transparency, data governance and transformation. The goal was achieved partially but the experience let us understand the scope of our needs and future steps.
Useful for data integration
What do you like best about the product?
User friendly graphical user interface avilable for data integration and transformation.
What do you dislike about the product?
Nothing dislike about it but connection can be challanging sometime.
What problems is the product solving and how is that benefiting you?
It helped me to integrate,transform and migrate data.
showing 21 - 30