PostgreSQL

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

  1. Click Data and select New Data Connections from the left navigation bar
  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 Phrazor
  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 Phrazor with the relevant timestamp reflecting the date and time of upload and refresh