Configuring the SQL Server database

You will need to run a number of scripts to configure the SQL server database.

For MSSQL implementation database, schema and user creation are part of the delivered install scripts. Execute the scripts in the sequence given below. Using the prefix (Temenos Transact/RR) in the script file name execute them in the respective database/schema. Read the comment section before executing the script files. You may need to perform a few customizations based on your target table naming convention.

1. 1_T24_TABLE_CREATE_SCRIPT

2. 2_T24_JOB_CREATION_SCRIPTS

3. 3_RR_DB_SCHEMA_USER_CREATION

4. 4.1_RR_CONFIG_TABLE_SCRIPTS

5. 4.2_RR_CONFIG_VIEW_SCRIPTS

6. 4.3_RR_CONFIG_MSSQL_PROCEDURE_SCRIPTS

7. 5_RR_CONFIG_INSERT_SCRIPTS

8. 6_RR_METADATA_TABLE_SCRIPTS

9. 7_RR_METADATA_VIEWS_SCRIPTS

10. 8_RR_DELETE_LOG_MGMT_TABLE_SCRIPTS

11. 9_FBNK_STMT_ENTRY_INDEXING

12. 10.1_T24_DASHBOARD_SCRIPTS

13. 10.2_RR_DASHBOARD_SCRIPTS

1_T24_TABLE_CREATE_SCRIPT

Execute the script against the live (Temenos Transact) database.

This script will drop and recreate the F_DATA_EVENTS table in the Temenos Transact database with the required additional columns, constraints and indexes to improve the performance of the ETL and purge process.

 

2_T24_JOB_CREATION_SCRIPTS

Execute the scripts against the live (Temenos Transact) database.

These scripts will create tables, views and procedures in the Temenos Transact database.

3_RR_DB_SCHEMA_USER_CREATION

These scripts will:

1. Execute scripts against the Relational Replication database.

2. Create the database, schema, login, user and user role types

3. Change the password based on the requirement in the User Creation script.

4.1_RR_CONFIG_TABLE_SCRIPTS

These scripts will:

1. Execute scripts against the Relational Replication database.

2. Create the configuration and staging tables and their indexes and sequences.

4.2_RR_CONFIG_VIEW_SCRIPTS

These scripts will:

1. Execute scripts against the Relational Replication database.

2. Create Relational Replication monitoring views.

4.3_RR_CONFIG_MSSSQL_PACKAGE_SCRIPTS

These scripts will:

1. Execute scripts against the Relational Replication database.

2. Create SQL procedures for the Relational Replication retry process.

5_RR_CONFIG_INSERT_SCRIPTS

These scripts will:

1. Execute scripts against the Relational Replication database.

2. Insert SQL's for the default configuration parameters required for Relational Replication applications (Config, ETL and Purge).

6_RR_METADATA_TABLE_SCRIPTS

These scripts will:

1. Execute scripts against the Relational Replication database.

2. Create tables and indexes to hold the Relational Replication metadata information.

7_RR_METADATA_VIEW_SCRIPTS

These scripts will:

1. Execute scripts against the Relational Replication database.

2. Create metadata views.

8_RR_DELETE_LOG_MGMT_TABLE_SCRIPTS

These scripts will:

1. Execute scripts against the Relational Replication database.

2. Create table RR_DELETE_LOG_MGMT.

9_FBNK_STMT_ENTRY_INDEXING

Execute scripts against the Relational Replication database.

This script is used to improve performance for STMT.ENTRY related enquries. It may not be required if enquiries are not in the Relational Replication product scope.

If used, it has to be enacted immediately after the STMT.ENTRY Table Replication (XSD Schema Replication) and before the Replication of Data Events (Data Event Replication) from Temenos Transact to Relational Replication.

10.1_T24_DASHBOARD_SCRIPTS

These scripts will:

1. Execute scripts against the live Temenos Transact database.

2. Create the view and synonym in the live database for Relational Replication dashboard enquiries.

10.2_RR_DASHBOARD_SCRIPTS

These scripts will:

1. Execute scripts against the Relational Replication database.

2. Create the view, function and synonym in the Relational Replication database for Relational Replication dashboard enquiries.