Install Standalone

After performing the steps in Before You Install Standalone, you are ready to install Collibra DQ Standalone.

Run the setup script

After extracting the DQ package and setting the environment variables (described in Before you install), you are ready to run the setup.sh script. This script installs Collibra DQ and the required components, including Spark and PostgreSQL. You may install the components separately or at the same time.

When executing the setup.sh script, use the -options parameter to specify which components are installed. The options are:

  • spark (required)
  • owlweb (required)
  • owlagent (required)
  • postgres (optional)

Note that Java is a required component, but it is not included in the installation package.

You have the option to include the PostgreSQL metastore in the installation or use an external PostgreSQL metastore (recommended). Both options are described next.

Install Collibra DQ, Spark, and PostgreSQL metastore

To include PostgreSQL metastore in the installation process, include postgres in the -options parameter. For example, the following command executes setup.sh and installs PostgreSQL locally:

Copy
./setup.sh \
-owlbase=$OWL_BASE \
-user=$OWL_METASTORE_USER \
-pgpassword=$OWL_METASTORE_PASS \
-options=postgres,spark,owlweb,owlagent

When the setup script completes, you are prompted to finish the PostgreSQL installation:

Copy
Postgres DB needs to be intialized. Default location = <OWL_BASE>/postgres/data
to change path please enter a FULL valid path for Postgres and hit <enter>
DB Path [ <OWL_BASE>/owl/postgres/data ] =

Use the default location unless the PostgreSQL needs to be hosted at a specific location. If you change the location, verify that the directory is writable.

Note To see the directory structure created by setup.sh, go to Collibra DQ Directory Structure.
Note For additional configuration options in setup.sh, owl-env.sh, and owl.properties, go to Additional Standalone Configuration Options.

Install Collibra DQ and Spark with an external PostgreSQL metastore (recommended)

If you would like to use an external PostgreSQL metastore, such as a GCP Cloud SQL service, omit postgres from the -options parameter and include -pgserver in the command. For example:

Copy
./setup.sh \
-owlbase=$OWL_BASE \
-user=$OWL_METASTORE_USER \
-pgpassword=$OWL_METASTORE_PASS \
-options=spark,owlweb,owlagent \
-pgserver="localhost:5432/postgres"

In this example, the installation process does not install PostreSQL and instead uses the existing PostgresDB server located in localhost:5432 with the postgres database, which is the default DQ metadata storage.

Note To see the directory structure created by setup.sh, go to Collibra DQ Directory Structure.
Note For additional configuration options in setup.sh, owl-env.sh, and owl.properties, go to Additional Standalone Configuration Options.

What's next?

Complete the Initial Setup