Oracle Data Integrator (ODI) Questions

RajneeshShukla
Solution Architect at a tech vendor with 10,001+ employees

I am a solution architect for a global enterprise tech vendor.

I am looking for advice on the two following options: 

Option 1:

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?

Option2:

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. 

Gladson NatarajanThanks for using ODI, I love it, ODI is one of the good tools for ELT and very… more »
Sascha VogelBut I never had been a specialist in ODI since we focussed on OWB and possible… more »
Brian DandeneauI know I'm late to the party but here are my comments to this. I would ask… more »
RajneeshShukla
Solution Architect at a tech vendor with 10,001+ employees
Sep 09 2021

Hi,

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:

  • Price
  • 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. 

AThiréThere are two products I know about * TimeXtender : Microsoft based,… more »
Stefan SchäferWe usually use Talend. Look here:… more »
Karoly KrokovayWe have experiences only in Pentaho Data Integrator (open source competitor of… more »
Julia Frohwein
Content and Social Media Manager
IT Central Station

Hi Everyone,

What do you like most about Oracle Data Integrator (ODI)?

Thanks for sharing your thoughts with the community!

Julia Frohwein
Content and Social Media Manager
IT Central Station

Hi,

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.

Julia Frohwein
Content and Social Media Manager
IT Central Station
Jun 02 2021

Hi community,

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?

Phil WilkinsLike any product I'd try to understand how that product's roadmap might fit with… more »
Julia Frohwein
Content and Social Media Manager
IT Central Station

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?

Miriam Tover
Content Specialist
IT Central Station

How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

Data Integration Tools Questions
Ariel Lindenfeld
Sr. Director of Community
IT Central Station
Jul 08 2021

Hi peers,

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!

Phil WilkinsI would be looking for things like: - types of connections supported - data… more »
Nida Fatima- Ease of use - The solution should offer the same level of usability to both IT… more »
Arthur KancelaroviczHello, My experiences says : 1. Project budget; 2. Needed connection(s)… more »