Boomi iPaaS vs SSIS comparison

The compared Boomi and Microsoft solutions aren't in the same category. Boomi is ranked #6 in PaaS , with an average rating of 7.3, and holds a 8.9% mindshare in the category. Microsoft is ranked #4 in DI , with an average rating of 8.0, and holds a 8.6% mindshare. Additionally, 84% of Boomi users are willing to recommend the solution, compared to 80% of Microsoft users who would recommend it.

Boomi iPaaS

Read 26 Boomi iPaaS reviews

2,248 Views
1,550 Comparison Views

84% willing to recommend

SSIS

Read 71 SSIS reviews

14,990 Views
12,034 Comparison Views

80% willing to recommend

Boomi iPaaS

SSIS

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Boomi iPaaS and SSIS based on real PeerSpot user reviews.

Find out in this report how the two Integration Platform as a Service (iPaaS) solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Boomi iPaaS vs. SSIS Report (Updated: May 2023).

Buyer's Guide

Boomi iPaaS vs. SSIS

May 2023

Download the complete report

Helped 815,854 peers since 2012

Categories and Ranking

Boomi iPaaS

Average Rating

7.8

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

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

SSIS

Average Rating

7.8

Number of Reviews

Ranking in other categories

Data Integration (4th)

Mindshare comparison

Boomi iPaaS and SSIS aren’t in the same category and serve different purposes. Boomi iPaaS is designed for Integration Platform as a Service (iPaaS) and holds a mindshare of 8.9%, up 8.4% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 8.6% mindshare, down 9.6% since last year.

Integration Platform as a Service (iPaaS)

Data Integration

Featured Reviews

Berniem Elfrink

Solutions Architect at DXC Technology

Dec 7, 2023

A tool that is easy to use, cost-effective, and offers a large set of functionalities

I use Boomi AtomSphere Integration in my company to manage all types of integrations, including SAP integrations, database integrations, and other enterprise-level integrations The most valuable features of the solution are its mapping functionality and the low-code, no-code nature of the…

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

"I like the tool's optimization feature."

"The best features are that it is a cloud-based and a multi-tenant tool."

"This is a fairly easy-to-use tool for integration which can be self-taught for those with a bit of a technical background."

"Very effective with its drag-and-drop feature."

"The connection configuration part and the drag-and-drop integration module are the most valuable features for me."

"Low-code development is the most valuable feature."

"It is easy to learn and implement."

"The product's integration features are quite rich and low code. It is easy to use."

More Boomi iPaaS pros

"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."

"SSIS integrates well with SQL servers and Microsoft products."

"The technical support is very good."

"The solution is easy to use and developer friendly."

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

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

"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 most valuable features of SSIS are that it works with the query language and it can import data from different sources."

More SSIS pros

Cons

"There are very few string handling functions and few mathematical functions are available."

"They need to introduce more configurable functions to remove scripting or coding. Scripting should be minimized. It should have exhaustive functions. Currently, it lacks in this aspect."

"The product could be a little bit more user-friendly."

"The deployment was simple, but the implementation is missing a lot of capabilities."

"In my experience, I haven't encountered any major issues with the tool. However, there could be a learning curve for new users, especially depending on which tool you're using. For example, I've used MuleSoft in the past, which is more code-oriented and requires knowledge of Java. Transitioning to Boomi AtomSphere Integration took me a couple of months because of differences in terminology."

"The API can use some work to come up to speed with the competition but Dell has plans and is working on resolving that."

"The high price of the solution is an area of concern where improvements are required."

"It crashes if we run high-volume integration."

More Boomi iPaaS cons

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

"It hangs a lot of the time."

"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."

"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."

"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."

"I would like to see better technical documentation because many times information is missing."

"Options for scaling could be improved."

"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."

More SSIS cons

Pricing and Cost Advice

"The cost of the solution is in the neighborhood of $20,000 annually. There are no costs above the standard licensing fee."

"I rate the product's price an eight on a scale of one to ten, where one is cheap and ten is expensive."

"The pricing is not reasonable at all. It's very high."

"Boomi AtomSphere Integration is expensive. I rate its pricing an eight out of ten."

"When it comes to pricing, it's not so much about being less expensive as it is about how they don't tie to the hardware on the underlined VMware that you run on, as other vendors do"

"AtomSphere Integration's pricing is competitive, and I would rate it seven out of ten."

"They do not charge by the number of people using the software (client-server model), but rather they charge based on the number of connections used. This makes it very cost effective."

"Boomi AtomSphere Integration is a relatively cheap and cost-effective product compared to other products like SAP or Oracle."

More Boomi iPaaS pricing and cost advice

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

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

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

"We have an enterprise license for this solution."

"The solution is available at a lesser price than that of Informatica."

"The solution comes free of cost."

"This solution is included with the MSSQL server package."

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

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

815,854 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

Computer Software Company

18%

Manufacturing Company

10%

Financial Services Firm

Government

Financial Services Firm

17%

Computer Software Company

12%

Government

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Boomi AtomSphere Integration?

The tool's most valuable features I've found are related to debugging and testing. It makes it easy to track execution, documents, and process history. This functionality is particularly useful for...

See all answers

What is your experience regarding pricing and costs for Boomi AtomSphere Integration?

Boomi AtomSphere Integration is a relatively cheap and cost-effective product compared to other products like SAP or Oracle. I don't know the exact price of the product.

See all answers

What needs improvement with Boomi AtomSphere Integration?

In my experience, I haven't encountered any major issues with the tool. However, there could be a learning curve for new users, especially depending on which tool you're using. For example, I've us...

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

Microsoft Azure Logic Apps vs Boomi iPaaS

Compared 23% of the time

webMethods.io vs Boomi iPaaS

Compared 8% of the time

AWS Glue vs Boomi iPaaS

Compared 6% of the time

SEEBURGER Business Integration Suite vs Boomi iPaaS

Compared 5% of the time

Oracle Integration Cloud Service vs Boomi iPaaS

Compared 4% of the time

More Boomi iPaaS 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

Boomi iPaaS

November 2024

Download Boomi iPaaS product report

Buyer's Guide

SSIS

October 2024

Download SSIS product report

Also Known As

Boomi

SQL Server Integration Services

Learn More

Boomi

Microsoft

Overview

The Boomi AtomSphere integration platform as a service (iPaaS) supports all your application integration processes – between cloud platforms, software-as-a-service applications, and on-premises systems. Your entire team has online access to a powerful range of integration and data management capabilities, that can be realized in a fraction of the time of legacy middleware technologies.

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

DocuSign Inc., Innotas, Certent, Renesas Electronics America (REA), Kelly-Moore Paints, Mindjet, City of McKinney, Ritchie Bros. Auctioneers (RBA), Daylight Transport, A10 Networks

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

Boomi iPaaS vs. SSIS

May 2023

Free Report: Boomi iPaaS vs. SSIS

Find out what your peers are saying about Boomi iPaaS vs. SSIS and other solutions. Updated: May 2023.

DOWNLOAD NOW

815,854 professionals have used our research since 2012.

See our Boomi iPaaS vs. SSIS report.

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.