What users are saying about
114 Ratings
102 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8 out of 100
114 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 6.8 out of 100

Likelihood to Recommend

Oracle Data Integrator

Oracle Data Integrator is well suited in all the situations where you need to integrate data from and to different systems/technologies/environments or to schedule some tasks. I've used it on Oracle Database (Data Warehouses or Data Marts), with great loading and transforming performances to accomplish any kind of relational task. This is true for all Oracle applications (like Hyperion Planning, Hyperion Essbase, Hyperion Financial Management, and so on).I've also used it to manage files on different operating systems, to execute procedures in various languages and to read and write data from and to non-Oracle technologies, and I can confirm that its performances have always been very good.It can become less appropriate depending on the expenses that can be afforded by the customer since its license costs are quite high.
Paolo Borghi | TrustRadius Reviewer

Pentaho

The tool is fast, visually attractive and intuitive to use, but we also have an implementation of Qlik Sense and Pentaho pales in comparison to the overall capabilities. I recommend the tool, but everyone’s solution need is unique, so it may not be the right fit. Larger tools like Qlik are more versatile and easier to recommend. More expensive, yes, but you usually get what you pay for.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Cloud Data Integration

Oracle Data Integrator
7.8
Pentaho
Pre-built connectors
Oracle Data Integrator
7.8
Pentaho
Connector modification
Oracle Data Integrator
7.8
Pentaho
Support for real-time and batch integration
Oracle Data Integrator
7.5
Pentaho
Data quality services
Oracle Data Integrator
8.6
Pentaho
Data security features
Oracle Data Integrator
7.8
Pentaho
Monitoring console
Oracle Data Integrator
7.5
Pentaho

BI Standard Reporting

Oracle Data Integrator
Pentaho
7.0
Pixel Perfect reports
Oracle Data Integrator
Pentaho
6.4
Customizable dashboards
Oracle Data Integrator
Pentaho
8.4
Report Formatting Templates
Oracle Data Integrator
Pentaho
6.1

Ad-hoc Reporting

Oracle Data Integrator
Pentaho
7.2
Drill-down analysis
Oracle Data Integrator
Pentaho
7.7
Formatting capabilities
Oracle Data Integrator
Pentaho
6.7
Integration with R or other statistical packages
Oracle Data Integrator
Pentaho
7.0
Report sharing and collaboration
Oracle Data Integrator
Pentaho
7.6

Report Output and Scheduling

Oracle Data Integrator
Pentaho
6.9
Publish to Web
Oracle Data Integrator
Pentaho
7.3
Publish to PDF
Oracle Data Integrator
Pentaho
8.6
Report Versioning
Oracle Data Integrator
Pentaho
7.0
Report Delivery Scheduling
Oracle Data Integrator
Pentaho
5.8
Delivery to Remote Servers
Oracle Data Integrator
Pentaho
5.7

Data Discovery and Visualization

Oracle Data Integrator
Pentaho
8.1
Pre-built visualization formats (heatmaps, scatter plots etc.)
Oracle Data Integrator
Pentaho
8.9
Location Analytics / Geographic Visualization
Oracle Data Integrator
Pentaho
7.5
Predictive Analytics
Oracle Data Integrator
Pentaho
7.9

Access Control and Security

Oracle Data Integrator
Pentaho
7.4
Multi-User Support (named login)
Oracle Data Integrator
Pentaho
8.0
Role-Based Security Model
Oracle Data Integrator
Pentaho
8.0
Multiple Access Permission Levels (Create, Read, Delete)
Oracle Data Integrator
Pentaho
7.0
Single Sign-On (SSO)
Oracle Data Integrator
Pentaho
6.5

Mobile Capabilities

Oracle Data Integrator
Pentaho
7.8
Responsive Design for Web Access
Oracle Data Integrator
Pentaho
8.4
Dedicated iOS Application
Oracle Data Integrator
Pentaho
7.0
Dedicated Android Application
Oracle Data Integrator
Pentaho
7.9
Dashboard / Report / Visualization Interactivity on Mobile
Oracle Data Integrator
Pentaho
7.9

Application Program Interfaces (APIs) / Embedding

Oracle Data Integrator
Pentaho
7.1
REST API
Oracle Data Integrator
Pentaho
6.7
Javascript API
Oracle Data Integrator
Pentaho
6.5
iFrames
Oracle Data Integrator
Pentaho
6.7
Java API
Oracle Data Integrator
Pentaho
7.8
Themeable User Interface (UI)
Oracle Data Integrator
Pentaho
5.7
Customizable Platform (Open Source)
Oracle Data Integrator
Pentaho
9.2

Pros

Oracle Data Integrator

  • Oracle Data Integrator nearly addresses every data issue that one can expect. Oracle Data Integrator is tightly integrated to the Oracle Suite of products. This is one of the major strengths of Oracle Data Integrator. Oracle Data Integrator is part of the Oracle Business Intelligence Applications Suite - which is highly used by various industries. This tool replaced Informatica ETL in Oracle Business Intelligence Applications Suite.
  • Oracle Data Integrator comes with many pre-written data packages. If one has to load data from Excel to Oracle Database, there is a package that is ready available for them - cutting down lot of effort on writing the code. Similarly, there are packages for Oracle to SQL, SQL to Oracle and all other possible combinations. Developers love this feature.
  • Oracle Data Integrator relies highly on the database for processing. This is actually an ELT tool rather than an ETL tool. It first loads all the data into target instance and then transforms it at the expense of database resources. This light footprint makes this tool very special.
  • The other major advantage of Oracle Data Integrator, like any other Oracle products, is a readily available developer pool. As all Oracle products are free to download for demo environments, many organizations prefer to play around with a product before purchasing it. Also, Oracle support and community is a big advantage compared to other vendors.
Anonymous | TrustRadius Reviewer

Pentaho

  • Being able to use the OLAP Analyzer tool saved our organization a lot of time in not needing to develop an OLAP tool on our own.
  • The ability to customize the tool and integrate all the internationalization we required was pretty straightforward.
Anonymous | TrustRadius Reviewer

Cons

Oracle Data Integrator

  • ODI does not have an intuitive user interface. It is powerful, but difficult to figure out at first. There is a significant learning curve between usability, proficiency, and mastery of the tool.
  • ODI contains some frustrating bugs. It is Java based and has some caching issues, often requiring you to restart the program before you see your code changes stick.
  • ODI does not have a strong versioning process. It is not intuitive to keep an up to date repository of versioned code packages. This can create versioning issues between environments if you do not have a strong external code versioning process.
James Parks | TrustRadius Reviewer

Pentaho

  • At first, one needs to learn the basic concept of this software before going for the implementation. Once you are an expert on this then you will rock it.
  • Some of the basic features need to be enhanced such as sharing and collaboration capabilities
  • Needs to support automatically generated analytic visualizations or models
Ilham AB | TrustRadius Reviewer

Likelihood to Renew

Oracle Data Integrator

Oracle Data Integrator 10.0
Based on 4 answers
It is maturing and over time will have a good pool of resources. Each new version has addressed the issues of the previous ones. Its getting better and bigger.
Anonymous | TrustRadius Reviewer

Pentaho

Pentaho 8.8
Based on 11 answers
I will use Pentaho until I find a better tool with a better, easier to use report designer client. For now, Pentaho has been the most powerful reporting tool for our clients because of its ability to connect to Odoo, integrate in Odoo (reports are accessible in Odoo) and the flexibility in report design and parameter integration
Adam O'Connor | TrustRadius Reviewer

Usability

Oracle Data Integrator

No score
No answers yet
No answers on this topic

Pentaho

Pentaho 5.0
Based on 1 answer
I would have liked some hands on help in trying to match what Customers were already used to. Plus having a team of Java/BI folks was difficult to assemble since what required to be done in an object oriented fashion could have easily been done via a SQL construct. This hash of technologies was difficult to manage.
Deepak Paramanand | TrustRadius Reviewer

Support Rating

Oracle Data Integrator

No score
No answers yet
No answers on this topic

Pentaho

Pentaho 9.9
Based on 4 answers
We are an Enterprise customer. They handle problems INSTANTLY when they are critical, including initiation an immediate WebEx screen share call when needed. Smaller/less-critical problems are handled within 1-2 days -- and NEVER fall off their radar, no matter how small.As needed, we can also leverage "professional services" from them -- much of which is included in our Enterprise contract. Finally, when a problem I have discovered turns out to be a bug..they create a JIRA for the fix, and make me a watcher. I love seeing notes come in showing me status updates of bugs filed because of something I found. They really are TOP-NOTCH.
Sandro Frattura | TrustRadius Reviewer

Online Training

Oracle Data Integrator

No score
No answers yet
No answers on this topic

Pentaho

Pentaho 9.5
Based on 2 answers
Course Taken: DI1000 Pentaho Data Integration FundamentalsSetup A week before your class started, the instructor will start sending out class material and lab setup instructions. This is helpful so that you understand how the environment is laid out and can start reviewing the content. Ultimately it saved about a 1/2 day trying to setup with 10 other people online which was great! The CourseThe 3-day course was laid out like many other technical classes with 15-30 minutes instruction and 15-60 minutes of lab exercises. The instructor was very knowledgeable with the functionality from version to version and answered questions as we went along. I was amazed at some of the functionality that was available that I was not using at the time and quickly implemented changes to many existing transformations and jobs. The novice users seemed to catch on quickly and more experienced users explained how some of the functionality was used in their home environments. Towards the end there was enough time so that we were able to ask very directed questions about our own environments. Overall, I really found the class to be informative and deliver enough information to be dangerous. My skills improved and I was able to design better and efficient transformations for the HIE. Course Description: https://training.pentaho.com/instructor-led-training/pentaho-data-integration-fundamentals-di1000
Stephanie Dozier | TrustRadius Reviewer

Implementation Rating

Oracle Data Integrator

Oracle Data Integrator 7.0
Based on 1 answer
No answer on this topic is available.

Pentaho

Pentaho 5.0
Based on 2 answers
Get the right people in before starting implementation. Start small and build as you go approach is time consuming and involves lot of rework.Evangalize within the organization the capabilities and limitations equally so that correct delivery expectations are set.Set expectations with the Customer that the tool cannot replace proprietary software in terms of stability/usability and that timelines could change given the new ness of the product.
Deepak Paramanand | TrustRadius Reviewer

Alternatives Considered

Oracle Data Integrator

I have used the Pentaho Data Integrator ETL tools in different projects with the SQL Server Integration Services product from the Microsoft product family. Oracle Data Integrator ETL product is efficient in projects where Oracle databases are heavily used. The end-user interface of SQL Server Integration Services (SSIS) is quite simple and straightforward. It also has an active user community. You can find solutions in these communities for the problems you are experiencing. Since the Pentaho Data Integrator ETL is an open-source application, you can bring your ETL design costs to a very reasonable level. This project will contribute positively to your expenses.
zahit bogus | TrustRadius Reviewer

Pentaho

I was not with the company when they selected Pentaho over any other tool. As per my experience, I would recommend Pentaho. One of the reasons are that it is open source. If you know JAVA, you can create your own plugins. I have found its customer support pretty good and quick. And the most important thing is the cost. If you are not using the DI server, you can just use the community edition and it should fulfil your purpose too.
Nikhil Karkare | TrustRadius Reviewer

Return on Investment

Oracle Data Integrator

  • Lead time to complete data integration and transformation project was reduced due to Oracle Data Integrator tools that helped in setting up transformations relatively quickly once it was set up.
  • Reduced lead time helped in reducing project cost as less resources were spent in data conversion project.
  • Overall data consolidation project resulted in quick integration of data from varied DBMS and data sources.
Anonymous | TrustRadius Reviewer

Pentaho

  • It's cheap. The version we have is free, so it has an immediate positive impact on ROI in that regard. However, a lot of our developers don't like it, which eats away our ability to be effective and productive.
  • It gets the job done. It may not be the most elegant tool, but for our purposes it works. There are probably better tools out there, and Pentaho has limited capabilities, but at the end of the day it works well enough.
Anonymous | TrustRadius Reviewer

Pricing Details

Oracle Data Integrator

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Pentaho

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Oracle Data Integrator
8.4
Pentaho
7.7

Likelihood to Renew

Oracle Data Integrator
10.0
Pentaho
8.8

Usability

Oracle Data Integrator
Pentaho
5.0

Support Rating

Oracle Data Integrator
Pentaho
9.9

Online Training

Oracle Data Integrator
Pentaho
9.5

Implementation Rating

Oracle Data Integrator
7.0
Pentaho
5.0

Add comparison