Recent Articles

XML, flexter,

Converting Automotive Standard ASAM ODS XML to a database (PostgreSQL)

In this blog post we will show you how to obfuscate ASAM ODS XML data and convert it to PostgreSQL. For this quick process which will just take a couple…

Maciek August 19, 2019

SQL, flexter,

Converting and Masking Connexo XML to a database (MySQL)

In this post we will show you how obfuscate XML data and convert it to a tabular format. We will use XML documents from Connexo NetSense and convert it to…

Maciek August 13, 2019

XML, flexter,

Masking and converting Guidewire XML to a database (Oracle)

In this post we will guide you through the process of masking Guidewire XML data and converting it to Oracle. This process normally take days or weeks. With our solution…

Maciek August 8, 2019

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