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.
Review of Microsoft SQL Server Integration Services
What do you like best about the product?
One of my personal best aspect of Microsoft SQL SIS to Alation is its robust and versatile ETL (Extract, Transform & Load) capabilities
What do you dislike about the product?
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.
What problems is the product solving and how is that benefiting you?
Microsoft SSIS mainly help us handle the ETL (Extraction, Transformation and Loading) of data from various sources allowing for data consolidation into a more centralized database.
It allows us to integrate in a quick and efficient manner.
What do you like best about the product?
I love the interface and how seamless it it. Great for our line of work and allows us to edit and change in the fly
What do you dislike about the product?
Can be a bit clunky and laggy but not a deal breaker
What problems is the product solving and how is that benefiting you?
Inventory /implementation for new products
Ease of use and aggregation of discreate sources
What do you like best about the product?
Bring in data from different platform in the enterprise
What do you dislike about the product?
Adoption take a bit of time, but once we had it was easy
What problems is the product solving and how is that benefiting you?
Users can easily find and access the data they need, reducing time spent on data search.
Great tool for analysis
What do you like best about the product?
Microsoft SQL Server Integration Services (SSIS) and Alation serve different but complementary roles in data management and analytics ecosystems. SSIS is a data integration tool primarily used for data extraction, transformation, and loading (ETL), while Alation is a data catalog that helps with data governance, discovery, and collaboration.
What do you dislike about the product?
Complexity and Learning Curve:
SSIS can be complex to set up and use, especially for those new to ETL tools. The learning curve is steep, requiring a good understanding of SQL Server and the SSIS environment.
Limited Data Cataloging Features:
SSIS lacks built-in data cataloging and governance features. It focuses primarily on ETL processes, which means it doesn't provide comprehensive data discovery, lineage tracking, or metadata management like Alation.
Dependency on Microsoft Ecosystem:
While SSIS integrates well with Microsoft products, it may not be as effective or easy to use with non-Microsoft systems. This dependency can be limiting in diverse tech environments.
SSIS can be complex to set up and use, especially for those new to ETL tools. The learning curve is steep, requiring a good understanding of SQL Server and the SSIS environment.
Limited Data Cataloging Features:
SSIS lacks built-in data cataloging and governance features. It focuses primarily on ETL processes, which means it doesn't provide comprehensive data discovery, lineage tracking, or metadata management like Alation.
Dependency on Microsoft Ecosystem:
While SSIS integrates well with Microsoft products, it may not be as effective or easy to use with non-Microsoft systems. This dependency can be limiting in diverse tech environments.
What problems is the product solving and how is that benefiting you?
Integrating Microsoft SQL Server Integration Services (SSIS) with Alation solves the problem of comprehensive data management by combining robust ETL processes with advanced data cataloging and governance. This benefits users by enabling seamless data extraction, transformation, and loading, while ensuring easy data discovery and compliance. For example, an organization can efficiently manage and understand their data assets, ensuring accurate and compliant data flows for business intelligence.
Great solution after a hard time with configurations
What do you like best about the product?
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.
What do you dislike about the product?
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.
What problems is the product solving and how is that benefiting you?
The focus was on data governance and understanding of our data pipelines. It was a valuable step forward in our organization although, some concerns are still in the air regarding the functionalities and limitations of the data transformation process.
Enhancing Data Management
What do you like best about the product?
SSIS integration with Alation excels in providing a clear and comprehensive understanding of data lineage. Alation automatically captures the metadata from SSIS packages, including data sources, transformations, and destinations
What do you dislike about the product?
Setting up and maintaining the integration between SSIS and Alation can be somewhat complex, especially for organizations with large and intricate data environments
What problems is the product solving and how is that benefiting you?
A unified view of data across integration, cataloging, and governance layers streamlines data management and facilitates data-driven decision-making
MICROSOFT SQL
What do you like best about the product?
It allows you to query data large amounts of data.
What do you dislike about the product?
Performance issues due to its declarative nature.
Also select statements are not dynamic.
Also select statements are not dynamic.
What problems is the product solving and how is that benefiting you?
High Speed query processing.
Data integrity.
Easy to use.
Data integrity.
Easy to use.
Microsoft SQL Server Review
What do you like best about the product?
Support large no. of data types. Easy to use. Flexible.
What do you dislike about the product?
No AI
Performance not good with very large database
Performance not good with very large database
What problems is the product solving and how is that benefiting you?
For extracting data from sources.
MS SSIS to Alation is a great tool for data integration and business analytics needs.
What do you like best about the product?
MS SSIS to Alation enables data integration from multiple sources in a seamless fashion. The tool procures a connection with data catalog tool Alation and enables the user to import data from table to file or vice versa or table to table job. It also depicts the lineage between all of these objects including the attribute level mappings and keys. All the more, this product is offered as a SAAS solution wherein the user doesn't have to bother about infrastructure provisioning.
What do you dislike about the product?
MSQL to Alation is an expensive product for small scale start ups. The org needs to explore the features and charateristics before purchasing the same.
What problems is the product solving and how is that benefiting you?
MS SSIS to Alation is helping our analytics team in getting 360 view of the source dataset and the transformed one at the normalized layer. It's able to display the attribute mappings and lineage from the source all the way till the destination including any temporary hops. The tool also assists in the Data quality and governance aspects owing to its integration with Alation and assists the team in holisting aspects of business decision making.
Excellent product!
What do you like best about the product?
Easy to use, good and modern interface...
What do you dislike about the product?
Nothing to declare at the moment. I think, overall, everything is good.
What problems is the product solving and how is that benefiting you?
Data integration in the company.
showing 61 - 70