Converting OSCRE IDM to Snowflake

Uli Bethke May 3, 2020

In this post we will guide you through the easiest way of processing your XML data to a relational format on Snowflake . We will be using Flexter as a Service (FaaS) to process the OSCRE Real Estate Industry Data Model (IDM) XML. FaaS follows a monthly subscription model. Flexter is available in three editions. ...

Read More

Generating a relational target schema. From XSD. From XML. From XML and XSD

Uli Bethke April 7, 2020

Flexter, our data warehouse automation solution for the conversion of XML, JSON, industry data standards (HL7, FpML, ISO 20022 etc.) automatically creates Target Schema when we create a Data Flow. It allows us to see relational representation of our XML or JSON documents. In this post we show you how easy it is to create ...

Read More

Optimisation algorithms for converting XML and JSON to a relational format

Uli Bethke March 31, 2020

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 (HL7, FpML, ISO 20022 etc.) ships with two optimisation algorithms. The purpose of these algorithms is to simplify the relational target schema that Flexter auto-generates. ...

Read More

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

Uli Bethke November 1, 2019

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 and drop down routes and times). We will use the relational database management system Maria DB and Sonra’s data warehouse automation tool for XML, JSON, ...

Read More
1 2 3 4 5 18