Try our new research platform with insights from 80,000+ expert users

Oracle Integration Cloud Service vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

ROI

Sentiment score
8.3
Oracle Integration Cloud boosts ROI by shortening development cycles and reducing operational and administrative efforts through automation.
Sentiment score
7.3
SSIS provides cost-effective data management efficiency, delivering ROI without extra costs apart from the SQL Server license.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
 

Customer Service

Sentiment score
6.0
Oracle Integration Cloud Service support is generally knowledgeable but experiences vary, with users noting improvement needs in response times.
Sentiment score
6.0
Many users prefer online resources over Microsoft's good but occasionally slow and expensive technical support for critical issues.
I find the technical support from Oracle to be good.
 

Scalability Issues

Sentiment score
7.8
Oracle Integration Cloud scales well for medium implementations but faces constraints with large data, impacting performance and licensing cost.
Sentiment score
6.8
SSIS is moderately scalable, better for batch processing, with varied performance depending on infrastructure and implementation challenges.
 

Stability Issues

Sentiment score
8.1
Oracle Integration Cloud Service is stable, with infrequent issues, and users rate its stability highly from seven to ten.
Sentiment score
7.4
SSIS is a reliable, mature tool with minor performance concerns, praised for stability in diverse projects despite occasional issues.
The solution is stable.
It processes large volumes of data quickly.
 

Room For Improvement

Oracle Integration Cloud Service requires enhanced error analysis, documentation, B2B integration, adapters, and JSON support, while addressing file handling limits.
SSIS requires enhancements in error logging, real-time processing, and scalability while depending on external tools increases costs.
The mapping is a bit complex, so configuration is not very easy for a new user.
SSIS has a difficult learning curve when dealing with complex transformations.
 

Setup Cost

Oracle Integration Cloud Service offers flexible, scalable pricing with competitive models and discounts, appealing for enterprise integration despite higher costs.
SSIS is cost-effective for enterprises, bundled with SQL Server, but add-ons can increase costs; overall valued for integration.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
 

Valuable Features

Oracle Integration Cloud Service simplifies enterprise connectivity with intuitive tools, numerous adapters, and serverless setup for seamless integration.
SSIS offers user-friendly, cost-effective ETL solutions with C# scripting, cloud deployment, and extensive support, enhancing data integration and automation.
Additionally, it provides a wide variety of built-in adapters for many cloud providers, such as Azure Blob and AWS S3.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
 

Categories and Ranking

Oracle Integration Cloud Se...
Average Rating
7.8
Reviews Sentiment
7.4
Number of Reviews
37
Ranking in other categories
Integration Platform as a Service (iPaaS) (4th)
SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
73
Ranking in other categories
Data Integration (4th)
 

Mindshare comparison

Oracle Integration Cloud Service and SSIS aren’t in the same category and serve different purposes. Oracle Integration Cloud Service is designed for Integration Platform as a Service (iPaaS) and holds a mindshare of 8.3%, down 10.5% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 7.9% mindshare, down 8.0% since last year.
Integration Platform as a Service (iPaaS)
Data Integration
 

Featured Reviews

Divya Prakash - PeerSpot reviewer
An integration tool that is highly compatible and easy to maintain
Dealing with the large file sizes has occasionally been a challenge, though we have found workarounds. But dealing with large file sizes could be easy in integrations. I have also come across schema files where headers, footers, and bodies are there, but it's not a valid schema. None of the MSCAs are defined properly. In such cases, we have to think of multiple workarounds, such as splitting or merging. But this is a standard requirement for organizations, so custom solutions should be provided. There are cases when the systems don't expect additional MSCAs, or they expect headers, footers, or tags with different values. But this is not a proper XML. So if we are dealing with XML conversions, mapping, and integrations, we have to do some custom work. These are solutions that Oracle can provide.
Sakiru Dosumu - PeerSpot reviewer
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.
report
Use our free recommendation engine to learn which Integration Platform as a Service (iPaaS) solutions are best for your needs.
845,406 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
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…
 

Top Industries

By visitors reading reviews
Educational Organization
44%
Computer Software Company
8%
Financial Services Firm
7%
Manufacturing Company
5%
Financial Services Firm
19%
Computer Software Company
12%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What's the difference between Oracle Integration Cloud Service and Oracle Data Integrator (ODI)?
Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for those who might find the setup to be challenging. There are complications that c...
What do you like most about Oracle Integration Cloud Service?
Oracle Integration Cloud Service offers a lot of adaptors.
What is your experience regarding pricing and costs for Oracle Integration Cloud Service?
It is not really a high price for the value it gives. However, when you start doing the customization, it’s a bit expensive because I need to start provisioning other services before deployment. So...
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...
What do you like most about SSIS?
The product's deployment phase is easy.
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.
 

Also Known As

Oracle ICS
SQL Server Integration Services
 

Overview

 

Sample Customers

Calix, Avaya, Land Lakes, Leader, PWC, Vale
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
Find out what your peers are saying about Oracle Integration Cloud Service vs. SSIS and other solutions. Updated: May 2023.
845,406 professionals have used our research since 2012.