Recent Articles

All Data Marketplace Flexter FlowHigh JSON Snowflake XML
Flexter, 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…
Uli Bethke March 31, 2020
Flexter, flexter, XML,

Converting and Querying TransXChange XML to a database (Maria DB)

In this post we will convert the TransXChange XML standard to a relational format on MariaDB. We will query the output with SQL to show the bus schedule (pick up…
Uli Bethke November 1, 2019
Flexter, flexter, XML,

Converting RESQML XML to Athena

In a previous post we converted Energistics XML in the PRODML standard. Today we will continue converting Energistics standards. For this showcase we will use Sonra’s data warehouse automation tool…
Uli Bethke October 25, 2019
Flexter, flexter,

Converting CDISC XML data to a database (Snowflake)

In this post we will guide you through the challenging process of obfuscating and converting CDISC XML data to Snowflake. We will be using Sonra’s masking tool Paranoid and processing…
Uli Bethke October 24, 2019
Flexter, flexter,

Converting DITA XML to a database (MySQL)

In this post we will convert the DITA XML standard used in Publishing. We will convert it to a MySQL database with Sonra’s data warehouse automation tool for XML, JSON,…
Uli Bethke October 15, 2019
Flexter, flexter,

Converting PRODML XML to a database (SQL Server)

For this blog post we have prepared a process of converting PRODML XML to SQL Server. We will be using Sonra’s data warehouse automation tool for XML, JSON, and industry…
Uli Bethke September 27, 2019