Oracle Data Integrator (ODI) Questions
I am a solution architect for a global enterprise tech vendor.
I am looking for advice on the two following options:
I have a select script that fetches data by joining many source tables and performs some transformations like aggregations (group by), data conversion, sub-string, etc.
Can I invoke this script through ODI mapping and can return results (transformed data output) be inserted into the target of ODI mapping?
Can I convert the select script into equivalent ODI mapping by using equivalent ODI transformations, functions, lookups, etc and use various tables (tables in joint clause) as a source of mappings?
In short, can I develop ODI mapping that is equivalent to provides select scripts plus a target table to insert records into?
What are the pros and cons of the above two options?
Is it still possible to track transformation errors, join source tables and clause condition related errors through ODI with option 1?
Will log file for mapping failure have granular-level details as offered by option 2?
Can I still enable Flow Control at Knowledge Module and redirect select script errors into E$_ error tables provided by ODI?
Thanks! I appreciate the help.
Sep 09 2021
I am working as a solution architect for a tech vendor with 10,000+ employees.
I need to perform comparative analysis for ETL tools available to populate data from OLTP to OLAP.
The main criteria I am considering are:
- Functionality (transformation, error logging and handling, loading patterns to be supported)
- Development and maintenance efforts
- Popularity in the market.
I want to evaluate both Oracle and Open Source options. I am also open to both tools (ODI, Golden Gate, etc) and technology- e.g. Oracle Materialized view.
Thanks! I appreciate your help.
What do you like most about Oracle Data Integrator (ODI)?
Thanks for sharing your thoughts with the community!
We all know it's really hard to get good pricing and cost information.
Please share what you can so you can help your peers.
Jun 02 2021
If you were talking to someone whose organization is considering Oracle Data Integrator (ODI), what would you say?
How would you rate it and why? Any other tips or advice?
Please share with the community what you think needs improvement with Oracle Data Integrator (ODI).
What are its weaknesses? What would you like to see changed in a future version?
How do you or your organization use this solution?
Please share with us so that your peers can learn from your experiences.
Data Integration Tools Questions
Jul 08 2021
When evaluating Data Integration tools, what aspects do you think are the most important to look for? Let the community members know what you think.
Thank you for sharing your knowledge!
Product CategoriesData Integration Tools
Download our free Oracle Data Integrator (ODI) Report and get advice and tips from experienced pros sharing their opinions.