Administrator Guide

10.2.2
- 10.5.3
- 10.5.0
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2

Back Next

Configuring Seamless Access to the History Database

You create a seamless access layer that links that production database to the history database to view archived events in the Operation Console. You create the tables and indexes of the history database in Data Archive, and run an SQL script to create the seamless access layer.

You must have database administrator privileges for the history database to run the seamless access script.

On the

Schedule a Job

page in Data Archive, run the

Create Tables

and

Create Indexes

standalone programs.

For Microsoft SQL Server, delete the DX_VIEW_ARCHIVE_EVENT table from the history database after you run the

Create Tables

program.

In the B2B Data Exchange installation directory, edit the script file for the database on which you store the history database:

Database	Path
Oracle	<DX installation directory>/ILM-accelerator/sql/oracle_seamless_access_script.sql
Microsoft SQL Server	<DX installation directory>/ILM-accelerator/sql/sqlserver_seamless_access_script.sql

In the &linkName variable, enter the same value as the value of the

Database Link To Source

property in the target connection.

In the &databaseName variable, enter the database or schema name for the production database.

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

Configuring Seamless Access to the History Database

Configuring Seamless Access to the History Database