Automating XML Conversion with Oracle's ETL Tool ODI

Uli Bethke Big Data, Data Warehouse, Flexter, Oracle Data Integrator (ODI), XML

In the previous posts we demonstrated how Flexter liberates data from complex XML  files (Converting complex XML to CSV and Bulk loading XML files to Oracle with Flexter), we also presented the challenges when using ODI for the same purpose (Tips for Reverse Engineering complex XSDs such as SEPA and NDC in ODI and Tips for Parsing and Loading complex ...

Tips for parsing and loading complex NDC XML files in ODI

Maciek Kocon Oracle Data Integrator (ODI), XML

This is the second part in a multi part series on XML processing in ODI. In our previous post Tips for Reverse Engineering complex XSDs such as SEPA and NDC in ODI (URL) we have shown you a lot of useful tips for reverse engineering complex XSDs in ODI. The third part compares ODI to Flexter, our very own dedicated ...

How to query a whole schema or even database?! This tip will save you hours and hours of boring work.

Uli Bethke Oracle Data Integrator (ODI)

I really like this tip especially its simplicity. It has saved me hours and hours of mind numbing work in the past. The use case Imagine the following situation. You are tasked to complete a source to target map. With the help of various source system SMEs, legacy data models, and the data dictionary of the source database you have ...