![]() At a minimum, use Flexible Server with General Purpose computer tier, and Standard_D8s_v3 (8 vCores, 32 GB RAM) compute size.For a full list of PostgreSQL versions compatible with Tableau Server versions, see Product Compatibility. Use the compatible version of PostgreSQL for the version of Tableau Server you are using.Pick a password that meets Azure's requirements. The user name also cannot be rails, tblwgadmin, tableau, readonly, or tbladminviews. If you choose to use a different user name, make sure that the user name does not start with pg, or azure. For Admin user name, we recommend using postgres as the Administrator user name.Specify None as the Data source to create a new server.To create a new Azure Database for PostgreSQL, follow the instructions provided on the Azure documentation site (Link opens in a new window).įollowing are configuration options and the recommended values for the new PostgreSQL DB instance: Step 2: Create an Azure Database for PostgreSQL instance For more information on setting up private access see Networking Options for Azure Database for PostgreSQL - Flexible Server on the Azure website. On the same virtual network where you are currently hosting your Tableau Server, create a new delegated subnet for the Azure Database instance. This let the virtual machines created anywhere in that Virtual Network to connect to the database instance, but none outside of the Virtual Network is able to do so. Setting up private access to the database is a must for secure communications. This step is a prerequisite for setting up private access for your networking option when you create the instance. If you specify a policy that includes character types other than numbers and lower-case letters, this can cause errors while configuring Tableau Server to use the external repository.Ĭreate a Database PostgreSQL instance on Azure Step 1: Create a delegated subnet for the Azure Database for PostgreSQL instance Your external PostgreSQL instance may allow you to set a password policy (this will depend on the platform you are using). They cannot be accessed or configured by an admin. These passwords are 32 characters long and consist of lower-case letters and numbers. Tableau auto-generates passwords for internal use by internal database users. Tableau Server 2020.4 uses PostgreSQL version 12. The version of PostgreSQL should match the version used by Tableau Server when installed locally. When setting up the Azure Database instance, we recommend using postgres as the Administrator user name. This method exposes the Azure Database endpoint to public access on the internet. Alternatively Azure Database for PostgreSQL can be configured to allow connections from a range of public IP addresses.You may also want to review the overview topic on Azure virtual networks. For more information, see Use Virtual Network service endpoints and rules for Azure Database for PostgreSQL and Create and Manage VNet service endpoints. This is most secure way: Configure Azure Database for PostgreSQL instance to only allow private access via the Virtual Network service endpoint. The database instance must be set up to allow connections from all the Tableau Server nodes. The PostgreSQL DB instance must be reachable by all nodes in the Tableau Server cluster. If you do not want to use secure connections between Tableau Server and External Repository, you should configure the Azure Database to allow unencrypted connections. Secure communications between Tableau Server and the external PostgreSQL DB instance using SSL is recommended, but not a requirement. For more information, see Scaling your PostgreSQL Azure Database resources. You can also scale your resources if you find that you need more. If you already have a Tableau Server, review the usage of your existing repository to determine your storage needs. We recommend that you use 8 vCore memory optimized server with 50 GB of storage for Tableau Server external repository, but the exact requirements will vary with your requirements and usage. This topic describes how to create a Azure Database for PostgreSQL instance to use as your Tableau Server external repository. Beginning in version 2020.4, you can host your External Repository on the Azure Cloud Platform.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |