Altair Monarch vs SSIS comparison

The compared Altair and Microsoft solutions aren't in the same category. Altair is ranked #5 in DPT , with an average rating of 9.0, and holds a 11.0% mindshare in the category. Microsoft is ranked #4 in DI , with an average rating of 8.0, and holds a 8.6% mindshare. Additionally, 100% of Altair users are willing to recommend the solution, compared to 80% of Microsoft users who would recommend it.

Altair Monarch

Read 1 Altair Monarch review

252 Views
188 Comparison Views

100% willing to recommend

SSIS

Read 71 SSIS reviews

14,990 Views
12,034 Comparison Views

80% willing to recommend

Altair Monarch

SSIS

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Altair Monarch and SSIS based on real PeerSpot user reviews.

Find out what your peers are saying about Alteryx, SAS, Bright Data and others in Data Preparation Tools.

To learn more, read our detailed Data Preparation Tools Report (Updated: October 2024).

Buyer's Guide

Data Preparation Tools

October 2024

Download the complete report

Helped 814,649 peers since 2012

Categories and Ranking

Altair Monarch

Average Rating

9.0

Number of Reviews

Ranking in other categories

Data Preparation Tools (5th)

SSIS

Average Rating

7.8

Number of Reviews

Ranking in other categories

Data Integration (4th)

Mindshare comparison

Altair Monarch and SSIS aren’t in the same category and serve different purposes. Altair Monarch is designed for Data Preparation Tools and holds a mindshare of 11.0%, up 5.7% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 8.6% mindshare, down 9.6% since last year.

Data Preparation Tools

Data Integration

Featured Reviews

reviewer2082057

Account Manager

Jan 25, 2023

In 10 minutes, I can do work that would take me two or three hours in another solution.

We use Monarch for account reconciliation. We have several accounts from last year that carry over into this year, so we do reconciliation to see if there are any outliers compared to last year and if the system is automatically picking up for renewals. Monarch is used for minor reconciliation work…

Read full review

Sakiru Dosumu

Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.

Mar 1, 2024

Its ability to transform and transport data is extremely valuable

We use SSIS for data extraction, transformation, and loading processes. This includes extracting data from various sources like Oracle and SQL Server, and then transforming it for use in reporting tools like Power BI dashboards. While we haven't directly migrated data between databases using SSIS…

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"Monarch lets you quickly extract in your preferred format."

"The initial setup of this solution is very straightforward."

"The scalability of SSIS is good."

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

"The performance is good."

"It has good data integration and good processes."

"The setup is straightforward. It's very easy to install."

"We can connect with multiple data sources easily using an external connector in SSIS."

"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."

More SSIS pros

Cons

"I rate Altair Monarch seven out of 10 for affordability. Recently, the pricing model changed from end-user licensing to a concurrent licensing model."

"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."

"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."

"Integration and the user interface are areas with certain shortcomings that require some improvements."

"We've had issues in terms of the amount of data that is transferred when we are scheduling."

"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."

"SSIS has room for improvement, mainly because the overall package can be buggy. It often locks up, requiring a restart, which is annoying. However, since it's free, we tolerate these performance issues. I'd like to see better debugging tools in future releases and improvements in API calls; It would be helpful if SSIS had a built-in API engine so we wouldn't have to rely solely on database connections."

"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."

"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."

More SSIS cons

Pricing and Cost Advice

Information not available

"It would be beneficial if the solution had a less costly cloud offering."

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."

"People have to opt for a perpetual-based licensing model."

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

"The solution comes free of cost."

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

"SSIS' licensing is a little high, but it gives good value for money."

More SSIS pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Preparation Tools solutions are best for your needs.

See recommendations

814,649 professionals have used our research since 2012.

Comparison Review

it_user90069

BI Expert at a healthcare company with 1,001-5,000 employees

Feb 20, 2014

Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities

Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

30%

Manufacturing Company

11%

Government

Retailer

Financial Services Firm

17%

Computer Software Company

12%

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What do you like most about Altair Monarch?

Monarch lets you quickly extract in your preferred format.

See all answers

What is your experience regarding pricing and costs for Altair Monarch?

I rate Altair Monarch seven out of 10 for affordability. Recently, the pricing model changed from end-user licensing to a concurrent licensing model.

See all answers

What is your primary use case for Altair Monarch?

See all answers

Which is better - SSIS or Informatica PowerCenter?

SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...

See all answers

What do you like most about SSIS?

The product's deployment phase is easy.

See all answers

What is your experience regarding pricing and costs for SSIS?

The solution comes free of cost.

See all answers

Comparisons

Alteryx vs Altair Monarch

Compared 44% of the time

SAS Enterprise Guide vs Altair Monarch

Compared 34% of the time

ETL Solutions Transformation Manager vs Altair Monarch

Compared 22% of the time

More Altair Monarch Competitors

Informatica PowerCenter vs SSIS

Compared 24% of the time

Talend Open Studio vs SSIS

Compared 13% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

AWS Glue vs SSIS

Compared 5% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Data Preparation Tools

October 2024

Download Altair Monarch product report

Buyer's Guide

SSIS

October 2024

Download SSIS product report

Also Known As

Monarch Data Pump

SQL Server Integration Services

Learn More

Altair

Microsoft

Overview

Datawatch Monarch is an application that runs on your Windows desktop and as soon as you drop a file or web page onto the canvas it automatically begins to extract into analytics-ready rows and columns. You can also connect to all major relational, big data, and over 30 other sources, but often the most important information you need is locked away in existing reports or difficult sources that seem impossible to use without re-keying the data.

SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

Sample Customers

MasterCard

1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo

Buyer's Guide

Data Preparation Tools

October 2024

Download Free Report

Find out what your peers are saying about Alteryx, SAS, Bright Data and others in Data Preparation Tools. Updated: October 2024.

DOWNLOAD NOW

814,649 professionals have used our research since 2012.

We monitor all Data Preparation Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.