Connect Tableau to Query Service
This document provides information for connecting Tableau with Adobe Experience Platform Query Service.
Instructions on how to connect to a PostgreSQL server with Tableau are available from the official Tableau website. Once the dialog for connection settings appears, enter your Platform credentials into the parameter fields to connect with Adobe Experience Platform. A list of the required connection parameters are listed below.
prod:all
.ORG_ID@AdobeOrg
.technicalAccountID
and the credential
downloaded in the configuration JSON file. The password value takes the form: {technicalAccountId}:{credential}. The configuration JSON file for non-expiring credentials is a one-time download during their initialization that Adobe does not keep a copy of.For more information on finding your username, password, 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 Require SSL box before trying to connect. See the SSL modes documentation to learn about SSL support for third-party connections to Adobe Experience Platform Query Service.
FLATTEN
feature for instructions on how to activate this setting when connecting to a database.After filling in all your credentials, confirm your settings to continue. You have now connected with Adobe Experience Platform.
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.