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
 

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.9
Number of Reviews
72
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 9.6%, down 11.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

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.

Quotes from Members

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

Pros

"It's very easy to get started on the solution. It's also easy to maintain, scale, and integrate according to cost factors."
"People are able to scale up, learn it quickly, and start delivering."
"Oracle Integration Cloud Service offers a lot of adaptors."
"The product's initial setup phase is simple."
"It's easy to build an integration and make changes to it."
"In general, there were a lot of great utilities for working with files."
"OIC offers a number of pre-built technology and SaaS adapters for high productivity for a wide range of target systems, both in-house via agents and cloud/SaaS, via a very flexible range of interfaces."
"Technical support responds quickly."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The setup is easy to use and understand."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"It's already very user-friendly and has a good dashboard."
"It is easy to set up. The deployment is also very quick."
 

Cons

"If an inbound file is larger than one GB, it cannot be transformed within Oracle."
"The bulk processing needs improvement."
"With JSON, if the tool provides support similar to XML, then it would be helpful."
"In designer mode, sometimes the browser closure or other unknown issues can cause strange behavior, which requires a restart."
"Oracle needs to ensure that some of the most commonly used types of consumption or services are bundled—for every industry."
"Our client was quite concerned about the cost, which is something that could be reduced."
"We would love to have more and more ready-to-use interfaces from Oracle."
"Configurable timeouts on each connection would be good."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"It would be nice if you could run SSIS on other environments besides Windows."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"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."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"I would like to see more features in terms of the integration with Azure Data Factory."
"I would like to see better integration with Power BI."
 

Pricing and Cost Advice

"The price of Oracle Integration Cloud Service is good. It is reasonable and is priced well for the market segment. The model they use is on a per-package unit and we have a two-year subscription."
"In the case of Oracle Integration Cloud, costs can be "predictable" as far as the platform and infrastructure are concerned."
"The solution is cost-effective."
"Oracle uses a universal credit model for OCI. Clients commit to an annual budget and can choose which products to use and build during their contract period. Billing is based on consumption - you're only billed for the products you use."
"Pricing is not on the economic side since it is a tool for enterprise-sized companies."
"Its pricing is relatively lower than other vendors."
"The price is fair."
"The price is cheaper than all other cloud integration providers."
"SSIS' licensing is a little high, but it gives good value for money."
"The solution comes free of cost."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"The solution is available at a lesser price than that of Informatica."
"Our license with SSIS is annual."
"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."
"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
"People have to opt for a perpetual-based licensing model."
report
Use our free recommendation engine to learn which Integration Platform as a Service (iPaaS) solutions are best for your needs.
823,875 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
43%
Computer Software Company
8%
Financial Services Firm
7%
Manufacturing Company
5%
Financial Services Firm
18%
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.
 

Also Known As

Oracle ICS
SQL Server Integration Services
 

Learn More

 

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.
823,875 professionals have used our research since 2012.