Connecting to a PostgreSQL database

The first step of connecting FactBranch to a PostgreSQL database is creating a new PostgreSQL connection in FactBranch.

Contents

Pick the connection type

After signing up for FactBranch you'll see a list of connection types available in FactBranch. If you've signed up some time ago, log in and go to your integrations page to return to this list. Select PostgreSQL to get started.

Set up the connection

Enter the database credentials and hit Test connection. FactBranch will try to connect to your database and either display a success message below or an error message telling you what went wrong.

For security reasons the credentials you enter at this step will never be displayed anywhere in your account settings and only be used by FactBranch servers to query your database. Nevertheless we recommend to create a new database-user just for FactBranch that has as few permissions as possible.

Static IP & firewalls

If your database server sits behind a firewall and you have to allow access from specific IPs, select Use a static IP when making database requests and allow access from the IP address that's displayed in the yellow box.

Finish setup

Once you get the green success box, click Save and continue to create the connection. You'll be taken to the SQL editor to write your first PostgreSQL query in FactBranch.

Next step: Enter the PostgreSQL query

New features, customer support tips, CRM insights

Don't miss our newsletter. We write about how to provide context to sales and support teams, about new features in FactBranch and about best-practices in customer relationship management.

By signing up you agree to our Privacy Policy.