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

Oracle Data Integrator (ODI) vs SSIS comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 12, 2025

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
7.6
Oracle Data Integrator provides high ROI, reducing custom ETL efforts and costs, with Cloud version enhancing implementation and efficiency.
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.9
ODI support gets mixed reviews; quick solo responses but struggles in multi-product setups, often leading users to forums.
Sentiment score
6.0
Many users prefer online resources over Microsoft's good but occasionally slow and expensive technical support for critical issues.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
 

Scalability Issues

Sentiment score
7.6
Oracle Data Integrator scales well, integrating with WebLogic, while configuration and setup impact its performance in various environments.
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
7.3
Oracle Data Integrator is stable and efficient, with minor configuration challenges resolved in newer versions like 12.1.3 and 12cR2.
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

ODI users seek improved performance, usability, integration, and cost-efficiency, with better error handling, authentication, and automation features.
SSIS requires enhancements in error logging, real-time processing, and scalability while depending on external tools increases costs.
If I use a source system like Oracle and a target system like Teradata, ODI will still run, but it struggles a bit with different infrastructures.
SSIS has a difficult learning curve when dealing with complex transformations.
 

Setup Cost

Oracle Data Integrator has complex, costly pricing with various licensing options; discounts and packages can reduce expenses for enterprises.
SSIS is cost-effective for enterprises, bundled with SQL Server, but add-ons can increase costs; overall valued for integration.
ODI is cheaper compared to Informatica PowerCenter and IBM DataStage.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
 

Valuable Features

Oracle Data Integrator features flexible, customizable integration with diverse technologies, enhancing performance and efficiency in data integration tasks.
SSIS offers user-friendly, cost-effective ETL solutions with C# scripting, cloud deployment, and extensive support, enhancing data integration and automation.
Oracle Data Integrator (ODI) is powerful and strong if my system uses Oracle components for environments like OLTP, enterprise data warehouse, or data marts.
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 Data Integrator (ODI)
Ranking in Data Integration
7th
Average Rating
8.2
Reviews Sentiment
6.8
Number of Reviews
71
Ranking in other categories
No ranking in other categories
SSIS
Ranking in Data Integration
4th
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
73
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of April 2025, in the Data Integration category, the mindshare of Oracle Data Integrator (ODI) is 4.6%, up from 4.4% compared to the previous year. The mindshare of SSIS is 7.9%, down from 8.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Q&A Highlights

RS
Sep 09, 2021
 

Featured Reviews

Jagadish Sau - PeerSpot reviewer
Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved
My company has around ten users of Oracle Data Integrator (ODI). A team of two to five people handles the deployment and maintenance of the solution. The current client of my company has this plan of moving to the cloud, with the possibility of replacing the ETL tool altogether, which could mean that more data is coming up, so there may be a plan to increase the usage of Oracle Data Integrator (ODI). My advice to others looking into implementing Oracle Data Integrator (ODI) is that if your database is on Oracle or SQL server, then Oracle Data Integrator (ODI) is a good tool to use. My rating for Oracle Data Integrator (ODI) is seven out of ten.
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 Data Integration solutions are best for your needs.
845,040 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…
 

Answers from the Community

RS
Sep 9, 2021
Sep 9, 2021
There are two products I know about * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cubes . price approx 40K$, works with tables . Attunity (Bought by Qlik) : technology agnostic , nice web interface , expensive > 100K€. Works with transaction logs There are many other pure ETL ...
2 out of 12 answers
SS
Apr 6, 2020
We usually use Talend. Look here: https://community.talend.com/t5/Design-and-Development/The-way-from-OLTP-to-OLAP/td-p/116719
RS
Apr 7, 2020
Thanks Stefan !!! May I know if Talend is opensource /free ? It is available in all 3 editions - basic , standard end enterprise? it is capable to read data from all heterogeneous system like various types of data bases and files etc..?
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
12%
Government
10%
Manufacturing Company
8%
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 Data Integrator (ODI)?
In comparison with other products of the same range, licensing mode is really attractive, no need to license according technology/topology to be used and an incredible Versatility to build any Data...
What is your experience regarding pricing and costs for Oracle Data Integrator (ODI)?
The pricing of Oracle Cloud Services is not favorable as it charges daily regardless of usage, unlike competitors who charge only for days used.
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

ODI
SQL Server Integration Services
 

Overview

 

Sample Customers

Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
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 Data Integrator (ODI) vs. SSIS and other solutions. Updated: February 2025.
845,040 professionals have used our research since 2012.