Update Server Process Configuration

The D&B update server processes use the Batch Real-Time Integration (RTI) technology and the RTI configuration files (dnbmaps.sql for single task and dnbmaps.tsq for multiple tasks). You can edit the RTI configuration files to suit your business requirements.

The general syntax of the RTI maps specified in the configuration files is as follows:

UPDATE_SOME_TABLE.MOD1TABLE = [Target Table to update]
UPDATE_SOME_TABLE.MOD1WHERE = [A WHERE clause]
UPDATE_SOME_TABLE.MOD1INSERT = [TRUE/FALSE]
UPDATE_SOME_TABLE.MOD1UPDATE = [TRUE/FALSE]
UPDATE_SOME_TABLE.MOD1DELETE = [TRUE/FALSE]
UPDATE_SOME_TABLE.MOD1SQL = [A Valid SQL Query]

The RTI configuration files are located in the …\siebelserver\SQLTEMPL directory. For the default mapping for the D&B Update Manager (Siebel) server component, see Field Mapping for the D&B Update Manager Process.

Use caution when making changes to these RTI configuration files. It is recommended that you engage a qualified professional for your customization process.

Caution: Do not change the default DELETE setting in the existing UPDATE* sections. Do not set DELETE to TRUE. If your business need necessitates deleting rows in the target table as part of the D&B Update Manager process, then you can request help by creating a service request (SR) on My Oracle Support.