PostgresSQL Database Connector

The PostgresSQL Database Connector will create a connection to a database to load data into Inzata. Shown on the right side of this screen, the settings are as follows:

Choose Credentials: Click this button to open the Creditials dialogue.  Then click “Add” in the dialogue window that opens to add your first PostgresSQL login credential.   

Choose Database: Choose the name of the database.

Choose Tables Use SSL (optional): Select this if you would like to secure the server to browser transaction. If the data being loaded contains secure or identifying information, this should be selected. 

Use Custom Query: Type or paste your SQL Select statement into the box. 

Number of rows to download (optional): Enter in the number of rows to load in. This will only load in the number of rows specified, even if the Query would normally return more rows of data.