Databases

IBM Process Mining requires an external PostgreSQL and optional Db2. By default, IBM Process Mining uses an embedded instance of MonetDB. You can also create an external instance which can be native or containerized. For more information, see Optional: Installing native external MonetDB and Optional: Installing containerized external MonetDB.

You can set up your CRD with the following configurations:

type
Type of the database, allowed values are pgsql or db2.
database
The name of the database.
schema
The name of the schema; required only for Db2. The name is usually the same as the username and it must be written in uppercase.
ssl
If true, an SSL connection is activated. In order to connect to Db2 provided by IBM Cloud SaaS, an SSL connection is required.
user
User account, which has read and write access to the database.
credentials
Secret name and password information contains the following configuration:
  • secretname The name of the Secret.
  • passwordkey The key that contains your password.
host
Hostname of the PostgreSQL server.
port
The port on which the database is listening.

Migration to PostgreSQL

Important: You can only migrate your data to PostgresSQL from IBM Process Mining 2.0.0 to 2.0.1.

Configure the CRD in the following way to migrate from an external MongoDB to an external PostgreSQl:

apiVersion: processmining.ibm.com/v1beta1
kind: ProcessMining
metadata:
  name: <instance name>
  namespace: <namespace>
spec:
  license:
    accept: true
    cloudPak: IBM Cloud Pak for Business Automation
  defaultStorageClassName: rook-cephfs
  processmining:
    storage:
        database:
          external_mongo:
            host: '172.16.1.18'
            port: 27017
            database: processmining
            user: 'ww'
            connectionstring: ''
            credential:
              secretname: 'example'
              passwordkey: password
          external:
            host: '172.16.1.18'
            port: 5432
            database: processmining
            user: 'ww'
            connectionstring: ''
            credential:
              secretname: 'example'
              passwordkey: password

Data encryption

When an external database is adopted for a production environment, it is advised to apply encryption at rest on the stored data.