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…
Uli Bethke August 13, 2019

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…
Uli Bethke August 8, 2019

Converting Slack JSON data to a database (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…
Uli Bethke August 6, 2019

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,…
Uli Bethke May 28, 2019

Converting Asana JSON to CSV on S3

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…
Uli Bethke May 15, 2019

Working with JSON in Redshift. Options, limitations, and alternatives

Redshift offers limited support to work with JSON documents. We have three options to load JSON data into Redshift. We can convert JSON to a relational model when loading the…
Uli Bethke April 24, 2019
spinner