C2H

C2H

C2H – Data warehouse automation

  • Home
  • Betl
    • Installation
    • Getting started with BETL in Azure
    • Getting started on premise
    • BETL architecture
  • About me

Data warehouse automation

Posted on July 2, 2021October 15, 2021 by Bas van den Berg

Why is DWA framework x better than DWA framework y ? How do you compare DWA frameworks ? To answer these questions we first have to define what a DWA framework exactly is. This article will lay a foundation to compare DWA frameworks. A DWA framework or DWA software generates the code for building your […]

Continue Reading
Posted in BI developer blog

Pretty printing Json

Posted on June 22, 2021October 15, 2021 by Bas van den Berg

When working with ADF I frequently have to copy paste json code into sql server management studio ( ssms). Json uses \n for specifying a newline so this is shown in ssms as one large string which is difficult to read. Solution: Use the program autohotkey to record a hotkey / macro to replace some […]

Continue Reading
Posted in BI developer blog

Infra as code in Azure

Posted on June 10, 2021October 15, 2021 by Bas van den Berg

The following link will explain the reasons for using infra as code: My recent setup involved: Azure data factory, SSIS, Azure SQL server, Azure dev-ops, key vault and ARM templates. GitI’ve made two different repositories. One for ADF and one for SSIS and SQL Server. Why? Reason 1 quicker building and deployingChanges to ADF are […]

Continue Reading
Posted in BI developer blog
WordPress Theme: blogeasy by ThemesPoint.