Connect DbVisualizer to Query Service connect-dbvisualizer
This document covers the steps for connecting the DbVisualizer database tool with Adobe Experience Platform Query Service.
Getting started
This guide requires that you already have access to the DbVisualizer desktop app and are familiar with how to navigate its interface. To download the DbVisualizer desktop app or for more information, see the official DbVisualizer documentation.
To acquire the necessary credentials for connecting DbVisualizer to Experience Platform, you must have access to the Queries workspace in the Platform UI. Please contact your organization administrator if you do not currently have access to the Queries workspace.
Create a database connection connect-database
Once you have installed the desktop app on your local machine, follow the official BDVisualizer instructions to create a new database connection.
Once you have selected PostgreSQL from the Connections list, an Object View tab for the new PostgreSQL connection appears.
Set driver properties for your connection properties
From the PostgreSQL object view tab, select the Properties tab, followed by the Driver Properties from the navigation sidebar. More information on driver properties can be found in the official documentation.
Next, enter the driver properties described in the table below.
verify-full
SSL mode.PGHOST
ssl
1
to enable the use of SSL.sslmode
require
SSL mode when connecting third-party clients to Adobe Experience Platform. The require
mode ensures that encryption is required on all communications and that the network is trusted to connect to the correct server. Server SSL certificate validation is not required.user
@Adobe.Org
. This value is your Experience Platform Username credential.Use the search bar to find each property then select the corresponding cell for the parameter’s value. The cell will highlight in blue. Enter your Platform credential in the value field and select Apply to add the driver property.
user
profile, select user
from the parameter column then select the blue + (plus) icon to add credentials for each user. Select Apply to add the driver property.The Edited column shows a checkmark to denote that the parameter value has been updated.
Input Query Service credentials query-service-credentials
To find the credentials necessary to connect BBVisualizer with Query Service, log in to the 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.
credential
and technicalAccountId
values acquired comprise the value for the DBVisualizer password
parameter.Authentication 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 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.
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.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.
Next steps
Now that you have connected DbVisualizer with Query Service, you can use DbVisualizer to write queries. For more information on how to write and run queries, please read the guide on query execution.