[]
        
(Showing Draft Content)

Deploying to AAS using DuckDB

A notable advancement is introduced in version v7.0 of Wyn Enterprise - the capability to deploy Wyn as a single-process application. This mode streamlines the installation process, employing SQLite as the primary datastore and DuckDB as the analysis database (data warehouse). By utilizing the single-process Wyn application, the necessity of creating an external database is eliminated, resulting in substantial savings in memory and storage resources. However, should the need arise, you still have the option to employ an external database for installation.


This help article offers comprehensive instructions on configuring a Docker container for the Wyn application, tailored explicitly for seamless operation on the Azure App Service, leveraging the capabilities of DuckDB.


To deploy the Wyn Enterprise beta version on the Azure App Service with a docker container, data persistency should be maintained since the data is stored in the container by default. Ensure the following,

  • Data persistency is maintained across the following,

    1. Wyn.conf: Systems settings stored in the wyn.conf file can be modified manually.

    2. Log: Critical application data used for troubleshooting.

    3. Database and Cached Data: System settings, users, roles, documents, and the cached data of datasets and data models.

  • You have an Azure Storage account with a premium type as File Share.

Follow the below instructions to deploy Wyn as a single process application on Azure App Service using DuckDB.

  1. Create a Web App

    Log in to the Azure portal and create a web app. Under the Instance Details section select the Docker Container option for Publish setting and Linux for Operating System. Click Review + create button to create the web app.Deploy Wyn to AAS using DuckDB - create a web application

  2. Create Storage for Data Persistency

    Create File Shares in an existing account or a new account as needed. You need to create the file shares as shown in below image,

    Deploy Wyn to AAS using DuckDB -

    Note: The Premium account type of the Azure Storage Account should be File Shares.

  3. Add Application Settings

    Navigate to the Configuration settings from the Navigation bar and add the following application settings in the Application settings tab.

    Deploy Wyn to AAS using DuckDB - add new application settings


    In this help article, you will find information on using SQLite to store the system data. However, you can also use the external database to gain better performance and pass the database information to the docker container using the environment variables. You can also use the single database mode to store all the data in one database table. The following environment variables are supported,

    Variable

    Description

    DB_PROVIDER

    It is the database provider. Supported providers are Postgres, SqlServer, MySql, SQLite, and Oracle.

    DB_HOST

    Hostname of the database server.

    DB_PORT

    Listening port of the database server.

    DB_USER

    Username of the database server.

    DB_PASSWORD

    Password of the given database user.

    SINGLE_DATABASE_MODE

    Store all the data in one single database.

    DB_NAME_WYN

    To specify the database name for single database deployment.

  4. Add Path Mappings

    In the Path mappings tab of the Configuration settings page, add and save the path mappings for logs, database, and configurations as shown in the below images.


    Logs:

    Deploy Wyn to AAS using DuckDB - add path mappings


    Database:

    Deploy Wyn to AAS using DuckDB - add path mappings


    Configurations:

    Deploy Wyn to AAS using DuckDB - add path mappings


    The following path mappings will be added,

    Deploy Wyn to AAS using DuckDB -  path mappings

  5. Add the docker registry and docker image information

    Using the Navigation toolbar, navigate to the Deployment Center. From the Settings tab, add the docker registry, docker image name, and user credentials as described below and save all settings.

    • Full Image Name and Tag: wynenterprise.azurecr.io/wyn-7.0-en-beta:latest

    • Login: wyn-trial-user

    • Password: ru7FHOiCXa64ft72Z30W0nqcy+m0bjIA

      Deploy Wyn to AAS using DuckDB - add docker registry

  6. Access the Wyn Enterprise website

    The Azure App Service will restart on saving all settings and may take up to 5 minutes. After restarting, you can visit the Wyn Enterprise website using the default domain.

    Deploy Wyn to AAS using DuckDB - access the wyn enterprise website