The database administrator creates the seamless access layer by executing the relevant script located in

<DX installation directory>/ILM-accelerator/sql

:

For Oracle:
oracle_seamless_access_script.sql
For SQL Server:
sqlserver_seamless_access_script.sql

Replace the following system variables in the script:

Replace
&linkName
with the database link.
Replace
&databaseName
with the schema name of the production database.

The program

Create Seamless Data Access

performs a similar function as the scripts. However, the scripts generate a proper view for in-lining certain entity names, such as partner name, with the event table, when data is archived to the file archive. This in-lining allows you to find events based on partner or account name.