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.…
Kristijan Berta 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…
Kristijan Berta June 22, 2021
JSON, JSON,

Converting Trello JSON to Redshift

In this blog post we will show case Flexter, Sonra’s data warehouse automation solution for complex XML and JSON documents. We will process Trello JSON for this showcase.Flexter is a…
Kristijan Berta April 26, 2019
Flexter, JSON,

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…
Kristijan Berta April 24, 2019
JSON, JSON,

Converting Trello JSON to SQL Server

In this guide we will show you how to process Trello JSON files with the enterprise version Flexter and convert it to SQL Server. Trello Trello is a web-based project…
Kristijan Berta June 12, 2018
Flexter, JSON,

Converting and analysing Rugby JSON data to Oracle Data Visualization Desktop

Here is another post that will show how you can work with the output from Flexter to analyse your data. In this post we will show you how to convert…
Kristijan Berta May 22, 2018