Treasurer Hon. Dr Jim Chalmers MP | Press Conference | 17/03/2026

[0:00]Hello, my name is Joe and I'm a solutions architect at Google Cloud. In this video, I'll show you how to set up an environment to connect a Tableau server to a private Google Cloud database. I'll be demonstrating the process with Tableau Server on Windows and a private Cloud SQL for Postgres database, but this solution is also applicable to other operating systems for Tableau Server, such as Linux. A private Google Cloud database is a database that is not directly exposed to the internet. While this offers increased security, it also adds complexity when connecting to it from an external network such as your on-premise network. Therefore, we'll need to set up a secure tunnel between your on-premise network where your Tableau server is located and your Google Cloud network where your database is located. This can be done using either cloud VPN or cloud Interconnect. Once the network connectivity is established, you'll be able to connect to your private Google Cloud database from your Tableau server. There are several steps to connect your Tableau server to a private Google Cloud database. First, you'll need to make sure that the network connectivity between your on-premise network and your Google Cloud network is set up. If you don't have this set up already, you can refer to the Google Cloud documentation on how to configure either cloud VPN or cloud Interconnect. Once the network connectivity is established, you'll need to make sure that the required firewall rules are in place in your Google Cloud project to allow incoming connections from your Tableau server to your private Google Cloud database. Next, you'll need to configure your Tableau server to connect to your private Google Cloud database. This involves installing the appropriate database drivers and creating a new data source in Tableau server. Let's start by configuring the firewall rules. Here, I'm in my Google Cloud project and I've navigated to the firewall rules page in the VPC network section. I'll create a new firewall rule to allow incoming connections from my Tableau server to my Cloud SQL for Postgres database. I'll give the firewall rule a name, select the network that my Cloud SQL database is in, and set the direction of the traffic to ingress. For the action on match, I'll select allow. For the targets, I'll select specified target tags and enter the network tag that I've applied to my Cloud SQL database. For the source IP ranges, I'll enter the IP address range of my on-premise network where my Tableau server is located. This will allow incoming connections from my Tableau server to my Cloud SQL database. Finally, for the protocols and ports, I'll select specified protocols and ports and enter the port number that my Cloud SQL for Postgres database is listening on, which is 5432. Then I'll click create to create the firewall rule. Now that the firewall rule is created, I can configure my Tableau server to connect to my private Cloud SQL for Postgres database. Here I'm connected to my Tableau server, which is running on Windows Server 2019. The first thing I need to do is download and install the appropriate database driver for Postgres. I can do this by going to the Tableau website and downloading the Postgres driver. Once the download is complete, I'll run the installer and follow the prompts to install the driver. After the driver is installed, I'll need to restart my Tableau server for the changes to take effect. I can do this by opening the Tableau Services Manager or TSM in a web browser, navigating to the configuration tab, and clicking on the pending changes section. Here, I'll click restart and confirm that I want to restart Tableau server. Once Tableau server has restarted, I can open Tableau Desktop and create a new data source. I'll select Postgres as the database type and enter the connection details for my Cloud SQL for Postgres database. This includes the private IP address of my Cloud SQL instance, the port number, the database name, and the username and password for the database. Then I'll click sign in to connect to the database. Once connected, I can select the schema and table that I want to use and then drag them to the canvas to create a new data source. Finally, I can publish the data source to Tableau server so that other users can access it. I'll give the data source a name and a description and then click publish. Now, other users can connect to this data source from Tableau Desktop or Tableau Cloud and create reports and dashboards based on the data in my private Cloud SQL for Postgres database. In this video, I've shown you how to set up an environment to connect a Tableau server to a private Google Cloud database. By following these steps, you can securely connect your Tableau server to your private Google Cloud database and unlock the full potential of your data. If you have any questions or need further assistance, please refer to the Google Cloud documentation or contact Google Cloud support.