Set up the Cosmos DB

The EmpowerID chatbot uses Cosmos DB, a NoSQL database that guarantees scalability and speed while storing a huge volume of chat messages. It will store the Chat Conversations, Configuration & Templates used for the bot. Please follow the steps below to configure the Cosmos DB for EmpowerID.

1. Navigate to the Azure Portal.

2. Please create a Cosmos DB with Core (SQL).
   
   

   Open

   

    

3. After Azure provisions the Cosmos DB, you will have to add a new database and a container to the CosmosDB. Please replicate the information in the screenshot below to create a database named bot_database and a container named botconfig is created.
   

   
   
   
   Open

   

   
   
   

4. Add two additional containers, conversations, and templates to the bot_database database. After you have added the containers, you should be able to list all containers and the database created.
   
   
   

5. Find the Bot Service Deployment Package (i.e., _BotServiceDeploymentPackage.zip) and unzip the content into a folder.
   

   
   
   

6. Locate the Adaptive Card Templates folder in the Bot Service Deployment Package.

7. Upload all the JSON files in the Adaptive Card Templates folder to the templates Cosmos DB container. You should be able to see the list of the uploaded files after completion.
   
   

   
   
   

    

8. Now, we will add the settings from Cosmos Db into the configuration of the App Service created in Step 1 Set up App Service ; please add the following values for the keys and save the settings.
   
   

   1. CosmosDbAuthKey with the Primary Read-Write Key.

   2. CosmosDbDatabaseId with “bot_database“.

   3. CosmosDbContainerId with “botconfig“.

   4. CosmosDbEndpoint with the URI of the CosmosDb account.