Collibra DQ User Guide

Adding Connections

We've moved! To improve customer experience, the Collibra Data Quality User Guide has moved to the Collibra Documentation Center as part of the Collibra Data Quality 2022.11 release. To ensure a seamless transition, will remain accessible, but the DQ User Guide is now maintained exclusively in the Documentation Center.

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