PostgreSQL is a popular, open-source relational database (RDMBS). You can connect to any table in any schema in PostgreSQL and create a Quantive entity based on it.
How to connect
In Quantive, navigate to Settings > Data Sources screen
Click the Select data source button
From the Choose a connector dialog, select the Databases tab and then PostgreSQL
Enter the necessary information to connect to your PostgreSQL database:
Host: the address of the PostgreSQL instance. It could be a domain name or an IP address. This instance should allow remote access.
Database: the name of the database
Schema: the name of the schema to which you want to connect
Username: the name of the user with which you wish to connect
Password: the password of the user with which you wish to connect
Port: the port where PostgreSQL is listening. The default is 5432, which is a standard PostgreSQL port
Click on the Connect data source button.
Define who will have access and who will be able to administrate this connection using Data Connection permissions.
Choose a table to which you want to connect and click on the Use ... button
Give the name to your data source, something that makes sense to you and select the sync schedule (how often you want this data source to be synced automatically)
Click on the Add my data source button
Define who will have access and use the information in this entity to create insights and automate KRs and KPIs using the Data Source permissions
Click on the Finish button.
Note: Contact us for information on Quantive's outbound IPs for your account if you need to create a firewall rule to enable external access.
What data from PostgreSQL can I use?
You can sync any field from any table in any schema that is accessible to the user with which you connected to the PostgreSQL database.
Quantive will automatically coerce types for you, so for example, date and timestamp can both be mapped to the Quantive date type.