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.5, and holds a 9.1% mindshare in the category. Microsoft is ranked #4 in DI , with an average rating of 7.7, and holds a 8.8% mindshare. Additionally, 84% of Boomi users are willing to recommend the solution, compared to 79% of Microsoft users who would recommend it.

Boomi iPaaS

Read 26 Boomi iPaaS reviews

2,160 Views
1,514 Comparison Views

84% willing to recommend

SSIS

Read 72 SSIS reviews

14,200 Views
11,375 Comparison Views

79% 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 823,875 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.6

Reviews Sentiment

6.9

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 9.1%, up 8.3% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 8.8% mindshare, down 9.5% since last year.

Integration Platform as a Service (iPaaS)

Data Integration

Featured Reviews

Subhajit Bhattacharjee

Lead Consultant at Itcinfotech

Exceptional drag-and-drop integration module

It would be great to have more assistance and credit services for additional features. For instance, virtual class initials are available but not for backend processing moves. Making that more visible, like other Azure products, would be helpful. Moreover, the documentation is good, but it could be improved. It is changing every day, and I sometimes find that it's not updated enough or some code levels are not included.

Read full review

Sakiru Dosumu

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

Its ability to transform and transport data is extremely valuable

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

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 Salesforce and NetSuite Application specific “connectors” provide a layer of abstraction on top of the SOAP-based APIs to streamline integration development."

"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 identifying issues with data and providing insights to the business."

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

"The most valuable feature of the solution is its monitoring part to debug certain issues and find problems."

"Extremely flexible for any kind of integration between systems."

"The integration landscape has become complex, and having a data strategy with unified data models would make integration easier for any platform, including Boomi."

"The platform is user-friendly."

"The iPaaS functionality is very mature. The browser based IDE is also very mature and stable."

More Boomi iPaaS pros

"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."

"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."

"The performance is good."

"The data reader is the most valuable feature."

"The most valuable features of this solution are the fast insert and fuzzy logic matching."

"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."

"The most important features are it works well and provides self-service BI."

"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."

More SSIS pros

Cons

"Lots of enhancements are needed in the API portal so that the developers can view the definitions, try out the APIs, etc."

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

"In day-to-day operations, tracking transactions is a major challenge. It takes hours to track a single transaction. It is not a straightforward process."

"The most valuable features of Boomi are the integration capabilities, the Data Hub product, and the UDI integration."

"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 product's UI could be more convenient."

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

More Boomi iPaaS cons

"It needs more integration tools, so you can connect to different sources."

"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."

"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 is not stable."

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

"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."

"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."

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

More SSIS cons

Pricing and Cost Advice

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

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

"The pricing is a bit complex. While the entry fee may be lower than other solutions, it could be expensive depending on your usage."

"It is an expensive platform."

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

"Approximately 20k annually."

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

"There could be an easy-to-understand licensing model."

More Boomi iPaaS pricing and cost advice

"All of my clients have this product included as part of their Microsoft license."

"SSIS is a cheaper option compared to the cost of other ETL tools."

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

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

"Our license with SSIS is annual."

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

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

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

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

823,875 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

17%

Manufacturing Company

10%

Financial Services Firm

Government

Financial Services Firm

18%

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?

The integration landscape has become complex, and having a data strategy with unified data models would make integration easier for any platform, including Boomi.

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 24% of the time

webMethods.io vs Boomi iPaaS

Compared 8% of the time

SEEBURGER Business Integration Suite vs Boomi iPaaS

Compared 6% of the time

AWS Glue vs Boomi iPaaS

Compared 6% of the time

MuleSoft Anypoint Platform vs Boomi iPaaS

Compared 4% of the time

More Boomi iPaaS Competitors

Informatica PowerCenter vs SSIS

Compared 23% of the time

Talend Open Studio vs SSIS

Compared 13% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 8% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

AWS Glue vs SSIS

Compared 4% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Boomi iPaaS

December 2024

Download Boomi iPaaS product report

Buyer's Guide

SSIS

November 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

823,875 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.