Connect Tableau to Query Service

This document covers the steps for connecting Tableau with Adobe Experience Platform Query Service.

NOTE

This guide assumes you already have access to Tableau and are familiar with how to navigate its interface. More information about Tableau can be found in the official Tableau documentation.

To connect Tableau to Query Service, open Tableau, and in the To a Server section select More followed by PostgreSQL

You can now enter values to connect with Adobe Experience Platform. For more information on finding your database name, host, port, and login credentials, please read the credentials guide. To find your credentials, log in to Platform, then select Queries, followed by Credentials.

Ensure that you have checked the SSL Required box before trying to connect.

IMPORTANT

See the Query Service SSL documentation to learn about SSL support for third-party connections to Adobe Experience Platform Query Service, and how to connect using verify-full SSL mode.

IMPORTANT

Nested data structures in third-party BI tools can be flattened to improve their usability and reduce the required workload to retrieve, analyze, transform and report data. See the documentation on theFLATTEN feature for instructions on how to activate this setting when connecting to a database.

After filling in all your credentials, select Sign In to continue.

You have now connected with Adobe Experience Platform, with a list of your tables displayed on the side.

Next steps

Now that you’ve connected with Query Service, you can use Tableau to write queries. For more information on how to write and run queries, please read the guide on running queries.

On this page