Install Databases on Amazon RDS

In Amazon RDS, databases must be installed in a supported version of PostgreSQL.

Steps:

Please complete the following steps to integrate the Designer Cloud Powered by Trifacta platform with the DB instance you just created.

Steps:

From the Alteryx node, switch to the Postgres user and run the following commands against the RDS Host for the master username:

su - postgres
psql -h <endpoint of RDS Instance> -U trifacta_rds postgres

Please do the following for each database, which initializes the DB and assigns the trifacta role to the trifacta_rds master username:

Alteryx database:

CREATE ROLE trifacta LOGIN ENCRYPTED PASSWORD '<pwd_trifacta>';
GRANT trifacta TO trifacta_rds;
CREATE DATABASE "trifacta" WITH OWNER trifacta;

Jobs database:

CREATE ROLE trifactaactiviti LOGIN ENCRYPTED PASSWORD '<pwd_trifactaactiviti>';
GRANT trifactaactiviti TO trifacta_rds;
CREATE DATABASE "trifacta-activiti" WITH OWNER trifactaactiviti;

Time-based trigger service database:

CREATE ROLE trifactatimebasedtriggerservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactatimebasedtriggerservice>';
GRANT trifactatimebasedtriggerservice TO trifacta_rds;
CREATE DATABASE "trifactatimebasedtriggerservice" WITH OWNER trifactatimebasedtriggerservice;

Scheduling service database:

CREATE ROLE trifactaschedulingservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaschedulingservice>';
GRANT trifactaschedulingservice TO trifacta_rds;
CREATE DATABASE "trifactaschedulingservice" WITH OWNER trifactaschedulingservice;

Configuration Service database:

CREATE ROLE trifactaconfigurationservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaconfigurationservice>';
GRANT trifactaconfigurationservice TO trifacta_rds;
CREATE DATABASE trifactaconfigurationservice WITH OWNER trifactaconfigurationservice;

Artifact Storage Service database:

CREATE ROLE trifactaartifactstorageservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaartifactstorageservice>';
GRANT trifactaartifactstorageservice TO trifacta_rds;
CREATE DATABASE trifactaartifactstorageservice WITH OWNER trifactaartifactstorageservice;

Job Metadata Service database:

CREATE ROLE trifactajobmetadataservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactajobmetadataservice>';
GRANT trifactajobmetadataservice TO trifacta_rds;
CREATE DATABASE trifactajobmetadataservice WITH OWNER trifactajobmetadataservice;

Authorization Service database:

CREATE ROLE trifactaauthorizationservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaauthorizationservice>';
GRANT trifactaauthorizationservice TO trifacta_rds;
CREATE DATABASE trifactaauthorizationservice WITH OWNER trifactaauthorizationservice;

Orchestration Service database:

CREATE ROLE trifactaorchestrationservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaorchestrationservice>';
GRANT trifactaorchestrationservice TO trifacta_rds;
CREATE DATABASE trifactaorchestrationservice WITH OWNER trifactaorchestrationservice;

Optimizer Service database:

CREATE ROLE trifactaoptimizerservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaoptimizerservice>';
GRANT trifactaoptimizerservice TO trifacta_rds;
CREATE DATABASE trifactaoptimizerservice WITH OWNER trifactaoptimizerservice;

Secure Token Service database:

CREATE ROLE trifactasecuretokenservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactasecuretokenservice>';
GRANT trifactasecuretokenservice TO trifacta_rds;
CREATE DATABASE trifactasecuretokenservice WITH OWNER trifactasecuretokenservice;

Connector Configuration Service database:

CREATE ROLE trifactaconnectorconfigservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaconnectorconfigservice>';
GRANT trifactaconnectorconfigservice TO trifacta_rds;
CREATE DATABASE trifactaconnectorconfigservice WITH OWNER trifactaconnectorconfigservice;

If you have used non-default values for the username, password, host, or port value for either database, you must update platform configuration. For more information, see Database Parameter Reference.