Converting XML to TSV on HDInsight

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…
Uli Bethke April 5, 2018
XML,

Flexter Data Liberator Earns Key Business Intelligence Software Recognitions from Reputed Business Software Directory

Flexter Data Liberator Earns Key Business Intelligence Software Recognitions from Reputed Business Software Directory We are proud to announce that our XML/JSON converter Flexter Data Liberator received two awards -…
Uli Bethke February 27, 2018
ETL, JSON,

Flexter 1.2.0 our ETL tool for JSON/XML has been released. 20x faster. Supports very large XML and JSON

We have release Flexter 1.2.0 this week. We have added some significant new features and improvements. Flexter now supports conversion of JSON to a database, text (CSV/TSV), and Hadoop/Spark (ORC,…
Uli Bethke February 23, 2018

Liberating data from spreadmarts and Excel (aka OOXML)

In this blog post we liberate data and metadata from the shackles of Excel. We convert all of the content of an Excel file to a relational database and then…
Uli Bethke February 23, 2018
XML,

Converting TVAnytime XML to Impala and Parquet

In this example we will use Flexter to convert an XML file to parquet. We then query and analyse the output with Impala (using Cloudera VM). Flexter can generate a…
Chinmay Sinha February 1, 2018
XML,

Converting XML to Hive

In this example we will use the Flexter XML converter to generate a Hive schema and parse an XML file into a Hive database. We will then use the spark-sql…
Chinmay Sinha January 27, 2018
spinner