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.