The Snowflake data platform for data engineering, data preparation, and ETL

Overview Did you know that the Snowflake data platform is the perfect fit for ETL, data integration, and data preparation tasks?In this blog post we will give you some hands-on…
Uli Bethke May 28, 2020

To hell and back with ETL. The unstoppable rise of data warehouse automation.

A brief history of ETL The rise of ETL and the rise of the data warehouse are tightly coupled. It’s like the chicken and the egg. There would be no…
Uli Bethke May 22, 2020

The future of ETL and the limitations of data virtualisation and NoETL.

Data has limited value if we don’t transform, integrate, model (either data modelling and building predictive models) or cleanse it. Collecting raw data for no apparent reason or business case…
Uli Bethke October 11, 2018

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

JSON. To ETL or to NoETL? The big data question.

NoETL. The little brother of NoSQL You have probably come across the term NoSQL. It was coined a few years back to describe a class of database systems that can…
Uli Bethke February 19, 2018

Flexter, Informatica, and Redshift work Hand in Hand to convert ESMA XML

In this walk-through, we combine two powerful software platforms to present a highly efficient and user-friendly method to perform ETL of complex XML files. This implementation uses Flexter, which is…
Anvesh Gali August 17, 2017