Converting FPML XML to Oracle

Uli Bethke Flexter, XML

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

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

Conclusion

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.

About the author

Uli Bethke LinkedIn Profile

Uli has 18 years’ hands on experience as a consultant, architect, and manager in the data industry. He frequently speaks at conferences. Uli has architected and delivered data warehouses in Europe, North America, and South East Asia. He is a traveler between the worlds of traditional data warehousing and big data technologies.

Uli is a regular contributor to blogs and books, holds an Oracle ACE award, and chairs the the Hadoop User Group Ireland. He is also a co-founder and VP of the Irish chapter of DAMA, a non for profit global data management organization. He has co-founded the Irish Oracle Big Data User Group.