PostgreSQL

To securely connect Explorazor to your PostgreSQL database and retrieve data -

1. Click Datasets and select Add New from the top right
2. Under Database Connections click Connect PostgreSQL DB
3. Connect to your PostgreSQL database by entering the requested information in the fields -
4. Click the False option for Live Connection. Once all the fields are filled click Select Tables to choose from the tables you want to transfer to Explorazor
5. A list of tables within your database will appear. Check the boxes next to the tables you want and click Select Columns
6. To choose from the columns availble in the tables selected Select All if you want all the columns or check the boxes next to the columns you want to include and click Confirm
7. Data retrieved from your PostgreSQL database will get stored as a dataset in Explorazor with the relevant timestamp reflecting the date and time of upload and refresh