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

Uli Bethke May 28, 2020

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 advice on how you can use Snowflake as an ETL engine for data preparation. Let’s take this common scenario as an example: Your company ...

Read More

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

Uli Bethke May 22, 2020

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 data warehouse without ETL and no ETL without data warehouse. Once in a while non-sense such as data virtualisation or NoETL will pop up. However, ...

Read More

Re-use algorithms for converting XML and JSON to a relational format

Uli Bethke May 5, 2020

In our previous post Optimisation algorithms for converting XML and JSON to a relational format, we explained that Flexter ships with two optimisation algorithms. These algorithms make the life of downstream consumers of the output of Flexter easier as they simplify the relational target schema that Flexter auto-generates. In this post we will be showing ...

Read More

Converting GDTF XML standard to MySQL

Uli Bethke May 3, 2020

In this post we will guide you through the easiest way of processing your XML data to a relational format on MySQL . We will be using Flexter as a Service (FaaS) to process the GTDF XML standard. FaaS follows a monthly subscription model. Flexter is available in three editions. An enterprise edition, which can ...

Read More
1 4 5 6 7 8 79