Converting GS1 XML to S3 on AWS

Uli Bethke Flexter, XML

In this guide we will show you how to process GS1 XML files with Enterprise Flexter and convert it to Amazon AWS S3. GS1 XML Standard GS1 or Global Standards One is a not-for-profit organisation that develops and maintains global standards for business communication. The best known of these standards is the barcode, a symbol printed on products that can ...

Converting XML to TSV on HDInsight

Uli Bethke Flexter, XML

In this post we will show you detailed steps on how to convert XML files on HDInsight to text (TSV/CSV). We will use Flexter, our ETL tool for XML and JSON to convert the XML files. HDInsight is the Hortonworks Hadoop distribution. Create HDInsight Cluster To create an HDInsight cluster we add a new resource to the Azure dashboard Select ...

Converting Google Analytics JSON to S3 on AWS

Uli Bethke Flexter, JSON

In this guide we will show you how to process Google Analytics JSON files with Enterprise Flexter and convert it to Amazon AWS S3. Google Analytics Google Analytics is a freemium web analytics service offered by Google that tracks and reports website traffic.Google launched the service in November 2005 after acquiring Urchin. Google Analytics is now the most widely used ...

Loading data into Snowflake and performance of large joins

Dorian Beganovic Snowflake

Introduction In this blog post we will load a large dataset into Snowflake and then evaluate the performance of joins in Snowflake. Loading large data into Snowflake Dataset The dataset we will load is hosted on Kaggle and contains Checkouts of Seattle library from 2006 until 2017. You can also download the data and see some samples here. The dataset ...

Converting FHIR JSON to CSV with Flexter

Uli Bethke CSV, Flexter, JSON

In this post we will be converting FHIR JSON files to text (CSV). FHIR Fast Healthcare Interoperability Resources (FHIR, pronounced "fire") is a draft standard describing data formats and elements (known as "resources") and an application programming interface (API) for exchanging electronic health records. The standard was created by the Health Level Seven International (HL7) health-care standards organization. FHIR builds ...