DWH (Bouwsoft edition) Introduction

bouwsoft is a cloud ERP for construction companies. See also: bouwsoft

The DWH (Bouwsoft edition) is a data warehouse that is used to store and analyze data from bouwsoft. It consists of the following components:

1. py-bouwsoft: A Python package that is used to extract data from bouwsoft.

2. Azure Function: Data is ingested from bouwsoft into the data warehouse using a set of ETL processes.

3. Azure Data Factory: The ETL processes are orchestrated using Azure Data Factory.

4. Azure SQL Database: The data is stored in an Azure SQL Database.

Difference to Power BI Connector

Visma / bouwsoft have published a Power BI connector that allows you to connect to ionBIZ directly from Power BI. Under the hood, the connector also connects to the REST API. However, the usage of large tables (e.g. Timesheets) leads to timeouts. Also, the connector does not allow to store the data in a data warehouse, so that the development experience is very bad.

Which tables can I download with the DWH (bouwsoft edition)?

You can download all tables published via the REST API.

You will find a list of all tables in the Swagger UI