Oracle Data Integrator (ODI) vs. Talend Data Fabric

I tried various ETL tools and here is [where and] why I recommend Oracle Data Integrator. 1. When you want to process structured data from different databases - Teradata, Exadata, DB2, SQL, Oracle etc. 2. Oracle Data Integrator supports all platforms, hardware, and OS. This is a major advantage compared to other leading tools. 3. The ELT architecture giving a cutting edge performance over leading ETL tools. There is no need to align Oracle Data Integrator between source and target. ODI uses the source and target servers to perform complex transformations. 4. Speeds up the development and maintenance by reducing the code that developers need to write

Incentivized

The best scenario that I see as productive is having several sources of information, the tool allows me to consolidate in a single income channel allowing me to maintain the integrity of the information, I like the treatment of financial data since speed and accuracy are needed in the accounting records. I believe that in any industry this tool would be 100% productive.

Incentivized

• Converts data from various sources into one target format using various business logic rules and integrates with various DBMS types.
• Transformed data from DB2, SQL Server and other Oracle databases into flat files and then used ETL jobs to load into Oracle DB target
• Data Integrator and Goldengate were used together to accomplish the data movement needed for business and data consolidation in live environment. Data Integrator helped with development and in reducing lead time to convert data into target.

Incentivized

• It supports a wide variety of connectors (Systems/endpoints)
• It provides great flexibility for developers as it not only has a lot of predefined ready to use the function but also provides the ability to use complex java code within the platform. Great tool if you have good developers available.

Incentivized

• Oracle support is not the best when needing help with the system
• The documentation is also very poor and takes very long to generate
• Some parts of it are not intuitive to use and get hard to troubleshoot
• Like other Oracle products, you must have very, very thorough knowledge about their systems to understand
• Like all Oracle products, cost is high

Incentivized

• Bugs: Came across some of the bugs in transforming column datatype especially on text.
• Speed: Sometimes, bandwidth fluctuates in the data transfer as identified from logs, but so far so good.
• Connector support: So far have not seen Actian Matrix plugins, could be useful.

Incentivized

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.

Lack of report export and publication! Steep learning curve!

At this moment the usability of Talend Data Quality is optimal, too bad I cannot say the same in the first three months, it was always a problem due to its steep learning curve, but what matters is being able to use it effectively at this precise moment.

Incentivized

Talend Data Quality gave us direct help in the learning process and prevented us from taking many more months to adapt and I appreciate this from the heart, I think that thanks to the support we can have very detailed reports that help increase the use of Talend Data Quality in the company.

Incentivized

Talend Data Integrator has been evaluated during the setup of the architecture for a customer, in comparison to ODI, since it's an open source ETL. But, differently from the meaning of "open source", it has licence costs too that aren't that different from ODI ones. Moreover, the other components of the business intelligence architecture of the customer were Oracle, so we thought that ODI would suit at best with them, more than a different vendor software.

Incentivized

1) Talend offers more than 200 palettes, but most of them are repeated. For Example in Pentaho, we can use a single component ( Microsoft Excel input ) and we can get the data, sheet name, file name, and all other things like using a wildcard, etc. 2. Talend is an open-source tool that makes it easily accessible.

Incentivized

• Oracle Data Integrator helps provide a business with the data it needs to defend the decisions it makes.
• Oracle Data Integrator allows you to analyze data from what can be separate, different, and often outdated data sources. It allows you to make direct comparisons when analyzing data from different pieces of equipment.
• Data from Oracle Data Integrator was used to analyze manufacturing quality and drive down spoilage, saving the company money.

Incentivized

• The steep learning curve negatively impacts ROI during the first few months.
• After solving the difficulties with learning Talend Data Quality, we can achieve an increase in ROI with accurate and visually appealing reports.
• Integration with Salesforce is another positive breakthrough in ROI.

Incentivized