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

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

A brief history of XML - From hype to useful data format

Vadim Mytarev Flexter, Hadoop, Spark, XML, XSD

Is XML really dead? When it first became popular about 20 years ago, XML was meant to be the one and only format to serialize, encapsulate, and exchange data. The serialization format to end all serialization formats so to speak. This was a bold claim. Has it materialised? Over the last couple of years it has become clear that this ...