Through the AgencyAnalytics' PostgreSQL integration, you can connect directly to your Clients' database and query data, displaying it in widgets alongside other data on dashboards and reports.
Click here to read more about database connectors and how to use database integration widgets.
Note: We strongly recommend that you have a technical resource available to set up your PostgreSQL integration. The AgencyAnalytics Support Team cannot assist with your setup or writing queries.
š Connect PostgreSQL
To avoid a failed connection or error when integrating PostgreSQL to a Client, the person connecting must have:
Host, Port, User, Password and Database
User entered must have read permissions for the entered database
If the above requirements are met, simply follow these steps to connect:
Open the Client where you'd like to connect PostgreSQL, then click the Data Sources tab at the top.
Click the blue Connect Data Source button in the upper right corner of the page.
Search for PostgreSQL in the search bar at the top, then click the PostgreSQL card.
Click Connect New Account to launch the authorization window, or if you've previously connected an account, click the gray + sign at the bottom.
Follow the prompts to add host/user/password and finalize the connection.
Enter the details for the instance you'd like to connect, then Save in the bottom left.
Your PostgreSQL instance will be displayed in the list of available connections. Click the circle to the left of the instance name, then click Connect in the bottom left to finalize the connection.
ā FAQ
Why is my PostgreSQL connection failing even though my credentials are correct?
Please add the following IP addresses to your PostgreSQL allowlist:
34.148.207.61
35.196.154.58
34.138.181.161
35.196.190.6
35.187.224.203
104.196.46.255
34.75.134.155
34.148.57.44
34.139.66.246
34.138.63.129
34.23.214.163
34.73.129.216
104.196.196.229
Once those IPs are allowlisted, try connecting again.
š¬ Need additional help?
If you have any questions, please contact our friendly support team by following these instructions! We're available 24/5 to help š