Oracle Data Integrator (ODI) vs. Vertify

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

When we first implemented, there were a lot of fields not set up/syncing properly. But by consulting with Vertify, for a lot of hours, we have been able to work through a lot of those errors, and our Account Manager and the tech support people like Markus and Jamie have been very supportive and helpful in getting us up and running properly.

• 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

• All clients in the CRM are mirrored in the ESP.
• Data points about client interaction are pushed to the email tool.
• Emails can be triggered based off activities that are tracked in the CRM.
• One or two-way syncs can be configured.

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

• I think the UI could get a refresher. It looks a little old-school and I sometimes get lost in the navigation.
• I saw some inconsistencies on the scheduler, most likely caused by time zone differences. One dialogue reflected the user's time zone, the next server's time zone.

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.

Creating a mapping between source and target while also using lookups and transformations is not trivial. And VertifyData solved this reasonably well, at least all users in my organization understood it pretty quickly.

It is not the easiest user interface to read/understand. However, once you understand how it works, then using it is not that bad. It's hard to remember what feature is listed under what tab (Manage vs. Define). A suggestion would be to get all call to actions on the same page

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

We were using Scribe for similar tasks but with different connectors. And it served us well, so absolutely no hard feelings here. But when it came to creating complex workflows, we instantly understood Vertify's approach better. Data lookup and transformation e.g. are pretty easy in Vertify and ease of use was definitely what we were looking for.

• 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

• Independently, teams are able to carry out their process with less communication and at a higher level of accuracy.
• VertifyData is actively taking into consideration, consulting, and supporting our plans to build out the business