Recent Articles

All Data Marketplace Flexter FlowHigh JSON Snowflake XML
Data Marketplace, 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
Flexter, flexter, XML,

Converting XSD to database schema: your guide to creating relational models from XML

When it comes to turning your XML/XSD into a relational schema, you’ve got a few paths you can take: Straight from the XSD: This method covers all possible XPaths and…
Uli Bethke April 7, 2020
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