Provision IWD Data Mart

From Genesys Documentation
Jump to: navigation, search
This topic is part of the manual IWD Data Mart Private Edition Guide for version Current of Intelligent Workload Distribution.

Learn how to provision IWD Data Mart.

Early Adopter Program
Genesys Multicloud CX private edition is being released to pre-approved customers as part of the Early Adopter Program. Please note that the documentation and the product are subject to change. For more details about the program, please contact your Genesys representative.

Create a Postgres database for IWDDM.

Create a user for IWDDM full access to database:

CREATE USER "iwddm_dm" WITH LOGIN NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT NOREPLICATION CONNECTION LIMIT -1 PASSWORD '<IWDDM_PASSWORD>';

IWDDM should provide access to its database to GCXI. For that, an additional user account can be created with the following script:

CREATE USER "iwddm_gcxi" WITH LOGIN NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT NOREPLICATION CONNECTION LIMIT -1 PASSWORD '<GCXI_PASSWORD>';
ALTER DEFAULT PRIVILEGES FOR USER iwddm_dm GRANT SELECT ON TABLES TO iwddm_gcxi;

After creating an account, the new user account can be provided to the GCXI service for database access.