Pre-installation setup for Data Observability

If you want to use the Data Observability tool in watsonx.data™ integration, you must configure a PostgreSQL database and SMTP for email notifications.

Before you begin

To complete these tasks, you must have:

An external PostgreSQL database, version 16.x or later
Full database permission for the user who provisions the instance.

Creating the database instance

The on-premises Data Observability tool requires additional external storage in the form of an external PostgreSQL instance. On this instance, you must create the Databand database.

To create the Databand database:

Use the master user to connect to the PostgreSQL instance:
```
psql -h <RDS Postgress URL> -U postgres_user -d postgres
```

Create the Databand database and user:

create database databand;

create user databand with encrypted password 'databand';
grant all privileges on database databand to databand;
alter database databand owner to databand;

Use the master user to connect with the Databand database:
```
psql -h <RDS Postgres url> -U postgres_user -d databand
```

Create the uuid-ossp extension:

CREATE EXTENSION "uuid-ossp" SCHEMA pg_catalog

Configuring the PostgreSQL database

After you create the Databand database instance, you must apply the databand-postgres secret to the namespace where you installed watsonx.data integration.

To configure the PostgreSQL database:

Create a secret manifest by choosing one of the following options:

Use the following command to create a secret. Make sure that you encode the values in base64 before you run the command.

apiVersion: v1
kind: Secret
metadata:
  name: databand-postgres
type: Opaque
data:
  connection.postgres.authentication.password: 
  connection.postgres.authentication.username: 
  connection.postgres.hosts.0.hostname: 
  connection.postgres.hosts.0.port:

Use the cli to create a secret:

kubectl create secret generic databand-postgres \
  --type=Opaque \
  --from-literal=connection.postgres.authentication.username=<USERNAME> \
  --from-literal=connection.postgres.authentication.password=<PASSWORD> \
  --from-literal=connection.postgres.hosts.0.hostname=<HOSTNAME> \
  --from-literal=connection.postgres.hosts.0.port=<PORT>

Apply the secret by running the following command in your cluster:
```
kubectl apply -f <SECRET-FILE-NAME.yaml>
```

The watsonx.data integration custom resource automatically references the secret.