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."The most valuable feature is the security."
"It's a powerful application for collaboration. It has many features for customization and integration."
"It has different type of interfaces that can integrate with companies."
"It's stable to use, connect with the cloud, and to deploy."
"Very scalable, flexible, and user-friendly."
"We use IBM App Connect for the integration between the applications."
"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 likely an adapter for that."
"I would say that the most valuable feature is the array of connectors and integration tools."
"It has good data integration and good processes."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The performance and stability are good."
"It is easy to set up the solution."
"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 have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The performance is good."
"SSIS is easy to use."
"When we do a version upgrade of the system, the platform is kind of complicated."
"It is not easy to deploy. It requires someone with a high level of knowledge in the solution to deploy it, not just anyone can do it."
"The interface could be better."
"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."
"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."
"IBM App Connect should improve security features."
"They reply in one or two hours at most, but they could be better."
"In the next release, I would like to get some quality connectors."
"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."
"The high prices attached to the product can be an area of concern where improvements are required."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"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."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"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."
"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."
IBM App Connect is ranked 11th in Cloud Data Integration with 21 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. IBM App Connect is rated 8.2, while SSIS is rated 7.6. The top reviewer of IBM App Connect writes "Offers flexible adapters, good scalability but logging can be difficult at times". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". IBM App Connect is most compared with IBM Cloud Pak for Integration, Mule Anypoint Platform, webMethods Integration Server, IBM InfoSphere DataStage and TIBCO BusinessWorks, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. 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.