Converting ACORD XML to Avro row storage

Uli Bethke Apache, XML

In this example we will use Flexter to convert an XML file to the Apache Avro format. We then query and analyse the output in the Spark-Shell. Flexter can generate a target schema from an XML file or a combination of XML and XML schema (XSD) files. We will use the data from The ACORD RLC Insurance and Reinsurance Service ...

Converting XML from API calls

Uli Bethke Flexter, XML

Querying the Amazon Product Advertising API with Flexter Working with APIs that return XML can be a painful process. First of all you need to go through the documentation to figure out how the API works. Then you need to write the code that queries the API and returns the XML. Typically you want to transform the XMLs to a ...

From 0 to Snowflake in 90 Minutes

Uli Bethke Uncategorized

Please join Snowflake and Sonra for a 90-minute workshop where we will show you how easy it is to get started with Snowflake cloud data warehouse. We will also demonstrate some of the cool features in Snowflake such as zero copy cloning, undrop, time travel and much more. Space is limited so please RSVP as soon as possible to reserve your spot. We look forward ...

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