PostgreSQL

PostgreSQL is an open source relational database system. PostgreSQL uses the SQL (Structured Query Language) for querying the database.

PostgreSQL in ADOC

ADOC provides data reliability capability for data stored in your PostgreSQL data source. You must create a data plane or use an existing data plane to add PostgreSQL as a data source in ADOC. Once you add PostgreSQL as a data source, you can view the details of your assets in PostgreSQL database in the Data Reliability tab in ADOC.

Steps to Add PostgreSQL as a Data Source

To add PostgreSQL as a Data source:

1. Click Register from the left pane.
2. Click Add Data Source.
3. Select the PostgreSQL Data Source. PostgreSQL Data Source basic Details page is displayed.

4. Enter a name for the data source in the Data Source name field.
5. (Optional) Enter a description for the data source in the Description field.
6. Enable the Data Reliability capability by switching on the toggle switch.
7. Select a Data Plane from the Select Data Plane drop-down menu.

To create a new Data Plane, click Setup Dataplane.

8. Click Next. The PostgreSQL Connection Details page is displayed.

9. Enter your PostgreSQL URL in the PostgreSQL URL field.
10. Enter your PostgreSQL username in the Username field.
11. Enter your PostgreSQL password in the Password field.

12. Click Test Connection. If your credentials are valid, you receive a Connected message. If you get an error message, validate the PostgreSQL credentials you entered.

13. Click Next. The Observability Setup page is displayed.
14. Turn on the Enable Torch Query Analysis Service toggle switch to enable the query analysis service.
15. Enter the schema to be monitored by ADOC in the Schema field. To add multiple schemas, click +.
16. Select the PostgreSQL environment in the Postgresql Environment field.
17. Enable Crawler Execution Schedule: Turn on this toggle switch to select a time tag and time zone to schedule the execution of crawlers for Data Reliability.

17. Click Submit.

PostgreSQL is now added as a data source. You can choose to crawl your PostgreSQL account now or later.

You can see that a new card is created for PostgreSQL on the data sources page. This card displays the total cost for current month, crawler status and other details of your PostgreSQL data source.