Bookshelf Home | Contents | Index | PDF |
Siebel Applications Administration Guide > D&B Integration > Process of Integrating D&B Data > Loading D&B DataAfter 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. When creating your data loading scripts, refer to the documentation provided by D&B and to Siebel Data Model Reference. The scripts and processes differ according to your database platform. 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 OracleMetaLink 3. See Loading D&B Data Using Sample Scripts. The scripts load D&B data into staging tables in the Siebel database, as shown in Table 74.
NOTE: Definitions of these tables can be found in Siebel Data Model Reference. Because SIC and MRC files change only rarely, updating D&B data usually requires deleting and reloading the D&B marketing data in the S_DNB_UPDATE table alone. If you need to load new versions of the SIC and MRC files, you must delete the previously used staging tables. Table 75 lists what D&B data to delete and what to load.
After loading files, you must run the D&B Update Manager (D&B) and the D&B Update Manager (Siebel) as described in About Siebel Update Server Components. |
Siebel Applications Administration Guide | Copyright © 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |