Recent Articles

XML, flexter,

Masking Sabre XML and converting to a database (Snowflake)

In this post we will show you how to use Flexter, Sonra’s data warehouse automation solution for complex XML and JSON documents. We will use Flexter in combination with Paranoid,…

Maciek May 28, 2019

XML,

Paranoid? Masking, anonymizing, and obfuscating PII in XML and JSON data

Data masking, anonymization, and obfuscation are methods to scramble personally identifiable information (PII). We can apply different techniques to mask data, e.g. you may substitute values (swap na for another)…

Maciek April 1, 2019

XML,

Converting IRS Form 990 XML to text and Excel

In 2016, the IRS released data in electronic form to the nonprofit sector. Each of these files, contains data about nonprofit finance and more. You can get all that data…

Maciek December 18, 2018

SQL,

Converting Financial Information eXchange XML (FIXML) to MS SQL Server

FIX is a messaging standard used for trades in the financial services industry. The FIX Trading Community is the independent body behind the FIX messaging standard. FIX messages are encoded…

Maciek June 5, 2018

XML,

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…

Maciek May 8, 2018

XML,

Converting ACORD XML to Avro row storage

In this example we will use Flexter to convert an XML file to the Apache Avro format. We then query and analyse the output in the Spark-Shell. Flexter can generate…

Maciek April 26, 2018