Skip to main content

Manual Database Install

As needed, you can perform manual creation of users and individual databases used by the Designer Cloud Powered by Trifacta platform.

Tip

In most installation scenarios, manual database installs are not needed.

Prerequisites

  1. The database server must be installed and available:

    1. See Install Databases for PostgreSQL.

    2. See Install Databases for MySQL.

  2. The databases must be initialized.

    Note

    If you are using non-standard database names, users, passwords, port numbers, that information must be applied during installation and afterwards in the Designer Cloud Powered by Trifacta platform configuration.

    For more information, see Configure the Databases.

Required special database permissions

If you are manually installing any of the following databases, special database permissions are required for the user performing the installation and access. When the Designer Cloud Powered by Trifacta platform is initialized for the first time, a cross-migration of data is performed between these databases, which is required for successful installation and enablement of the related services. This cross-migration process requires special database privileges.

To execute the cross-migration, the database user for the following databases requires special privileges:

  • trifacta database

  • trifactaauthorizationservice database

The privileges required for cross-migration depend on the database server on which these databases are being installed:

Database Type

Required permissions for database user

PostgreSQL

SUPERUSER

MySQL

FILE

Warning

If the cross-migration is run as part of the normal install or upgrade script, then these permissions are already set for the above databases. If for some reason, you are manually installing or upgrading these databases, the above privileges must be applied.

After install or upgrade, the above privileges are not required for normal operations on these databases. These privileges must be re-applied if cross-migrations need to be performed in the future.

Manual DB Install for PostgreSQL

Use the following steps to manually create the users and databases required by the platform in PostgreSQL.

Launch PostgreSQL

Prerequisites for PostgreSQL:

  • The installing user must have write permissions to the directory from which the commands are executed.

  • The installing user must have sudo privileges.

  1. Switch to the Postgres user. Launch psql.

    sudo su - postgres

    Note

    Unless the port number for postgres has been modified, it should be listening at the default value: 5432.

  2. Launch psql using the following command, applying the admin password when prompted:

    psql --host=${POSTGRES_HOST_NAME} --port=${POSTGRES_HOST_PORT} --username=${POSTGRES_ADMIN_USERNAME} --password=${POSTGRES_ADMIN_PASSWORD}

    where:

    Parameter

    Description

    host

    Public DNS value for database server instance

    port

    Port number value for database server instance

    username

    Admin username for database server instance

    password

    Password for admin username

  3. Execute the following commands using the postgres user.

    Note

    The values in platform configuration must match the values that you use below. Below are the default values.

Alteryx database

CREATE ROLE trifacta LOGIN ENCRYPTED PASSWORD '<pwd_trifacta>';
CREATE DATABASE trifacta WITH OWNER trifacta;

Jobs database

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

Scheduling database

CREATE ROLE trifactaschedulingservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaschedulingservice>';
CREATE DATABASE trifactaschedulingservice WITH OWNER trifactaschedulingservice;

Time-based Trigger database

CREATE ROLE trifactatimebasedtriggerservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactatimebasedtriggerservice>';
CREATE DATABASE trifactatimebasedtriggerservice WITH OWNER trifactatimebasedtriggerservice;

Configuration Service database

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

Artifact Storage Service database

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

Job Metadata Service database

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

Authorization Service database

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

Orchestration Service database

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

Optimizer Service database

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

Secure Token Service database

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

Connector Configuration Service database

Note

The default values for this database do not follow the naming conventions for other databases.

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

Manual DB Install for MySQL

Use the following steps to manually initialize the databases required by the platform in MySQL.

Launch MySQL

Prerequisites for MySQL:

  • The installing user must have write permissions to the directory from which the commands are executed.

  • The installing user must have sudo privileges.

  1. Login to MySQL as the root user. When prompted, enter the password for root user:

    mysql -u root -p

  2. Execute the following commands using the root user.

    Note

    The values in platform configuration must match the values that you use below. Below are the default values.

Alteryx database

Create USER 'trifacta' IDENTIFIED BY '<pwd_trifacta>';
CREATE DATABASE trifacta;
Grant all on trifacta.* to trifacta;

Jobs database

Create USER 'trifactaactiviti' IDENTIFIED BY '<pwd_trifactaactiviti>';
CREATE DATABASE trifacta-activiti;
Grant all on trifacta-activiti.* to trifactaactiviti;

Scheduling database

Create USER 'trifactaschedulingservice' IDENTIFIED BY '<pwd_trifactaschedulingservice>';
CREATE DATABASE trifactaschedulingservice;
Grant all on trifactaschedulingservice.* to trifactaschedulingservice;

Time-based Trigger database

Create USER 'trifactatimebasedtriggerservice' IDENTIFIED BY '<pwd_trifactatimebasedtriggerservice>';
CREATE DATABASE trifactatimebasedtriggerservice;
Grant all on trifactatimebasedtriggerservice.* to trifactatimebasedtriggerservice;

Configuration Service database

Create USER 'trifactaconfigurationservice' IDENTIFIED BY '<pwd_trifactaconfigurationservice>';
CREATE DATABASE trifactaconfigurationservice;
Grant all on trifactaconfigurationservice.* to trifactaconfigurationservice;

Artifact Storage Service database

Create USER 'trifactaartifactstorageservice' IDENTIFIED BY '<pwd_trifactaartifactstorageservice>';
CREATE DATABASE trifactaartifactstorageservice;
Grant all on trifactaartifactstorageservice.* to trifactaartifactstorageservice;

Job Metadata Service database

Create USER 'trifactajobmetadataservice' IDENTIFIED BY '<pwd_trifactajobmetadataservice>';
CREATE DATABASE trifactajobmetadataservice;
Grant all on trifactajobmetadataservice.* to trifactajobmetadataservice;

Authorization Service database

Create USER 'trifactaauthorizationservice' IDENTIFIED BY '<pwd_trifactaauthorizationservice>';
CREATE DATABASE trifactaauthorizationservice;
Grant all on trifactaauthorizationservice.* to trifactaauthorizationservice;

Orchestration Service database

Create USER 'trifactaorchestrationservice' IDENTIFIED BY '<pwd_trifactaorchestrationservice>';
CREATE DATABASE trifactaorchestrationservice;
Grant all on trifactaorchestrationservice.* to trifactaorchestrationservice;

Optimizer Service database

Create USER 'trifactaoptimizerservice' IDENTIFIED BY '<pwd_trifactaoptimizerservice>';
CREATE DATABASE trifactaoptimizerservice;
Grant all on trifactaoptimizerservice.* to trifactaoptimizerservice;

Secure Token Service database

Create USER 'trifactasecuretokenservice' IDENTIFIED BY '<pwd_trifactasecuretokenservice>';
CREATE DATABASE trifactasecuretokenservice;
Grant all on trifactasecuretokenservice.* to trifactasecuretokenservice;

Connector Configuration Service database

Note

The default values for this database do not follow the naming conventions for other databases.

Create USER 'trifactaconnectorconfigservice' IDENTIFIED BY '<pwd_trifactaconnectorconfigservice>';
CREATE DATABASE trifactaconnectorconfigservice;
Grant all on trifactaconnectorconfigservice.* to trifactaconnectorconfigservice;
In this section: