We performed a comparison between erwin Data Catalog by Quest and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out what your peers are saying about Informatica, Alation, Collibra and others in Metadata Management."The data catalog feature is pretty good."
"When you combine it with data lineage, every time you need to make a change, it allows you to do impact analysis on any changes and then connect to the end-users or data stewards so that they can be aware that a change is coming. That's one of the main benefits we use it for."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The most valuable feature is Data movement."
"The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"The initial setup is easy."
"The CAEM is very useful in its modularity and portability."
"It uses the power of the database system efficiently."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"There are always ways to improve things. For example, we can use AI to be able to find out something. When we are typing something, if we don't know the exact term, Artificial Intelligence would be useful to find terms that are phonetically or syntactically similar. Instead of having to type in the exact name, they can provide those in the list. So, they can provide AI support for the search because when you have thousands and thousands of terms, it is hard to remember all the names."
"There is room for improvement with respect to the connector and how to connect to the structured and unstructured database."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"The initial setup is complex, especially if you also have to install a console."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"We used a third party to do the implementation of ODI."
"The initial setup is a bit complex compared to other tools."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
erwin Data Catalog by Quest is ranked 10th in Metadata Management with 2 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 68 reviews. erwin Data Catalog by Quest is rated 7.6, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of erwin Data Catalog by Quest writes "Helps with metadata management, saves time, and allows us to do impact analysis on any changes". On the other hand, the top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". erwin Data Catalog by Quest is most compared with Informatica Enterprise Data Catalog, Talend Open Studio, WhereScape RED, Alation Data Catalog and SSIS, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Azure Data Factory and Oracle GoldenGate.
We monitor all Metadata Management 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.