Provision IWD Data Mart

• Administrator

Learn how to provision IWD Data Mart.

Related documentation:

• How Intelligent Workload Distribution works
• Suite-level guide
• All services
• IWD Data Mart Release Notes

RSS:

• For private edition

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.