Create a database for Engagement Services

Configuring Engagement Services Database

To create a database for Engagement Services, follow these steps:

1. Create a database with a name "vpnsdb" with character set as "utf8" and collate as "utf8_unicode_ci" using the following command. The database name can contain a custom name along with prefix and suffix. Prefix and suffix are optional. For example, schema name is <prefix>vpnsdb<suffix>.

   The following is a sample query for creating a database in MySQL

   \-> CREATE DATABASE vpnsdb CHARACTER SET utf8 COLLATE utf8\_unicode\_ci;

   For Foundry version V9.2.2.0 or greater:

   Create a database with a name "vpnsdb" with character set as "utf8mb4" and collate as "utf8mb4_unicode_ci" using the following command. The database name can contain a custom name along with prefix and suffix. Prefix and suffix are optional.

   For example: schema name is <prefix>vpnsdb<suffix>.

   The following is a sample query for creating a database in MySQL

   \-> CREATE DATABASE vpnsdb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

   The following is a sample query for creating a database in DB2

   CREATE SCHEMA "schema\_name" AUTHORIZATION dbclient;

   Note:  For DB2 and Oracle databases, a schema name should be in capital letters.

   Note: To create necessary tablespaces for Oracle and DB, and pre-requisites for MySQL and MS SQL, refer to Database Prerequisites.

   The following details are required for Flyway configuration:

   • Schema name for Engagement Services: vpnsdb
   • Placeholders for Engagement Services:

flyway.placeholders.VMS_DBNAME

• Tablespace Placeholders for DB2 and Oracle:

Product Name	Tablespace Placeholders for DB2 and Oracle
Engagement Services (VMS)	VMS_DATA_TABLESPACE, VMS_INDEX_TABLESPACE, VMS_LOB_TABLESPACE

• SQL files paths for Engagement Services in VoltMXFoundry_Plugins folder:

Path for SQL files in the VoltMXFoundry_Plugins folder	Database	Component
\VoltMXFoundry_Plugins\scripts\mysql-vpns-migrations	MySQL	Engagement Services
\VoltMXFoundry_Plugins\scripts\oracle-vpns-migrations	Oracle
\VoltMXFoundry_Plugins\scripts\mssql-vpns-migrations	SQL Server

1. Execute all SQL scripts by using the steps provided at Configuring Flyway Command-line Tool.

   Click here to view the Engagement Services schema diagram