Magic xpi Integration Platform vs SSIS comparison

The compared Magic Software and Microsoft solutions aren't in the same category. Magic Software is ranked #25 in PaaS , and holds a 0.6% mindshare in the category. Microsoft is ranked #2 in DI , with an average rating of 7.9, and holds a 7.4% mindshare. Additionally, 79% of Microsoft users are willing to recommend the solution.

Magic xpi Integration Platform

Read 1 Magic xpi Integration Platform review

466 Views
79 Comparison Views

0% willing to recommend

SSIS

Read 74 SSIS reviews

13,061 Views
10,710 Comparison Views

79% willing to recommend

Magic xpi Integration Platform

SSIS

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Magic xpi Integration Platform and SSIS based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Salesforce, SAP and others in Integration Platform as a Service (iPaaS).

To learn more, read our detailed Integration Platform as a Service (iPaaS) Report (Updated: June 2025).

Buyer's Guide

Integration Platform as a Service (iPaaS)

June 2025

Download the complete report

Helped 861,803 peers since 2012

Review summaries and opinions

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

Categories and Ranking

Magic xpi Integration Platform

Average Rating

3.0

Number of Reviews

Ranking in other categories

Integration Platform as a Service (iPaaS) (25th)

SSIS

Average Rating

7.6

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Data Integration (2nd)

Mindshare comparison

Magic xpi Integration Platform and SSIS aren’t in the same category and serve different purposes. Magic xpi Integration Platform is designed for Integration Platform as a Service (iPaaS) and holds a mindshare of 0.6%, up 0.3% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 7.4% mindshare, down 7.7% since last year.

Integration Platform as a Service (iPaaS)

Data Integration

Featured Reviews

it_user977634

Enterprise IT Architect at a consumer goods company with 1,001-5,000 employees

A low-performing integration tool

We use it as an in-house back-type integration tool. It allows us to have different integrations between different systems It does not perform well. It needs more reusable components that are unlimited in time. Furthermore, it relies on the files systems and does not create components, so it is…

Read full review

Sean Achim

Managing Director at Knights Innovation Support Centre

Building impactful organizational KPIs with ease and precision

Stability is rated at 10. One other important aspect I appreciate is that SSAS is included in the base installation of SQL Server. Obviously, it requires installation, but it is readily available, which is a major strength. It's all about setting it up, configuring it, and then using it. If there are additional costs associated with it or separating it as a second product, that would be a disadvantage. The area of improvement is really in education. Microsoft is trying to push everything as a Power BI solution or trying to get people to solve the problems which are solved with SSAS in another space in Power BI, or in Power Pivot, is not enough. There's not enough marketing, conversation, and support around that space. As a result, we end up with people not understanding that you need to build your models correctly, and then they try to model everything inside of Power BI, or another visualization tool, without first building the data model. That leads people to consider alternate solutions because SAP and others argue that their whole thing is in memory, and they disseminate misleading information. Additionally, what would be very helpful is local user group developments, so getting people around the table and teaching them how to use it. That is the biggest problem; it's not the technology itself. The challenge lies in Microsoft withdrawing a lot of the qualifications and watering down its emphasis, leading to a perception that this is supposed to be an elite product.

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

"The stability of the solution is OK."

"It is easy to set up the product."

"The technical support is very good."

"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."

"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."

"SSIS is easy to use."

"The performance and stability are good."

"The product's deployment phase is easy."

"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."

More SSIS pros

Cons

"It is not performing well."

"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."

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

"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."

"I would like to see better integration with Power BI."

"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."

"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."

"At one point, we did have to purchase an add-on."

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

More SSIS cons

Pricing and Cost Advice

Information not available

"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

"We have an enterprise license for this solution."

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

"Our license with SSIS is annual."

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

"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."

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

More SSIS pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Integration Platform as a Service (iPaaS) solutions are best for your needs.

See recommendations

861,803 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

Retailer

14%

Printing Company

14%

Computer Software Company

12%

Performing Arts

Financial Services Firm

18%

Computer Software Company

11%

Government

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

Ask a question

Earn 20 points

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?

Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.

See all answers

Comparisons

Azure Data Factory vs Magic xpi Integration Platform

Compared 36% of the time

MuleSoft Anypoint Platform vs Magic xpi Integration Platform

Compared 33% of the time

Rocket LegaSuite vs Magic xpi Integration Platform

Compared 31% of the time

More Magic xpi Integration Platform Competitors

Informatica PowerCenter vs SSIS

Compared 16% of the time

Talend Open Studio vs SSIS

Compared 11% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

IBM InfoSphere DataStage vs SSIS

Compared 7% of the time

dbt vs SSIS

Compared 7% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Integration Platform as a Service (iPaaS)

June 2025

Download Magic xpi Integration Platform product report

Buyer's Guide

SSIS

June 2025

Download SSIS product report

Also Known As

Magic xpi Integration Platform, iBOLT

SQL Server Integration Services

Overview

Magic xpi Integration Platform is a total solution for integrating, automating and transforming the data of your business applications. The intuitive and easy-to-use interface, including 100+ pre-built connectors, makes it ideal for all types of users, from business users and citizen integrators to IT experts. Magic’s end-to-end tailored solutions are a great fit for all types of IT infrastructures, supporting all of the on-premise, cloud and hybrid integration needs of organizations around the world.

Magic Software

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.

Microsoft

Sample Customers

Godrej Properties

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

Integration Platform as a Service (iPaaS)

June 2025

Download Free Report

Find out what your peers are saying about Microsoft, Salesforce, SAP and others in Integration Platform as a Service (iPaaS). Updated: June 2025.

DOWNLOAD NOW

861,803 professionals have used our research since 2012.

We monitor all Integration Platform as a Service (iPaaS) 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.