Compare Oracle Data Integrator (ODI) vs. Pentaho Data Integration

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Use Pentaho Data Integration? Share your opinion.
Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration Tools. Updated: August 2020.
438,725 professionals have used our research since 2012.
Quotes From Members

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

Pros
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner.""The most valuable feature that we use is the Knowledge Modules.""It's completely user-friendly.""​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."

More Oracle Data Integrator (ODI) Pros »

"The solution has a free to use community version."

More Pentaho Data Integration Pros »

Cons
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue.""The performance of the user interface is in need of improvement.""Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.""It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"

More Oracle Data Integrator (ODI) Cons »

"It's not very stable, at least not in the case of the community edition. I'm working with the community edition right now and I think perhaps it is because of that it is not very stable, it causes the system to sometimes hang. I'm not sure if this is the case for pair tiers."

More Pentaho Data Integration Cons »

Pricing and Cost Advice
"We found that the cost compared to other integration tools is a little high, but the solution works great."

More Oracle Data Integrator (ODI) Pricing and Cost Advice »

Information Not Available
report
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
438,725 professionals have used our research since 2012.
Answers from the Community
RajneeshShukla
author avatarAThiré
User

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 tools
* ERWIN has a nice one ,

author avatarKaroly Krokovay
User

Hi Rajneesh,
yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hitachi-overview.pdf

And a short description of the community edition: https://www.predictiveanalyticstoday.com/pentaho-community-edition/

And the download link: https://community.hitachivantara.com/s/article/downloads

You can ask more from the great community: https://forums.pentaho.com/

Regards
Károly

author avatarKaroly Krokovay
User

We have experiences only in Pentaho Data Integrator (open source competitor of the Oracle Data Integrator).
But OLAP exporting wasn't in our scope until now.

author avatarRajneeshShukla
Real User

Hi Karoly, Thanks for your input. community: https://forums.pentaho.com/ is not allowing new registrations for new users. I guess they accept queries from customers only and not from any one. Do you know any other forum, community, SMEs contacts who can help on queries?

author avatarRajneeshShukla
Real User

Hi Karoly,

Thanks for your response !!!
Is Pentaho Data Integrator available as freeware/open source tool? Does it come in basic, standard and enterprise editions flavors?

It integrates data from various heterogeneous systems like multiple variety of databases (SQL server, Oracle, DB2 etc), files (XML, XLS, CSV, text etc)? Targets can be any type of DB , file etc.?

What all flavors available like Basic, Standard, Enterprise editions? All editions are free/ open source?

Thanks,
Rajneesh

author avatarRajneeshShukla
Real User

Hi AThire ,
Thanks for your response, I am looking for open source tools.

Regards,
Rajneesh

author avatarRajneeshShukla
Real User

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..?

Questions from the Community
Top Answer: ODI – The difference I see is it is used for data integration to load huge data from across different databases and within the same databases like PLM to BI, EBS to BI, etc. OCI – It is for… more »
Top Answer: 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… more »
Top Answer: Thanks for using ODI, I love it, ODI is one of the good tools for ELT and very strong/powerful with Oracle Target (I have used most of the time). Now your scenario is a good one. Nowadays ODI… more »
Ask a question

Earn 20 points

Ranking
5th
Views
20,948
Comparisons
13,500
Reviews
9
Average Words per Review
516
Avg. Rating
8.6
13th
Views
11,119
Comparisons
9,153
Reviews
1
Average Words per Review
845
Avg. Rating
8.0
Popular Comparisons
Compared 15% of the time.
Compared 21% of the time.
Also Known As
ODIKettle
Learn
Oracle
Hitachi
Overview

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate. 

ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes.  It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c.  Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.

Pentaho data integration prepares and blends data to create a complete picture of your business that drives actionable insights. The complete data integration platform delivers accurate, "analytics ready" data to end users from any source. With visual tools to eliminate coding and complexity, Pentaho puts big data and all data sources at the fingertips of business and IT users alike.

Offer
Learn more about Oracle Data Integrator (ODI)
Learn more about Pentaho Data Integration
Sample Customers
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Top Industries
REVIEWERS
Financial Services Firm30%
Hospitality Company10%
Insurance Company10%
Retailer10%
VISITORS READING REVIEWS
Computer Software Company55%
Comms Service Provider9%
Media Company5%
Retailer5%
REVIEWERS
Comms Service Provider18%
Financial Services Firm18%
Healthcare Company18%
Government9%
VISITORS READING REVIEWS
Computer Software Company36%
Comms Service Provider10%
Media Company10%
Government7%
Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration Tools. Updated: August 2020.
438,725 professionals have used our research since 2012.
Oracle Data Integrator (ODI) is ranked 5th in Data Integration Tools with 9 reviews while Pentaho Data Integration is ranked 13th in Data Integration Tools with 1 review. Oracle Data Integrator (ODI) is rated 8.6, while Pentaho Data Integration is rated 8.0. The top reviewer of Oracle Data Integrator (ODI) writes "I have used it to improve run-times of many corporations' overall integration run-times". On the other hand, the top reviewer of Pentaho Data Integration writes "Free to use, easy to set up, and has a great metadata injection feature". Oracle Data Integrator (ODI) is most compared with Informatica PowerCenter, SSIS, Oracle Integration Cloud Service, Oracle GoldenGate and SAP Data Services, whereas Pentaho Data Integration is most compared with SSIS, Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage and StreamSets.

See our list of best Data Integration Tools vendors and best Cloud Data Integration vendors.

We monitor all Data Integration Tools 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.