Relational Replication

Relational Replication allows you to replicate Temenos Transact data in relational databases.

Prerequisites and Assumptions

There are some prerequisites before Relational Replication can be configured, and certain assumptions made in this document.

Overview

With Relational Replication, the configured Temenos Transact application table and data are replicated in the Relational Replication Database in a relational structure.

Architecture

You will need to understand the architecture and process flow for Relational Replication.

Configuring Database

You will need to configure an Oracle or a SQL Server database.

Configuring Runtime

Some steps are necessary to configure runtime for Relational Replication.

Configuring Application Server for Relational Replication

You will need to perform a number of steps to configure the application server for Relational Replication.

XSD Events

You will have to perform a number of actions if you need to process XSD events.

Data events

You will need to capture data events, process these events and generate metadata and DDLs for the replicate tables.

Archiving and Purging Data Events

After processing, data events which have processed successfully are purged. The system can be configured to archive these events.

Overriding STANDARD.SELECTION Values

Tables in Relational Replication are created based on the schema definition in STANDARD.SELECTION from the XSD event. You can override the field lengths, datatypes and field types (single/multi) of tables created in Relational Replication using the RR.OVERRIDE.PARAMETER table.

Configuring Applications in Relational Replication

You will need to configure applications in Relational Replication.

Processing Initial Load

You will need to perform a number of actions to process the initial load.

Dashboard Enquiries

Some enquiries are available with Relational Replication. These are used to display the status of the ETL process in the target environment.

CDP Erasure Process for SDS

You will need to perform a number of actions to use the CDP erasure process for SDS.

Copyright © 2020- Temenos Headquarters SA

Published on :
Wednesday, October 12, 2022 6:38:08 PM IST

Feedback
x