Recent Articles

All Data Marketplace Flexter FlowHigh JSON Snowflake XML
Flexter, flexter, JSON, XML,

Converting XML and JSON to a Data Lake

Data lakes are a popular design pattern in data analytics. A data lake is used to store a copy of data coming from operational source systems such as relational databases.…
Uli Bethke September 30, 2021
JSON, JSON, Snowflake,

Snowflake vs. Redshift – Support for Handling JSON

ANSI SQL 2016 introduced support for querying JSON data directly from SQL. This is a common use case nowadays. JSON is everywhere in web based applications, IOT, NoSQL databases, and…
Uli Bethke June 22, 2021
Flexter, flexter, JSON,

Converting and Masking Zendesk JSON to a database (Oracle)

For this post we will mask and convert Zendesk JSON data to Oracle. We will use Sonra’s obfuscation tool Paranoid (open source) and Sonra’s data warehouse automation tool for XML,…
Uli Bethke September 17, 2019
Flexter, flexter, JSON,

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