Document Management
How To and Troubleshooting
ClickHouse is a column-oriented database management system for OLAP. You can use ClickHouse in place of MonetDB as the option for the AnalyticDB. It provides higher data processing (analysis) ability and higher system stability. It can also be hosted in Azure App Service.
You have two analysis database installation options:
Wyn 6.1 installation uses MonetDB as a data warehouse by default. You can use ClickHouse as an alternative to MonetDB as an OLAP database. For this, you need to manually set up the ClickHouse server and then configure it through Wyn.conf.
You need to change the DataWarehouse Provider to ClickHouseV2 and add the connection string as below:
<DataWarehouse> <Provider>ClickHouseV2</Provider> <ConnectionString>protocol=https;Host=myServerAddress;Port=myServerPort;Username=myUsername;Password=myPassword;Database=myDatabase;</ConnectionString> </DataWarehouse>