![]() Now that you have connected DbVisualizer with Query Service, you can use DbVisualizer to write queries. A message appears in the log to confirm a successful connection. Enter your Userid and Password and select Connect. The Connect dialog appears on the first occasion of the session. The configuration JSON file for non-expiring credentials is a one-time download during their initialization that Adobe does not keep a copy of.Īfter you have input all relevant credentials, select Connect. 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. This alphanumeric string is your Experience Platform Password credential. Use your Experience Platform Username credential value. Use your Experience Platform Database credential value: prod:all. You must use port 80 or 5432 to connect with Query Service. This is your Experience Platform Host credential. You are recommended to provide a human-friendly name to recognize the connection. Connection parameterĬreate a name for your connection. Complementary instructions to set up a manual connection are available on the official DBVisualizer website.Īll credentials required by BDVisualizer in the table below are the same for expiring and non-expiring credentials unless stated in the parameter description. To make a connection, select the Connection tab from the PostgreSQL object view tab and enter your Experience Platform credentials for the following settings. You can make a connection using expiring or non-expiring credentials. More information on setting authentication options can be fond in the official documentation. In the Connection Authentication panel, check both the Require Userid and Require Password checkboxes then select Apply. 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. The credential and technicalAccountId values acquired comprise the value for the DBVisualizer password parameter. It is necessary to complete this process if you wish to connect BDVisualizer as a one-time setup. See the documentation for full instructions on how to generate and use non-expiring credentials. Query Service also offers non-expiring credentials to allow for a one-time setup with third-party clients. Enter your Platform credential in the value field and select Apply to add the driver property. Use the search bar to find each property then select the corresponding cell for the parameter’s value. It is an alphanumeric string ending in This value is your Experience Platform Username credential. The username connected to the database is your organization ID. Server SSL certificate validation is not required. The require mode ensures that encryption is required on all communications and that the network is trusted to connect to the correct server. You are recommended to use the require SSL mode when connecting third-party clients to Adobe Experience Platform. This controls the level of SSL protection. This value is your Experience Platform Host credential.ĭefine the SSL value 1 to enable the use of SSL. See the SSL modes 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. To connect DBVisualizer with Adobe Experience Platform, you must enable the use of SSL. Next, enter the driver properties described in the table below. More information on driver properties can be found in the official documentation. Set driver properties for your connectionįrom the PostgreSQL object view tab, select the Properties tab, followed by the Driver Properties from the navigation sidebar. Once you have selected PostgreSQL from the Connections list, an Object View tab for the new PostgreSQL connection appears. Once you have installed the desktop app on your local machine, follow the official BDVisualizer instructions to create a new database connection. Please contact your IMS Organization administrator if you do not currently have access to the Queries workspace. To acquire the necessary credentials for connecting DbVisualizer to Experience Platform, you must have access to the Queries workspace in the Platform UI. To download the DbVisualizer desktop app or for more information, see the official DbVisualizer documentation. This guide requires that you already have access to the DbVisualizer desktop app and are familiar with how to navigate its interface. This document covers the steps for connecting the DbVisualizer database tool with Adobe Experience Platform Query Service.
0 Comments
Leave a Reply. |