Sep 09, 2021
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.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
It has helped us save a lot of time by automating repetitive data processes and reducing manual interventions.
They didn't want to use separate ETL tools for MDM or for TMC and data preparation, which is all included in one package.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
The technical support of Oracle is very good; they support the Oracle Data Integrator (ODI) solution effectively.
The support team is responsive when we raise issues, and they usually provide clear guidance or solutions.
The customer support for Talend Data Integration is very good; whenever I raise a ticket in the customer portal, I immediately receive an email, and follow-up communication is prompt.
The scalability and the ability to handle multiple workloads of several parallel ETL jobs could use improvement.
By using features like job parallelization and modular design, we can expand our data flows without having to rebuild everything.
The scalability of Talend Data Integration is good; if it weren't scalable, it wouldn't be reliable.
In terms of performance stability, I have not experienced any downtimes, crashes, or performance issues with the Oracle Data Integrator (ODI).
Once the jobs are properly designed and deployed, they run reliably without major issues.
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.
It would be excellent not to have to go into different areas to perform different activities but rather have a user-defined interface where we can configure a job, run it, monitor it, link packages, and link subprocesses all in one frame.
It would be great to have more ready-to-use connectors for modern cloud and SaaS platforms.
Talend Data Integration can be improved by reducing the license cost, as it is a bit high compared to other tools, which can be a burden for small-scale companies wanting to buy a license.
Regarding ETL, Talend Data Integration is great, but concerning real-time data processing, people are not really sure about Talend Data Integration or might not know how it provides such types of flexibilities.
ODI is cheaper compared to Informatica PowerCenter and IBM DataStage.
The pricing aspect of Oracle Data Integrator (ODI) is reasonable; it brings significant value to the table.
My experience with Talend Data Integration's pricing, setup cost, and licensing is that it is a bit higher compared to other tools, making it not very affordable.
The main benefits that Oracle Data Integrator (ODI) brings to the table include data quality, data completeness functionality, metadata management, and the reverse engineering feature, which allows integrating the metadata of diversified data sources with a single click.
Oracle Data Integrator (ODI) is powerful and strong if my system uses Oracle components for environments like OLTP, enterprise data warehouse, or data marts.
By automating daily data loading processes, we reduced manual effort by around three or four hours per day, which saved roughly 60 to 80 hours per month.
Flexibility is a key feature I appreciate about Talend Data Integration, especially the integration of Java within it and the ease of integrating with multiple source repositories such as GitHub and Bitbucket.
The best feature of Talend Data Integration is its multiple data DB components; we have almost all the components and also cloud versions, with TMC allowing us to perform data preparation and data stewardship.
| Company Size | Count |
|---|---|
| Small Business | 25 |
| Midsize Enterprise | 12 |
| Large Enterprise | 43 |
| Company Size | Count |
|---|---|
| Small Business | 2 |
| Midsize Enterprise | 2 |
| Large Enterprise | 4 |
Oracle Data Integrator (ODI) is a data integration software solution that provides a unified infrastructure to streamline data and application integration projects. It uses a powerful design approach to data integration, which separates the declarative rules from the implementation details. The solution is based on a unique ELT (Extract Load Transform) architecture, eliminating the need for a standalone ETL server and proprietary engine.
Oracle Data Integrator Features
ODI has many valuable key features. Some of the most useful ones include:
Oracle Data Integrator Benefits
There are many benefits to implementing ODI. Some of the biggest advantages the solution offers include:
Reviews from Real Users
Below are some reviews and helpful feedback written by PeerSpot users currently using the Oracle Data Integrator (ODI) solution.
Brian D., Business Process and Strategy Specialist Advisor at NTTData, says, “The Knowledge Module (KM) is my favorite feature of ODI. This is where I learned how to use variables to make jobs dynamic. I took that knowledge and created a KM that would go into iTunes and pull the sales of eBooks. Making something that is reusable, like a KM, is important to not only reduce build time but also maintenance in the future.”
Ashok S., Applications Support Manager at a marketing services firm, mentions, "The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
Talend Data Integration efficiently handles data transformation and integration with ease, supporting complex business needs. It enables seamless data management across all sources.
Talend Data Integration offers a robust platform for managing and transforming data. It connects disparate systems, enabling data flow across various environments. Users benefit from its ability to streamline processes and improve data accuracy. Its user-friendly interface and flexibility make it a preferred choice for data integration experts.
What are the key features of Talend Data Integration?In finance, Talend Data Integration enhances transaction data processing and compliance reporting. In healthcare, it ensures accurate patient data management, while in retail, it optimizes inventory and customer data analysis. Its adaptability makes it valuable across multiple sectors, addressing specific industry requirements.
We monitor all Cloud Data Integration 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.
