Converting FPML XML to Oracle
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
sqlplusassysdba
|
1 |
sqlplus / as sysdba |
- Next we create a user
|
1 |
CREATE USER your_user IDENTIFIED BY your_pasword; |
- Now we need to assign Privileges to that user
|
1 2 |
GRANT CONNECT TO your_user; GRANT ALL PRIVILEGES TO your_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
orclinSIDsection
- And now we can start with processing FpML XML standard, with Docker version of Enterprise Flexter
[flexter_button]
Processing FpML XML with Flexter Enterprise
- First we start Flexter
|
1 |
docker run --rm -it -v c:/users/your_user:/mnt/data d1.sonra.io:5000/flexter-local |
- Next we Map Logical schema ID
|
1 |
xml2er -g1 /mnt/data/Desktop/codelist.zip |
- And now we can convert our XML data to Oracle
|
1 |
xml2er -l1 -o jdbc:oracle:thin:your_user/your_pass@//your_ip:1521/orcl -S o /mnt/data/Desktop/codelist.zip |
- 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.
[faq_button]
