Converting and Querying TransXChange XML to Maria DB

Uli Bethke Flexter, XML, XSD

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, and industry data standards Flexter ...

Converting RESQML to S3 and Athena

Uli Bethke Flexter, XML

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 for XML, JSON, and industry data standards Flexter as a Service (FaaS) to convert RESQML data to S3 and then use Athena to Query the data. RESQML RESQML is a ...

Converting CDISC XML data to Snowflake

Uli Bethke Flexter, Snowflake, XML

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 and parsing tool Flexter as a Service (FaaS). FaaS follows a subscription model. Flexter is also available as a free edition and an enterprise edition. CDISC The Clinical Data Interchange ...

Converting DITA XML to MySQL

Uli Bethke Flexter, XML

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, and industry data standards Flexter as a Service (FaaS). FaaS can quickly convert this data in a few simple steps. XML Publishing Traditional publisher workflows rely on print-first content. The ...

Converting PRODML XML to SQL Server

Uli Bethke Flexter, SQL, XML

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 data standards Flexter as a Service (FaaS), which allows us to do this conversion pretty fast and in a few steps. FaaS follows a pay as you go model. Flexter ...