IBM App Connect vs SSIS comparison

IBM and Microsoft are both solutions in the Cloud Data Integration category. Additionally, 100% of IBM users are willing to recommend the solution, compared to 80% of Microsoft users who would recommend it.

IBM App Connect

Read 23 IBM App Connect reviews

1,886 Views
1,035 Comparison Views

100% willing to recommend

SSIS

Read 71 SSIS reviews

14,990 Views
12,034 Comparison Views

80% willing to recommend

IBM App Connect

SSIS

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between IBM App Connect and SSIS based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed IBM App Connect vs. SSIS Report (Updated: October 2024).

Buyer's Guide

IBM App Connect vs. SSIS

October 2024

Download the complete report

Helped 814,649 peers since 2012

Categories and Ranking

IBM App Connect

Average Rating

8.2

Number of Reviews

Ranking in other categories

Cloud Data Integration (8th)

SSIS

Average Rating

7.8

Number of Reviews

Ranking in other categories

Data Integration (4th)

Featured Reviews

Mehdi El Filahi

Co-Founder at tenekit

Apr 17, 2024

Offers flexible adapters, good scalability but logging can be difficult at times

There is room for improvement in the logging messages. Sometimes, if you put someone new into App Connect, they can abandon it the same day. The logging is really painful. However, IBM has made efforts to integrate with Elasticsearch for logging, so that's an improvement. Overall, the logging can be difficult at times. One more important point is that if IBM improves its CI/CD capabilities, it will make a big difference. Right now, I have to create my own CI/CD setup from scratch for every client, which is inefficient. Back in 2013, I worked with Sonic ESB, and even then, it had CI/CD with Maven. With App Connect, you need to build everything yourself when using tools like Jenkins, Bamboo, or CircleCI. IBM really needs to provide official support for this.

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

"It's a powerful application for collaboration. It has many features for customization and integration."

"There is a friendly interface for configuration, and integration is made easy."

"The most valuable feature is the user-friendliness of the application."

"One of the most beneficial features is the ability to handle multiple communication technologies, like integrating Kafka flows, which is helpful as other teams heavily use it. Regarding error handling, I initially wrote most of the handling myself. While built-in features for error handling are built-in, it largely depends on the developer. We use a custom solution that catches all exceptions, logs them in a database, and replays them as needed. It has been effective for us for over twenty years."

"We use IBM App Connect for the integration between the applications."

"It can handle API conversions with mapping and transformation rules, simplifying the development process."

"The solution is very fast-paced when it comes to making things right. We can quickly download what we need if we need any app migrations for our software business. We can download it plenty of times when we need to use it. It gives us very high speed for delivering any development."

"The most valuable feature is the security."

More IBM App Connect pros

"The performance and stability are good."

"SSIS' most valuable feature is its reporting services."

"The technical support is very good."

"Like most Microsoft products, SSIS is user-friendly and easy to use."

"It is easy to set up the solution."

"The UI is very user-friendly."

"We like that this solution includes a developer edition, free of charge, to allow for training."

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

More SSIS pros

Cons

"IBM needs to enhance and have a stronger offering for the event streaming part because this is the future needed for the containerization and the new integration requirement."

"The interface could be better."

"The product should improve its support."

"I've been using IBM App Connect for about twenty-five years, and while I like it, there are some areas for improvement. The trace policy is ridiculous, and the biggest issue is the cost—it's expensive. People would use it much more if the price point weren't so high."

"One more important point is that if IBM improves its CI/CD capabilities, it will make a big difference. Right now, I have to create my own CI/CD setup from scratch for every client, which is inefficient."

"The addition of string functionality would be a benefit, particularly in the ESQL space that IBM already uses internally."

"The user interface of IBM App Connect can be a little bit more user-friendly, I would say because the first-time developer is onboarded while using IBM App Connect, he or she may get a little intimidated or daunted looking at all the options available or the pipelines, et cetera."

"IBM App Connect should improve security features."

More IBM App Connect cons

"Future releases should improve the data lineage, as it currently is not good."

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

"I would like to see more features in terms of the integration with Azure Data Factory."

"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."

"It hangs a lot of the time."

"It's a legacy tool, that is nearing the end of its useful life."

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

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

More SSIS cons

Pricing and Cost Advice

"IBM App Connect's pricing is high compared to other products."

"The price could be better."

"It is very expensive if we want to scale."

"The cost depends upon the consumer."

"Initially, App Connect was quite expensive because the cost was based on the number of processors we used. However, it's now based on containers, which means we can be more specific about our consumption and get a better price."

"The licensing cost for IBM App Connect is very high."

"App Connect is not cheap."

"The solution's pricing isn't cheap, but you can get good discounts based on your competitive deal."

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

"We have an enterprise license for this solution."

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

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

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

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

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

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

More SSIS pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration 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

Educational Organization

57%

Computer Software Company

Financial Services Firm

Manufacturing Company

Financial Services Firm

17%

Computer Software Company

12%

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about IBM App Connect?

I like the adapters. The adapters help us achieve scalability. If you want to connect to SAP, there's an adapter. Salesforce? There's an adapter. You want to connect to another system? There's like...

See all answers

What is your experience regarding pricing and costs for IBM App Connect?

IBM App Connect's pricing is high compared to other products.

See all answers

What is your primary use case for IBM App Connect?

Our company has a big project for delivery and e-commerce sites. We use IBM App Connect to deliver information to our end users after they buy our products. We get information from many places, suc...

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

webMethods.io vs IBM App Connect

Compared 30% of the time

IBM Cloud Pak for Integration vs IBM App Connect

Compared 26% of the time

MuleSoft Anypoint Platform vs IBM App Connect

Compared 13% of the time

TIBCO BusinessWorks vs IBM App Connect

Compared 9% of the time

IBM InfoSphere DataStage vs IBM App Connect

Compared 5% of the time

More IBM App Connect 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

IBM App Connect

October 2024

Download IBM App Connect product report

Buyer's Guide

SSIS

October 2024

Download SSIS product report

Also Known As

IBM Cast Iron

SQL Server Integration Services

Learn More

IBM

Microsoft

Overview

Rapidly connect public clouds, private clouds and on-premises application

App Connect Professional is IBM’s cloud integration offering which delivers an integration solution
• With ease-of-use, flexibility and increased responsiveness to the evolving business needs, while removing the daunting complexities of integration.
• Provides the powerful combination of a ‘simple integration experience’ for business users looking to automate how their applications talk to each other; coupled with a ‘configuration based integration’ approach for IT.
• App Connect Professional is for the teams and integration developers who need to solve more complex problems and need powerful tooling for integration scenarios

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

United Way of Allegheny County, Saint-Gobain CPS, Ricoh, SunTrust Banks Inc.

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

IBM App Connect vs. SSIS

October 2024

Free Report: IBM App Connect vs. SSIS

Find out what your peers are saying about IBM App Connect vs. SSIS and other solutions. Updated: October 2024.

DOWNLOAD NOW

814,649 professionals have used our research since 2012.

See our IBM App Connect vs. SSIS report.

See our list of best Cloud Data Integration vendors.

We monitor all Cloud Data Integration 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.