Introducing G2.ai, the future of software buying.Try now
NLX
Sponsored
NLX
Visit Website
Product Avatar Image
Microsoft SQL Server Integration Services to Alation

By Information Asset, LLC.

Re-claim Profile

Re-claim your company’s G2 profile

This profile hasn’t been active for over a year.
If you work at Microsoft SQL Server Integration Services to Alation, you can re-claim it to keep your company’s information up to date and make the most of your G2 presence.

    Once approved, you can:

  • Update your company and product details

  • Boost your brand's visibility on G2, search and LLMs

  • Access insights on visitors and competitors

  • Respond to customer reviews

  • We’ll verify your work email before granting access.

Re-claim
4.2 out of 5 stars

How would you rate your experience with Microsoft SQL Server Integration Services to Alation?

NLX
Sponsored
NLX
Visit Website

Microsoft SQL Server Integration Services to Alation Pros and Cons: Top 5 Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users appreciate the ease of use in Microsoft SQL Server Integration Services, finding migration and package management seamless and effective. (53 mentions)
Users benefit from streamlined data management with easy integration, ensuring smooth data flow and transformation. (27 mentions)
Users value the easy integrations of SQL Server Integration Services, facilitating smooth data flow and seamless migration. (25 mentions)
Users find the easy integration of Microsoft SQL Server Integration Services with Alation enhances data management and productivity. (22 mentions)
Users appreciate the easy integration of Microsoft SQL Server Integration Services, enhancing data handling and transformation efficiency. (20 mentions)
Users find the complexity of SSIS can lead to performance issues and challenges for inexperienced users when integrating with Alation. (23 mentions)
Users find the complex coding required for SSIS and Alation integration to be time-consuming and challenging. (13 mentions)
Users find the difficult setup of Microsoft SQL Server Integration Services with Alation to be quite challenging and time-consuming. (12 mentions)
Users find the cost of Microsoft SQL Server Integration Services to be high, especially for smaller organizations. (12 mentions)
Users report performance issues with SSIS, especially in memory usage and handling large datasets effectively. (12 mentions)

5 Pros or Advantages of Microsoft SQL Server Integration Services to Alation

1. Ease of Use
Users appreciate the ease of use in Microsoft SQL Server Integration Services, finding migration and package management seamless and effective.
See 53 mentions

See Related User Reviews

Verified User
T

Verified User

Mid-Market (51-1000 emp.)

3.5/5

"SQL and Alation server"

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

With the integration we can handle the different kinds of data and it will be easy and very much steady with data migration.

Aritra D.
AD

Aritra D.

Enterprise (> 1000 emp.)

4.5/5

"Impressive performance of SSMS integration services"

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

seamless migration activities easy package management

2. Data Management
Users benefit from streamlined data management with easy integration, ensuring smooth data flow and transformation.
See 27 mentions

See Related User Reviews

Verified User
T

Verified User

Mid-Market (51-1000 emp.)

3.5/5

"SQL and Alation server"

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

With the integration we can handle the different kinds of data and it will be easy and very much steady with data migration.

Salmanmuhaideen M.
SM

Salmanmuhaideen M.

Mid-Market (51-1000 emp.)

5.0/5

"MSSIS is a Game changer!"

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

A potential benefit is streamlined data management

3. Easy Integrations
Users value the easy integrations of SQL Server Integration Services, facilitating smooth data flow and seamless migration.
See 25 mentions

See Related User Reviews

Verified User
T

Verified User

Mid-Market (51-1000 emp.)

3.5/5

"SQL and Alation server"

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

With the integration we can handle the different kinds of data and it will be easy and very much steady with data migration.

Aritra D.
AD

Aritra D.

Enterprise (> 1000 emp.)

4.5/5

"Impressive performance of SSMS integration services"

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

seamless migration activities easy package management

4. Integrations
Users find the easy integration of Microsoft SQL Server Integration Services with Alation enhances data management and productivity.
See 22 mentions

See Related User Reviews

Verified User
U

Verified User

Small-Business (50 or fewer emp.)

3.5/5

"Microsoft implementation"

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

Very useful and easy to implement and integrate

Venus M.
VM

Venus M.

Small-Business (50 or fewer emp.)

5.0/5

"Efficient Platform for Data handling"

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

I really like that this is the most Powerful platform for building high performance data integrations solutions. and data migration tool that comes w

5. Data Integration
Users appreciate the easy integration of Microsoft SQL Server Integration Services, enhancing data handling and transformation efficiency.
See 20 mentions

See Related User Reviews

Verified User
T

Verified User

Mid-Market (51-1000 emp.)

3.5/5

"SQL and Alation server"

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

With the integration we can handle the different kinds of data and it will be easy and very much steady with data migration.

CC

Clinton Lee C.

Enterprise (> 1000 emp.)

5.0/5

"It's vert useful."

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

Has a Easy integration. Allowing smooth data flow and transformation.

5 Cons or Disadvantages of Microsoft SQL Server Integration Services to Alation

1. Complexity
Users find the complexity of SSIS can lead to performance issues and challenges for inexperienced users when integrating with Alation.
See 23 mentions

See Related User Reviews

Verified User
A

Verified User

Small-Business (50 or fewer emp.)

3.0/5

"User friendly Software"

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

GOKUL D.
GD

GOKUL D.

Mid-Market (51-1000 emp.)

5.0/5

"Excellence of Microsoft SQL"

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

It might be a bit too much to handle for newbies

2. Complex Coding
Users find the complex coding required for SSIS and Alation integration to be time-consuming and challenging.
See 13 mentions

See Related User Reviews

RD

ritik d.

Mid-Market (51-1000 emp.)

5.0/5

"Concise and Keyword-rich"

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

While the benefits are great, there's a catch. SSIS and Alation don't connect seamlessly out of the box. You'll need extra tools or custom coding to b

Verified User
U

Verified User

Small-Business (50 or fewer emp.)

5.0/5

"Microsoft's suite of SQL services within Azure is highly commendable for its breadth and versatility"

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

A potential disadvantage of Microsoft's SQL services is the complexity and cost management associated with navigating and optimizing the various offer

3. Difficult Setup
Users find the difficult setup of Microsoft SQL Server Integration Services with Alation to be quite challenging and time-consuming.
See 12 mentions

See Related User Reviews

AA

Ajenthan A.

Mid-Market (51-1000 emp.)

4.5/5

"Best intergration tools for data management"

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

Two thinks which is complicated. One is difficulty of configuring and maintaining the integration, integrating Microsoft SQL Server Integration Servi

Sagar C.
SC

Sagar C.

Small-Business (50 or fewer emp.)

4.0/5

"Seamless Data Integration and Enhanced Governance with SSIS and Alation"

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.

4. Expensive
Users find the cost of Microsoft SQL Server Integration Services to be high, especially for smaller organizations.
See 12 mentions

See Related User Reviews

Sagar C.
SC

Sagar C.

Small-Business (50 or fewer emp.)

4.0/5

"Seamless Data Integration and Enhanced Governance with SSIS and Alation"

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.

Cynthia H.
CH

Cynthia H.

Mid-Market (51-1000 emp.)

3.5/5

"Microsoft SQL Server Integration Services to Alation Review"

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

The only real downsideof this is the cost. We are currently in a trial period and we will need to prove the value of the purchase if we hope to keep t

5. Performance Issues
Users report performance issues with SSIS, especially in memory usage and handling large datasets effectively.
See 12 mentions

See Related User Reviews

Verified User
U

Verified User

Mid-Market (51-1000 emp.)

5.0/5

"Highly recommend - Most proficient data management SQL server Integration Services"

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

As per my analysis while using this product SSIS. I found that its consume more memory usage specially during the intensive operation and frequently s

Shaun A.
SA

Shaun A.

Mid-Market (51-1000 emp.)

4.0/5

"MICROSOFT SQL"

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

Performance issues due to its declarative nature. Also select statements are not dynamic.

Microsoft SQL Server Integration Services to Alation Reviews (84)

Reviews

Microsoft SQL Server Integration Services to Alation Reviews (84)

4.2
84 reviews
Search reviews
Filter Reviews
Clear Results
G2 reviews are authentic and verified.
Anumesh S.
AS
Senior Business Intelligence Developer
Small-Business (50 or fewer emp.)
"Microsoft SQL Server Integration Service Integration tool"
What do you like best about Microsoft SQL Server Integration Services to Alation?

Microsoft SQL Server Integration Service Integration tool is a good integration tool I reccomned to all integration users Code wise also it's very easy compared to all etl tools Review collected by and hosted on G2.com.

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

everything is good but the UI is slow sometimes. Review collected by and hosted on G2.com.

Laurence R.
LR
Data Analyst
Small-Business (50 or fewer emp.)
"How Microsoft SQL Server Integration Services to Alation changes how we manage data"
What do you like best about Microsoft SQL Server Integration Services to Alation?

The most helpful thing about the Microsoft SQL Server Integration Services to Alation is the efficiency it provides for data integration and data transformation. Handling data, especially large amounts of data, has always been very challenging. With the help of this tool, we can achieve our goal of data management with ease. Review collected by and hosted on G2.com.

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

I think the only downside of the Microsoft SQL Server Integration Services to Alation is the need to research and study how to properly use it to maximize potential of data management. However, such downside is easily resolved by hardwork and determination to fully utilize the tool as it is a very efficient tool. Review collected by and hosted on G2.com.

RD
Data Analyst
Mid-Market (51-1000 emp.)
"Concise and Keyword-rich"
What do you like best about Microsoft SQL Server Integration Services to Alation?

As a data analyst, the best part of linking SSIS with Alation is like having a map for your data. It automatically tracks where your data comes from and what happens to it, saving you time and headaches! Review collected by and hosted on G2.com.

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

While the benefits are great, there's a catch. SSIS and Alation don't connect seamlessly out of the box. You'll need extra tools or custom coding to bridge the gap. This can be technical work and might require some IT muscle. Review collected by and hosted on G2.com.

SS
Technology Analyst
Small-Business (50 or fewer emp.)
"From MSSQL to Alation - Transforming Data Integration Experiences"
What do you like best about Microsoft SQL Server Integration Services to Alation?

Switching from Microsoft SQL Server Integration Services (SSIS) to Alation offers many advantages. Alation provides a simple interface for data integration, making it easier for non-technical users to access and understand data. Its comprehensive analytical capabilities improve decision-making processes. Review collected by and hosted on G2.com.

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

Transitioning from Microsoft SQL Server Integration Services (SSIS) to Alation might present a steep learning curve due to Alation's modern interface and the need for adapting to new workflows, potentially challenging for those accustomed to SSIS's depth and extensive documentation support Review collected by and hosted on G2.com.

NM
Software Development Engineer
Enterprise (> 1000 emp.)
"Efficient Data Management through SSIS and Alation Integration"
What do you like best about Microsoft SQL Server Integration Services to Alation?

It makes data handling a breeze and keeps everything organized and trustworthy. For instance, when I needed to merge multiple data sources for a project, the integration allowed me to do it seamlessly and ensured all the information was accurately tracked and documented. This saved me hours of manual work and gave me confidence in the data's reliability. Review collected by and hosted on G2.com.

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

The setup can be a bit complex and might require some technical know-how. For example, when I first integrated SSIS with Alation, I had to spend a few days learning the configuration steps and troubleshooting some connection issues. Despite the initial learning curve, the benefits have been worth it. Review collected by and hosted on G2.com.

Mattia M.
MM
Project Manager
Enterprise (> 1000 emp.)
"Great tool for analysis"
What do you like best about Microsoft SQL Server Integration Services to Alation?

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. Review collected by and hosted on G2.com.

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

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. Review collected by and hosted on G2.com.

Giridhar P.
GP
Data Engineer
Enterprise (> 1000 emp.)
"MS SSIS to Alation is a great tool for data integration and business analytics needs."
What do you like best about Microsoft SQL Server Integration Services to Alation?

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. Review collected by and hosted on G2.com.

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

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. Review collected by and hosted on G2.com.

Meenakshi S.
MS
Manual Tester
Small-Business (50 or fewer emp.)
"SQL - Specific Sequence"
What do you like best about Microsoft SQL Server Integration Services to Alation?

Microsoft SQL server is a perfect tool which helps us to maintain & Discover Data. This tool not only improves data processing efficiency but also provide us a easy way to search the data.

Microsoft SQL server tool is essential for data migration. Review collected by and hosted on G2.com.

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

Microsoft SQL tool Memory usage is high due to which the SQL server run slow.

Microsoft SQL server integration tool is not compatible when use with JSON. Review collected by and hosted on G2.com.

Venus M.
VM
IT SPECIALIST
Small-Business (50 or fewer emp.)
"Efficient Platform for Data handling"
What do you like best about Microsoft SQL Server Integration Services to Alation?

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. Review collected by and hosted on G2.com.

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

So far I have not encountered any major drawbacks with this tool so I really do not feel any cons of this. Review collected by and hosted on G2.com.

Hazel D.
HD
Outreach Specialist
Mid-Market (51-1000 emp.)
"A very helpful tools for us!"
What do you like best about Microsoft SQL Server Integration Services to Alation?

It makes my work more easier and more convenient. It gives me relevant and legit details of the information that I really needed. I'm so happy using this product and thank you for making this great and one of a kind tools. Review collected by and hosted on G2.com.

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

I don't have specific things that I don't like about it. But there are some things that need to improve. Hope it will go smoothly. Review collected by and hosted on G2.com.