ETL

Example: Copy data from Sql Server into Azure blob storage

This example shows how data from SqlServer are transferred into Azure blob storage. It shows how to setup an Azure function that runs periodically to move freshly created data rows from the database into a blob container.

ETLBox (Part 1): C#'s Answer to Seamless ETL Processing and Thorough Data Validation

This article was also published as a blog article 'Redefining ETL: Data Flows Powered by C# (Part I)'

ETLBox (Part 2): C#'s Answer to Seamless ETL Processing and Thorough Data Validation

This article was also published as a blog article 'Redefining ETL: Data Flows Powered by C# (Part II)'

ETLBox (Part 3): C#'s Answer to Seamless ETL Processing and Thorough Data Validation

This article was also published as a blog article 'Redefining ETL: Data Flows Powered by C# (Part III)'

Example: pivot data from a csv file

This example shows how to use the RowMultiplication to pivot data in a csv file.

Example: Rating orders

This example demonstrates how the different data flow components can be used together, simulating a real-life scenario. In this scenario, we will to read some orders from a csv file, lookup the customer key by using the customer name, write the orders into an orders table and also create a customer rating based on the total amount of purchases.

Building a Data Warehouse with ETLBox

This article was also published as a blog article 'Building a Data Warehouse with ETLBox: A .NET Developer's Guide'