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

Converting RESQML XML to Athena

Uli Bethke October 25, 2019

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 ...

Read More

Converting CDISC XML data to a database (Snowflake)

Uli Bethke October 24, 2019

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. ...

Read More

Converting DITA XML to a database (MySQL)

Uli Bethke October 15, 2019

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 ...

Read More
1 2 3 4 5 6 19