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

Tips for Reverse Engineering complex XSDs such as SEPA and NDC in ODI

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

In this post we will show you a few tips and ODI issues when reverse engineering complex industry XML schemas (XSD) such as NDC FlightPriceRS or SEPA Pain.001. This is the first part in a multi part series. The second part gives you some tips and tricks when parsing XML files in ODI. The third part compares ODI to Flexter, ...

Converting XML files to Oracle without writing a single line of code

Maciek Kocon Flexter, Oracle, XML, XSD

Parsing XML files to Oracle without writing a single line of code In a previous post we demonstrated how to use Flexter to convert XML data into TSV files. This was just an introduction demonstrating some basic features of Flexter including concepts around XML schema normalization and optimization. Converting XML into an Oracle Database This time we are going to ...

Converting complex XML to CSV

Maciek Kocon XML

Have you ever tried to process data in XML? Did you have to load its values into a relational database or simply convert it to plain CSV? Before I show you a simple way of processing complex XMLs, let’s first think out loud what XML actually is used for. Note: If you have a good grasp on XML specifics you ...

Querying XML files with Tableau via Flexter

Uli Bethke Tableau, XML, XSD

Tutorial - Querying XML files with Tableau Tableau is a great visualisation tool that works with a large number of different file and data formats. One format that is not supported is data in XML files. There are some workarounds, e.g. using Excel to flatten the XML file. However, with deeply nested files or XMLs with a complex schema this ...