Re-Configure Tableau Server Repository

Your Tableau Server may be configured to use either a local or an external repository. This topic describes the steps needed to reconfigure your existing Tableau Server with one of the following options:

  • Move a local Tableau Server Repository to an external repository and configure your Tableau Server to use an external repository.

  • Move the external Tableau Server Repository to your local Tableau Server installation, and configure your Tableau Server to use the local repository. This means that the Tableau Server repository will be installed on the same machine or machines as your Tableau Server.

To learn more about these options and external repositories, see Tableau Server External Repository.

Move a local Tableau Server Repository to external

Use the following steps to move Tableau Server Repository from local to external:

  1. Activate the Server Management Add-on product key on your Tableau Server if it is not already activated. Server Management Add-on license is required to configure your Tableau Server with an external repository.
  2. Configure Amazon PostgreSQL DB instance to use as the external repository.
    1. Amazon: Create a PostgreSQL DB Instance on AWS Relational Database Service (RDS).
    2. Azure Database: Create a Azure Database PostgreSQL Instance on Azure.
    3. Stand-alone PostgreSQL Instance: Create a PostgreSQL Database as a Stand-alone Installation .
  3. Create a json file with the following configuration settings:

    {
     "flavor":"<flavor name",
     "masterUsername":"<admin user name>",
     "masterPassword":"<password>", 
     "host":"<instance host name>",
     "port":5432
    }
    

     

    • flavor: This is the type of external service you are going to use for Tableau Server repository.

      • Amazon RDS: use “rds”.
      • Azure Database: use "azure"
      • Stand-alone PostgreSQL instance: use "generic"
    • masterUsername:

      • Amazon RDS: Use "rails" for the user name. This is the user that you specified when creating the RDS instance.

        You must use "rails" as the masterUsername. This is required for the external repository to work with Tableau Server properly.

      • Azure Database and Stand-alone PostgreSQL instance: Choose a user name that meets your requirements. We recommend using postgres as the Administrator user name. If you choose to use a different user name, make sure that the user name does not start with pg, or azure. The user name also cannot be rails, tblwgadmin, tableau, readonly, or tbladminviews.
    • masterPassword: This is the same password you specified when creating the PostgreSQL database instance.

    • host: This is the endpoint of your PostgreSQL database instance.

    • port: The database port you specified when creating the PostgreSQL DB instance.

  4. Run the following TSM CLI command to configure Tableau Server to use external repository:

    tsm topology external-services repository enable -f file.json -c <ssl certificate file>.pem

    The json file is the file that you created in the first step with the configuration settings. The SSL certificate file can be downloaded as described in this topic(Link opens in a new window).

    Running the above command will migrate the local repository to your new external PostgreSQL DB instance.

Move the external Tableau Server Repository to the local installation of Tableau Server

You can move the external Tableau Server Repository from to your local installation of Tableau Server.

  1. Run the following TSM CLI command to move the repository to a specific node:

    tsm topology external-services repository disable -n nodeN

  2. If you are setting up HA for your repository, install the repository on a second node. For more information, see Example: Install and Configure a Three-Node HA Cluster.

    Note: To install the repository on a second node, you must run the command described in the previous step first. The first step migrates your external repository to the local repository. You can then install the repository on a second node on your Tableau Server.

Who can do this

Tableau Server Administrators can reconfigure external repository. You will also need to have access to create PosgreSQL database instance on Amazon or Azure.

Thanks for your feedback!