Converting FPML XML to Oracle

May 8, 2018

In this guide we will show you how to process FpML XML files with Enterprise Flexter and convert it to Oracle.

FpML XML Standard

FpML (Financial products Markup Language) is a business information exchange standard based on Extensible Markup Language (XML) that enables business-to-business over-the-counter (OTC) financial derivative transactions online by following W3C standards.[1]
Freely available with an open-source license, the standard is managed by International Swaps and Derivatives Association (ISDA) on behalf of a community of investment banks that make up the OTC derivatives industry. All categories of privately negotiated derivatives will eventually be included within the standard.
FpML is distinct from similar financial standards such as SWIFT and FIX in scope because it provides no network or specification of a transport mechanism.
We will take a recent version of a file from FPML website,


Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model database[4] management system produced and marketed by Oracle Corporation.

Setting up Oracle

  • First we need to make a user and give him privileges. We start sqlplus as sysdba

  • Next we create a user

  • Now we need to assign Privileges to that user

  • Now we need to make a connection in SQL Developer
  • We click on green + sign at top left corner

  • Then we fill out Username and Password, and put orcl in SID section

  • And now we can start with processing FpML XML standard, with Docker version of Enterprise Flexter


Processing FpML XML with Flexter Enterprise

  • Next we Map Logical schema ID

  • And now we can convert our XML data to Oracle

  • And we can now check our data in SQL Developer


We can easily process complex XML data with Flexter and process the output to Oracle. With Enterprise Flexter we can also process XML files in realtime and stream the output to Oracle. We can also evolve the schema over time and compare different versions of FpML to avoid schema upgrade headaches. The possibilities are endless.
If you are interested in Enterprise Flexter version, feel free to contact us.
Do you have any complex XML files that need to be converted for data analysis? Please leave a comment with your experience or reach out to us.