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 Service provides substantial ROI through autonomous services that reduce development time and operational overhead.
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
5.5
Oracle Integration Cloud Service's support has mixed reviews, noting delays, inconsistencies, and expertise issues, but high-priority issues get fast assistance.
Sentiment score
6.0
Many users prefer online resources over Microsoft's good but occasionally slow and expensive technical support for critical issues.
 

Scalability Issues

Sentiment score
7.8
Oracle Integration Cloud Service scales well and is versatile, but has data size limitations and occasional performance issues.
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 and reliable, with occasional downtime and performance issues, rated 7-10 out of 10.
Sentiment score
7.4
SSIS is a reliable, mature tool with minor performance concerns, praised for stability in diverse projects despite occasional issues.
It processes large volumes of data quickly.
 

Room For Improvement

Oracle Integration Cloud Service needs better AI integration, enhanced tools, reduced costs, improved support, comprehensive documentation, and flexible pricing.
SSIS requires enhancements in error logging, real-time processing, and scalability while depending on external tools increases costs.
SSIS has a difficult learning curve when dealing with complex transformations.
 

Setup Cost

Oracle Integration Cloud Service offers predictable pricing with various models and discounts, but costs can increase with extensive customization.
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 offers scalable, user-friendly integration with robust error handling, pre-built APIs, and low-code capabilities for ease of use.
SSIS offers user-friendly, cost-effective ETL solutions with C# scripting, cloud deployment, and extensive support, enhancing data integration and automation.
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
36
Ranking in other categories
Integration Platform as a Service (iPaaS) (3rd)
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.8% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 8.0% mindshare, up 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.
842,592 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
6%
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.
842,592 professionals have used our research since 2012.