Loading D&B Data

After you have obtained the three D&B data files, you can start to load the data into the Siebel database. You can load the files in any order, but you must load all three files before running the Siebel update server component.

Data loading scripts and processes differ according to your database. When creating your data loading scripts, see the documentation provided by D&B and the applicable Siebel Data Model Reference on My Oracle Support.

Note: When you integrate D&B data for the first time, you might want to obtain sample loading scripts for use as templates. For help obtaining sample loading scripts, create a service request (SR) on My Oracle Support. For more information, see Loading D&B Data Using Sample Scripts.

The scripts load D&B data into staging tables in the Siebel database. The following table shows these staging tables. For definitions of these tables, see the applicable Siebel Data Model Reference on My Oracle Support.

File	Upload Location
Marketing Data file	S_DNB_UPDATE table This table is used as a staging area for the un-normalized D&B Marketing data.
SIC file	S_DNB_SIC table
MRC file	S_DNB_MRC table

Because SIC and MRC files change rarely, updating D&B data usually requires deleting and reloading the D&B marketing data in the S_DNB_UPDATE table alone.

If you must load new versions of the SIC and MRC files, then you must delete the previously used staging tables.

The following table lists the D&B data to delete and to load.

If You Are...	Then...
Loading D&B data for the first time	Load the following D&B data files: Marketing Data file, SIC file, and MRC file.
Updating D&B data with a new Marketing Data file, but the SIC and MRC files have not changed	Delete data from the S_DNB_UPDATE table. Load the Marketing file.
Updating D&B data with new Marketing Data, SIC, and MRC files	Delete data from the S_DNB_UPDATE, the S_DNB_SIC, and the S_DNB_MRC tables. Load the following D&B data files: Marketing Data file, SIC file, and MRC file.

After loading files, you must run the D&B Update Manager (D&B) and the D&B Update Manager (Siebel). For more information, see About Siebel Update Server Components.