- Query Service overview
- Query Service packaging
- Query Service guardrails
- Get started
- Data Distiller
- Use cases
- Abandoned browse
- Attribution analysis
- Bot filtering
- Create a trended report of events
- Consent analysis
- Customer lifetime value
- Decile-based derived attributes
- Fuzzy match
- List the page views of a user
- List visitors by their page views
- Propensity score
- SQLAlchemy
- Return and use merchandising variables from analytics data
- View the roll-up report for a visitor
- Web and mobile analytics insights
- Key concepts
- Connect clients to Query Service
- Query Service UI
- Query Service API endpoints
- Data Governance
- Best practices
- SQL reference
- Frequently asked questions
- IP address allowlist
- API reference
- Platform release notes
Connect Postico to Query Service (Mac)
This document covers the steps for connecting Postico with Adobe Experience Platform Query Service.
This guide assumes you already have access to Postico and are familiar with how to navigate its interface. More information about Postico can be found in the official Postico documentation.
Additionally, Postico is only available on macOS devices.
To connect Postico to Query Service, open Postico and select New Favorite. The dialog for connection settings appears. From here, you can enter parameter values to connect with Adobe Experience Platform. Enter the connection settings listed below. Instructions on how to connect to a PostgreSQL server with Postico are also available from the official Postico website.
| Connection parameter | Description |
|---|---|
| Host: | The host name of the PostgreSQL server. |
| Port: | The port for Query Service. You must use port 80 or 5432 to connect with Query Service. |
| User | Create a name for your specific connection. Leave the field blank to use your Mac login name. |
| Password | This 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. |
| Database | Use your Experience Platform Database credential value: prod:all. |
For more information on finding your database name, host, port, and login credentials, please read the credentials guide. To find your credentials, log in to Platform, then select Queries, followed by Credentials.
After inserting your credentials, select Connect to connect with Query Service.
After connecting to Platform, you’ll be able to see a list of all the relations previously made with Query Service.
Create SQL statements
To create a new SQL query, select SQL Query from the sidebar. Alternatively, use the keyboard shortcut (⇧⌘T) to navigate to the query view and enter the query you want to execute. When finished, select Execute Statement to run the query. A table appears with the results of your completed query run.
See the official Postico documentation for more information on using the query view.
Next steps
Now that you’ve connected with Query Service, you can use Postico to write queries. For more information on how to write and run queries, please read the running queries guide.
Resources
Adobe Account
