Third Party Data Integration allows for acquiring information from D&B for the TCA Registry. To enable purchase of D&B data, you must integrate with D&B. Without third party data, there is no need to use or administer Third Party Data Integration.

After you set up Third Party Data Integration with D&B, you can optionally administer Source System Management to control how the D&B and user-entered data are used and displayed. See Administering Source System Management.

Procedure

1. Establish a contract with D&B for its Data Rationalization Service. Contact your D&B relationship manager to contract for the services that meet your data requirements.

   If you do not have a relationship manager assigned to your company, contact D&B's Global Service Center at (888) 243-4566, e-mail dnb4oracle@dnb.com, or visit http://www.dnb.com. You can also contact D&B for information to interpret credit ratings and other information that D&B provides.

2. D&B provides information that you need to access the D&B database from Third Party Data Integration:

   • D&B HTTPS URL, which is https://toolkit.dnb.com/access/scripts

   • D&B user name

   • D&B password

   Suggestion: You can request multiple user names and passwords if you want to assign different ones to your users, for example, to track D&B transactions by user.

   Attention: The DNB online purchasing toolkit is not compatible with IBM platform.

3. Enter the provided D&B URL, user names, and passwords in the configuration for the seeded Dun & Bradstreet adapter. See: Configuring Adapters.

4. Set the HZ: D&B User Name profile option with the user names that D&B provided, same as what you enter for the adapter.

5. Contact your information technology department or organization for information about your web server.

   • Servlet agent URL

   • If you use a proxy server:

     • Web server proxy host name

     • Web server proxy port

6. Use the information from your information technology organization to set up the profile options listed in this table.

   Note: Set the Applications Proxy Port and Applications Server-Side Proxy Host And Domain profile options only if you use a proxy server.

   Profile Option	Value
   Apps Servlet Agent	Servlet agent URL
   Applications Server-Side Proxy Host And Domain	Web server proxy host name
   Applications Proxy Port	Web server proxy port

   See: Profile Options and Profile Option Categories.

7. For batch loading D&B data into the Registry:

   • Set up Bulk Import. See: Setting Up Bulk Import.

   • Manually create a directory object on the same environment as your TCA database. A directory object is a database object that stores the absolute path of a physical directory on the database node. Name this object HZ_DNB_SOURCE_DIR, and make sure the database server can read and write from the location identified by the directory object.

     For example, create the directory object in APPS as follows:

     CREATE or replace DIRECTORY HZ_DNB_SOURCE_DIR AS '/emslog/dnb'

     If the object is not in APPS, you must also grant access to APPS:

     GRANT READ ON DIRECTORY HZ_DNB_SOURCE_DIR TO apps;
     GRANT WRITE ON DIRECTORY HZ_DNB_SOURCE_DIR TO apps; 

   • Optionally create a request set with the D&B Import Adapter request set and the Import Batch to TCA Registry program. Users can run the new request set to batch load into interface tables and import into TCA Registry in one step.

     This table shows the recommended settings for automating D&B batch load import after loading into interface tables.

     Import Parameter	Default for D&B Batch Load
     Run Batch De-Duplication	No
     Batch De-Duplication Match Rule	None
     Run Address Validation	No
     Run Registry De-Duplication	Yes
     Registry De-Duplication Match Rule	Custom match rule with heavy weights on Address attributes