Create and Configure a Database for Workspace Services

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

1. Create a database for  mfconsoledb with a custom name along with prefix and suffix. Prefix and suffix are optional. For example, database name is <prefix>mfconsoledb<suffix>.

   NOTE:  For Oracle databases, a schema name should be in capital letters.

   NOTE: For Oracle, create necessary tablespaces and Users before proceeding. Refer to Prerequisites for Quantum Fabric with Oracle.

   • The following is a sample query for creating a database in SQL Server:

     CREATE DATABASE mfconsoledb;

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

     
     
     CREATE DATABASE `<DBNAME>` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

   IMPORTANT:  For workspace, you can create database with a custom name instead the default databases such as  mfconsoledb.
   
   For example, if you have created a workspace database with a custom name ( <prefix>mfconsoledb<suffix>), replace the custom database name in all SQL scripts in the \QuantumFabric_Plugins\scripts\waasdbmigrations\commondbscripts  folder.
   

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

   The following details pre-requisites for Flyway configuration:

   • Schema name for workspace: mfconsoledb
   • Placeholders for Workspace Services:

     # Quantum Workspace Services Database, replace the following placeholders # in SQL migrations for your database

     
     
     flyway.placeholders.KONY_WAAS_LOG_LOCATION=C:QuantumFabric/logs
     flyway.placeholders.KONY_WAAS_LOG_LEVEL=INFO
     flyway.placeholders.KONY_WAAS_LOG_OPTION=logfile
     flyway.placeholders.KONY_WORKSPACES_GLOBAL_DB
     flyway.placeholders.KONY_WAAS_GLOBAL_DB

   • Tablespace Placeholders for Oracle:

     Product Name	Tablespace Placeholders for Oracle
     Workspace	WAAS_DATA_TABLESPACE , WAAS_INDEX_TABLESPACE , WAAS_LOB_TABLESPACE

   • SQL files paths for Workspace Services in QuantumFabric_Plugins folder:
     Click here for more details

     Path for SQL files in the QuantumFabric_Plugins folder	Database	Component
     \QuantumFabric_Plugins\scripts\waasdbmigrations\commondbscripts	MySQL	Workspace
     \QuantumFabric_Plugins\scripts\mmigrations-waas-oracle\commondbscripts	Oracle
     \QuantumFabric_Plugins\scripts\migrations-waas-sqlserver\commondbscripts	SQL Server

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

   In flyway conf, set flyway.baselineOnMigrate=true

   set flyway.validateOnMigrate=false

   Click here to view the Workspace schema diagram