This document covers the steps for connecting Aqua Data Studio with Adobe Experience Platform Query Service.
This guide requires you to already have access to Aqua Data Studio and be familiar with how to navigate its interface. More information about Aqua Data Studio can be found in the official Aqua Data Studio documentation.
There are Windows and macOS versions of Aqua Data Studio. Screenshots in this guide were taken using the macOS desktop app. There may be minor discrepancies in the UI between the versions.
To acquire the necessary credentials for connecting Aqua Data Studio to Experience Platform, you must have access to the Queries workspace in the Platform UI. Please contact your IMS Organization administrator if you do not currently have access to the Queries workspace.
After installing Aqua Data Studio, you must first register the server. From the main menu, select Server, followed by Register Server.
The Register Server dialog appears. Under the General tab, select PostgreSQL from the list on the left-hand side. In the dialog that appears, provide the following details for the server settings.
To find your credentials, log in to the Platform UI and select Queries from the left navigation, followed by Credentials. For complete directions to find your login credentials, host, port, and database name, please read the credentials guide.
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.
Next, select the Driver tab. Under Parameters, set the value as
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.
After inputting your connection details, select Test Connection to ensure your credentials work properly. If your connection test is successful, select Save to register your server. A confirmation dialog appears confirming connection and the connection appears on the dashboard. You can now connect to the server and view its schema objects.
Now that you have connected to Query Service, you can use the Query Analyzer within Aqua Data Studio to execute and edit SQL statements. For more information on how to write and run queries, please read the running queries guide.