Skip to content

DWH (ionBIZ edition) installation

Basic steps:

  1. get client id and client secret from ionBiz support

  2. create a Key Vault if necessary, and store the keys

  3. create an Azure SQL Database if necessary

    1. create a schema ionbiz
    2. create a schema config
  4. create config.ionbiz_Tables by running the initialisation script product-dwh-ionBiz\code\sql\update sql dwh.sql

  5. add / change configuration for client by modifiying entries in config.ionbiz_Tables

  6. deploy the Azure Function

  7. deploy the Azure Data Factory ARM template

  8. configure a trigger for the ADF pipeline