3.6 Set Up Oracle Database as Data Store

Set up a data store for MicroTx Distributed Transactions and MicroTx Workflows to store logs.

MicroTx Workflows supports only Oracle Database as data store.

MicroTx Distributed Transactions supports etcd and Oracle Database as data store. Skip this section if you want to set up etcd as data store. See Set Up etcd as Data Store for MicroTx Distributed Transactions.

Topics:

• Prerequisites
  Create separate schemas for MicroTx Distributed Transactions and MicroTx Workflows to persist data in Oracle Database.
• Grant Privileges to Database User
  The MicroTx Distributed Transactions coordinator and MicroTx Workflows create a stored procedure when the service starts. If the Oracle Database user does not have the permission to create and run stored procedures, the service does not start.
• Get Autonomous Database Client Credentials
  MicroTx supports using Oracle Database as a data store to keep track of transaction information.
• Create Tables in Oracle Database
  Create the tables and schema required by MicroTx Distributed Transactions in Oracle Database using a SQL script only if the Oracle Database user does not have the required privileges, such as ALTER and DELETE. MicroTx Distributed Transactions creates tables automatically if the user has ALTER and DELETE privileges.
• Create a Kubernetes Secret for Oracle Database Credentials
  MicroTx Distributed Transactions and MicroTx Workflows support using Oracle Database as a persistent store to keep track of logs, metadata, and other operation details.