We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"Oracle Data Integrator helps us build tables and data marts and allows us to schedule them daily, for nearly real-time data warehousing."
"The solution is easy to manage and offers good integration. You can run all the tasks one by one which is really helpful, and pick the day and time to do so."
"Oracle integration cloud has got the adapters for all their products, which makes integration faster."
"The solution has a free to use community version."
"The amount of data that it loads and processes is good."
"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."
"I've found technical support not very effective. They should work to improve their services."
"The pricing could be more competitive."
"Bulk uploading can be a problem when you hit the upper limit."
"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."
"I would like to see improvements made for real-time data processing."
"I'm still in the very recent stage concerning Pentaho Data Integration, but it can't really handle what I describe as "extreme data processing" i.e. when there is a huge amount of data to process. That is one area where Pentaho is still lacking."
"The price of the regular version is not reasonable and it should be lower."
"Sometimes we provide the licenses or the customer can procure their own licenses. Previously, we had an enterprise license. Currently, we are on a community license as this is adequate for our needs."
Earn 20 points
Oracle Data Integrator Cloud Service provides pushdown data processing; high performance ETL with less data movement which is best for the Cloud. Oracle Data Integrator Cloud Service executes data transformations where the data lies without having to copy data unnecessarily to remote locations.
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.
Oracle Data Integrator Cloud Service is ranked 12th in Cloud Data Integration with 3 reviews while Pentaho Data Integration is ranked 16th in Data Integration Tools with 3 reviews. Oracle Data Integrator Cloud Service is rated 8.0, while Pentaho Data Integration is rated 7.6. The top reviewer of Oracle Data Integrator Cloud Service writes "Provides quick and simple integration with all adapters included". 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 Cloud Service is most compared with Azure Data Factory, Oracle Integration Cloud Service, Boomi AtomSphere Integration and IBM InfoSphere DataStage, whereas Pentaho Data Integration is most compared with Talend Open Studio, SSIS, Informatica PowerCenter, Oracle Data Integrator (ODI) and IBM InfoSphere DataStage.
See our list of best Data Integration Tools 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.