Input Query Service credentials

To find the credentials necessary to connect BBVisualizer with Query Service, log in to the Experience Platform UI and select Queries from the left navigation, followed by Credentials. For more information on finding your host, port, database, username, and password credentials, please read the credentials guide.

The Credentials page of the Experience Platform Queries workspace with Credentials and the Expiring Credentials highlighted.

IMPORTANT
Query Service also offers non-expiring credentials to allow for a one-time setup with third-party clients. See the documentation for full instructions on how to generate and use non-expiring credentials. It is necessary to complete this process if you wish to connect BDVisualizer as a one-time setup. The credential and technicalAccountId values acquired comprise the value for the DBVisualizer password parameter.

Authentication

To require a user ID and password-based authentication each time a connection is established, navigate to the Properties tab and select Authentication from the navigation sidebar under PostgreSQL.

In the Connection Authentication panel, check both the Require Userid and Require Password checkboxes then select Apply. More information on setting authentication options can be fond in the official documentation.

Connect to Experience Platform

You can make a connection using expiring or non-expiring credentials. To make a connection, select the Connection tab from the PostgreSQL object view tab and enter your Experience Platform credentials for the following settings. Complementary instructions to set up a manual connection are available on the official DBVisualizer website.

NOTE
All credentials required by BDVisualizer in the table below are the same for expiring and non-expiring credentials unless stated in the parameter description.
Connection parameterDescription
NameCreate a name for your connection. You are recommended to provide a human-friendly name to recognize the connection.
Database ServerThis is your Experience Platform Host credential.
Database PortThe port for Query Service. You must use port 80 or 5432 to connect with Query Service.
DatabaseUse your Experience Platform Database credential value: prod:all.
Database UseridThis is your Experience Platform organization Id. Use your Experience Platform Username credential value. The ID will be in the format of ORG_ID@AdobeOrg.
Database PasswordThis alphanumeric string is your Experience Platform Password credential. If you want to use non-expiring credentials, this value is the concatenated arguments from the 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.

After you have input all relevant credentials, select Connect.

The Connect dialog appears on the first occasion of the session. Enter your Userid and Password and select Connect. A message appears in the log to confirm a successful connection.