Siebel Applications Administration Guide > D&B Integration > Integrating D&B Data >

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. Table 73 shows these staging tables. For definitions of these tables, see the applicable Siebel Data Model Reference on My Oracle Support.

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, you must delete the previously used staging tables.

Table 74 lists the D&B data to delete and to load.

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.