Recent Articles

All Data Marketplace Flexter FlowHigh JSON Snowflake XML
Flexter, 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,…
Uli Bethke May 28, 2019
Flexter,

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
Data Warehouse,

Data warehouse automation explained. Benefits and use cases

What is data warehouse automation? I have been struggling to find a good article or post that explains data warehouse automation. To address this gap I have decide to write…
Uli Bethke May 13, 2019
Flexter,

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)…
Amar Manipatra April 1, 2019
Flexter,

Converting clinical trials XML data to Snowflake and Quicksight with Flexter

In this blog post we will show case Flexter, Sonra’s ETL tool for complex XML/JSON data standards. We will convert a large number of XML documents into a relational data…
Uli Bethke March 22, 2019
Flexter,

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…
Uli Bethke December 18, 2018