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.