PostgreSQL

This article describes how to create a PostgreSQL data source.

To create a PostgreSQL data source:

1. In the Navigation Panel, go to Integrations > Catalog.
2. Use the Search box OR click the Databases filter to locate the data source.
3. Hover over the PostgreSQL tile, and click Start. The Postgres dialog is displayed, as shown below.
   Note: If the data source has already been used, a dialog is displayed in which you can select from one of the listed sources. Alternatively, create a new source by clicking Add a new source.
   
   
4. Enter your Server location.
5. Either enter your PostgreSQL port number or leave the default port number [5432] as-is.
6. Enter a Database name.
7. [Optional] Enter a user name.
8. [Optional] Enter a user password.
9. Select/clear the Use SSL checkbox. By default it is selected.
10. Select the Verify Server Certificate checkbox.
11. Add an Anodot server IP to your firewall's allowlist. See Allowlist Anodot Servers.
12. Click CONTINUE to open the Stream Query window.

Note: To create a PostgreSQL stream query, see Creating a Stream Query from a Database.

See Also: 
Using Data Collectors
Collecting and Streaming Data
Stream Tables
Stream Summaries