Running the D&B Update Manager (Siebel) Process Without Updating Account Name

You might want to run the D&B Update Manager (Siebel) server component without updating the existing account names. You edit the RTI configuration file to perform this task.

To edit the RTI configuration file so that account names are not updated

  1. Open the RTI configuration file (dnbmaps.sql for single task or dnbmaps.tsq for multiple task) in a text editor.

  2. Search for UPDATE_SIEBEL_ACCOUNT.MOD1SQL under the Oracle, Oracle 8, Microsoft SQL Server, or DB2 statements.

  3. Search for dnb.BUSINESS_NAME within the UPDATE_SIEBEL_ACCOUNT.MOD1SQL SELECT statement.

  4. Comment out the line that begins dnb.BUSINESS_NAME… as shown.

    UPDATE_SIEBEL_ACCOUNT.MOD1SQL = 
    SELECT acct.ROW_ID   ROW_ID,
    ;dnb.BUSINESS_NAME   NAME,
    
  5. Save and close the file.