Recent Articles

All JSON Snowflake XML
Snowflake, flexter,

How to Parse & Flatten XML in Snowflake with Examples

In this post we cover every detail of parsing XML in Snowflake including storing, loading, querying, and parsing XML. Very few cloud data platforms have native support for parsing XML.…
Uli Bethke June 3, 2024
XML, 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.…
Maciek September 30, 2021
XML, flexter, XML,

Re-use algorithms for converting XML and JSON to a relational format

In our previous post Optimisation algorithms for converting XML and JSON to a relational format, we explained that Flexter ships with two optimisation algorithms. These algorithms make the life of…
Maciek May 5, 2020
XML, flexter, XML,

Converting GDTF XML standard to MySQL

In this post we will guide you through the easiest way of processing your XML data to a relational format on MySQL . We will be using Flexter to process…
Maciek May 3, 2020
Snowflake, Data Marketplace, flexter,

Geo and location analytics in action with OpenStreetMap and census data

Geo and location analytics in action with OpenStreetMap and census data In this blog post we integrate and analyse OpenStreetMap, Census, and Geo Data from Ireland. We will use Flexter…
Uli Bethke April 14, 2020
XML, flexter, XML,

Optimisation algorithms for converting XML and JSON to a relational format

Optimisation algorithms for converting XML and JSON to a relational format. Part 1 - Elevate Flexter, our data warehouse automation solution for the conversion of XML, JSON, industry data standards…
Maciek March 31, 2020