Transaction Logging

Transaction Logging Database Set-Up

Follow the steps below to create, define, configure, and enable a Transaction Logging database.

1. Create a datebase for Transaction Logging:
   1. Create a database User.
   2. Create a Transaction Database and add the user as owner. warning Set the database encoding to UTF-8.
   3. Add a Schema to the database with the user as owner.
2. Open the Key Vault file to securely store database user credentials:
   1. Add the following lines and enter their respective Username, Password, and URL of the database administrator who is authorized to access the Transaction Logging database.

      transactionDatabaseUser:=<Database User>
      transactionDatabasePassword:=<Database Password>
      transactionDatabaseURL:=<Database URL>

3. Define Transaction Logging database in the Control Center config file:
   1. Open the cc-config.yaml file.
   2. Use the block below as a guide to define and configure the Transaction Logging database.

      transactionDatabase:
          type: POSTGRES
          settings:
              name: <Database Name>
              schema: <Database Schema>
              username: transactionDatabaseUser
              password: transactionDatabasePassword
              driverClassname: org.postgresql.Driver
              url: transactionDatabaseURL
              hibernateDialect: org.hibernate.dialect.PostgreSQLDialect
              hibernateShowSql: false

4. Navigate in the Control Center to Configuration → System Setup → Logging Configurations.
5. Enable the setting Enable transaction logging.

All transactions made are now logged in the Transaction Logging database.