Converting and Masking Connexo XML to MySQL

Uli Bethke Flexter, SQL, XML

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 a relational format in MySQL. We will be using Sonra’s masking tool Paranoid (open source) to obfuscate the data. We will use Flexter as a Service (FaaS) to convert the ...

Masking and converting Guidewire XML to Oracle

Uli Bethke Flexter, Oracle, XML

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 this will just take a few minutes. We will be using Sonra’s masking tool Paranoid (open source) to obfuscate the data. We will use Flexter as a Service (FaaS) to ...

Converting Slack JSON data to Snowflake

Uli Bethke Flexter, JSON, Snowflake

In this blog post we will show you how fast and easy it is to obfuscate Slack JSON data and convert it to Snowflake. We will use Sonra’s obfuscation tool Paranoid (open source) to mask the JSON documents we have retrieved from the Slack API. We will use Flexter to convert the data to a relational format in a Snowflake ...

Masking Sabre XML and converting to Snowflake

Uli Bethke Flexter, XML

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, Sonra’s open source tool for masking and obfuscating XML and JSON documents. We will first mask a Sabre XML document with Paranoid and then convert the data to Snowflake, a ...

Converting Asana JSON to CSV on S3

Uli Bethke Flexter, XML

In this article we will show you how to use Sonra’s data warehouse automation solution for complex XML and JSON documents, Flexter. We will process Asana JSON that we got from Asana’s API and convert the data to TSV text files on AWS S3 object storage. Flexter is a Spark application written in Scala. For this blog post we will ...