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.
.png)
