Welcome to the PostgreSQL Connector Setup guide!
In this article, we will cover the following:
Authenticating PostgreSQL in Savant
Connecting Data from PostgreSQL
Authenticating PostgreSQL in Savant
IP Whitelisting
Savant accesses your PostgreSQL from two IP addresses:
35.188.163.165
34.122.126.216
If your network is configured to only allow access from certain IPs, include these in your whitelist.
Create a Savant User in PostgreSQL
We recommend creating a specific user and role for Savant with permission to access the required table(s) in PostgreSQL. If you already have a user and role created with appropriate permissions, you can skip this step.
CREATE USER savant WITH PASSWORD '{Password}';
Grant Permissions in PostgreSQL
Grant the Savant user privileges to access all tables.
Run these commands to grant permissions to the Savant role:
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ALL TABLES IN SCHEMA {schema} TO savant;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA {schema} TO savant;
GRANT CREATE, USAGE ON SCHEMA {schema} TO savant;
SSL (Recommended)
If you turn on SSL, and you are using a self-signed certificate like below, you need to upload to savant.
Example:
-----BEGIN CERTIFICATE----- MIIDHzCCAgegAwIBAgIUFrpVEmv/6tsiiiuDXaxpEW4mNhUwDQYJKoZIhvcNAQEL BQAwHzEdMBsGA1UEAwwUKi5zcWwuc2F2YW50LWRldi5uZXQwHhcNMjIwMzI2MTM1 NjQzWhcNMjMwMzI2MTM1NjQzWjAfMR0wGwYDVQQDDBQqLnNxbC5zYXZhbnQtZGV2 Lm5ldDCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAL57IDUoPLtIpheL LiOcc2xIBhtMZfE4g4CCmbetwoIJXYptbxld/lS7xbOgdpWK0FMpuIg5x+NBWfqw bLnp0/2INP/78LO4U5aAJp3m45mNRKWzAKMtcrX7kW4OfL2DcaIb5vKkFY+Y3oDr 3JVsnOfbx5vS2ppfIuQEKX+gRoijTEaMxQoyaV6MSsJ9HVMidlKG+4KO3/V29Wst rvGbbSnS5rvFIgGTahcwMa7C/pngGTbGZW8gUE21G2e7Iq1Lv7y7Yw89xW227ttG T84BdsTjSVAFgaddENftSSsHUrlsKUfV1VqjQpyxEXPI3wLFR/0LaWaJl571EONm eNjV4+UCAwEAAaNTMFEwHQYDVR0OBBYEFIYXUucb43NG/HFwqtsSbdLtGCWVMB8G A1UdIwQYMBaAFIYXUucb43NG/HFwqtsSbdLtGCWVMA8GA1UdEwEB/wQFMAMBAf8w DQYJKoZIhvcNAQELBQADggEBAES5WrvFbRNILSMTdK39DcKBzhKTQ4GhPA8PrhxR cNZQl7zqEzSxNaVRGTJlOEuUNAr2gnInnCT0CsraQ56f2glJWryQUoR0TDJvH1QY KJJcyBBfYZaeNyuY+anNJgleIiZ3HD5H5/3Dr0hXhJKUH8O0/G1hNeVbilsgeApv 3T8hb/VcraeoHEDW39rleu2U0iosLgAbiC1SBwPu2xRSzZKjOU3X5FvahsG+aZfF 6KvcCAFYzR70RMo8bHhthh3F/6PoV4YIsoS1YbrHGt1T2GbrKJrdZfqO+IiQn7a0 r5BWz7FvduCH//L8TIW+ovB+mrEMzVP6KTn5EQhD2oKiBVA=
-----END CERTIFICATE-----
Adding PostgreSQL System in Savant
Once you’ve completed the steps above, follow these steps in Savant:
Go to the Systems page and click Add System
Select the PostgreSQL connector and click Next
Enter your system information and credentials from above
Click Authenticate and then Confirm
Connecting Data from PostgreSQL
On the top left side of your canvas, click the Add Source button, shown below and select your new PostgreSQL connection.
If you are not currently within an analysis, you can add your connection by navigating to Data and selecting New Dataset. Select your previously authenticated PostgreSQL system from the list of available options and click Next.
Now you can configure the dataset and decide which data from various objects you would like to import into your analysis.
Select which Object you would like to import into your data source from the drop down menu.
Select which Columns you want to include in the dataset.
Once you're done, click Next.
Next, add a name and description to your data set to be used within your canvas and click Confirm.
Your data from PostgreSQL is now placed on your canvas as a source for your analysis!