Bouwsoft DWH Azure Deployment

Basic steps:

1. Refresh Token

   1. get a refresh token (see dwh-bouwsoft-installation-authentication)

2. Azure SQL database

   1. Create an Azure SQL Database Server if necessary
   2. Create an Azure SQL Database with DTU model, if necessary, and create the users. Keep the password of the db-readerfor later. See sql-server-installation for details.
   3. Create the initial configuration by running the update script: code/sql/update sql dwh.sql (see: https://github.com/pwrp/product-dwh-bouwsoft/blob/715e961c41069f0f9ecc75cb0ff363140e5d61e9/code/sql/update%20sql%20dwh.sql)
   4. add / change configurations for the client by modifying entries in config.ionbiz_Tables
   5. You should now have:
      1. a schema config
      2. a schema bouwsoft
      3. a table config.bouwsoft_Tables

3. Key Vault

   1. Create a key-vault if necessary. See key-vault-installation .
   2. Store the refresh token as a secret with name bouwsoft-refresh-token

4. Azure Function in Azure, create an Azure Function af-installation, specifically with

   1. service plan: B1 (to avoid timeouts)
   2. python 3.10 (11 doesn't contain SQL Server driver)
   3. name: xxx-pwrp-bouwsoft-af
   4. Deploy the AF: pwrp/product-dwh-bouwsoft/code/af (see: https://github.com/pwrp/product-dwh-bouwsoft/tree/715e961c41069f0f9ecc75cb0ff363140e5d61e9/code/af)

5. ADF in Azure, create an Azure Data Factory adf-installation

   1. configure the Azure Function as a service
   2. configure the Azure SQL DWH as a service
   3. load the ARM template from pwrp/product-dwh-bouwsoft/code/adf into ADF
   4. configure a trigger for the ADF pipeline
   5. publish