2021.10
Collibra DIC Integration
Powered By GitBook
Add a Connection

How to Add DB Connection via UI

We will add a connection named metastore that connects to local Postgres server (localhost:5432/postgres)
    Login to DQ Web and navigate to Admin Console.
Fig 1: Home Page
    From the Admin Console, click on the Connections tile.
Fig 2: Admin Console
    Click on Add button in Postgres box to add a Postgres connection
Fig 3: List of DB Connections
Default Postgres JDBC template connection is shown. This modal is populated with basic values what Postgres connection setting should look like.
Fig 4: Template Postgres connection creation modal
Replace the Connection URL to point to the Postgres server you want to run DQ Jobs against. In this example, jdbc:postgresql://localhost:5432/postgres
Also change Driver Location to the JDBC Driver for Postgres in your installation. Click on the folder icon and click on Postgres driver path. These Driver Directories are default JDBC Drivers provided by DQ installation (usually in $OWL_BASE/owl/drivers/*)
Fig 5: Add new driver or select existing from Driver Directories
Fig 6 is what the new connection setting should look like. Make sure to provide the correct Postgres Username and Password (if using Username/Password for authentication). Press Save to continue. This action will attempt to establish a connection.
Fig 6: Connection settings to connect to database named "postgres" in Postgres server "localhost" exposed via port 5432
Make sure to Link DB Connection to a DQ Agent, if required
Last modified 14d ago