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

Parsing XML to Oracle. ODI vs Flexter Enterprise XML Parser

Maciek Kocon Flexter, Oracle, Oracle Data Integrator (ODI), SQL, XML, XSD

In some previous posts we demonstrated how to load XML data into an Oracle database using ODI. We first looked at some of the issues when reverse engineering an XSD in ODI. Next we looked at various issues when parsing and processing XML files in ODI. We also showed that Flexter parses XML files without creating a single data flow ...

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

Oracle Data Integrator and Hadoop. Is ODI the only ETL tool for Big Data that works?

Uli Bethke Big Data, Hadoop, Oracle Data Integrator (ODI)

Both ODI and the Hadoop ecosystem share a common design philosophy. Bring the processing to the data rather than the other way around. Sounds logical, doesn't it? Why move Terabytes of data around your network if you can process it all in the one place. Why invest millions in additional servers and hardware just to transform and process your data? ...