D&B Import Adapter (AR)

D&B Import Adapter

Run the D&B Import Adapter request set to load data, from the ASCII flat file that D&B provides for batch loading, into the interface tables used for TCA Bulk Import. The flat file contains D&B information for the parties that you requested.

A flat file is loaded as a batch into the interface tables. At any given time, only one D&B batch can be actively loading into the interface tables, but the interface tables can store multiple D&B batches.

Note: The D&B Import Adapter request set supports only standard D&B bulk files for the Enterprise Management data product.

Prerequisites

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;
```
Note: You only need to create this directory object once, to be used for all D&B Import Adapter requests.
Copy or FTP the flat file from D&B to the location that the directory object identifies.
Sort the flat file based on D-U-N-S Number to make sure that all D-U-N-S Numbers in the flat file are unique. For example, in UNIX:
```
sort -u -t, +0 -1 <file with duplicate DUNS Number> -o <output file name>
```

Program Parameters

The D&B Import Adapter request set includes two programs that you must specify parameters for.

D&B Flat File Upload Table Creation

Object Containing File Location: Enter the name of the database object you created. You can override the HZ_DNB_SOURCE_DIR default if you used another name.
Data File Name: Enter the name of the flat file that D&B provided.
Log File Name: Enter the case-sensitive name of the log file that is to be created for the upload.
Bad File Name: Enter the case-sensitive name of the file that is to be created for the upload to store all bad records.
Discard File Name: Enter the case-sensitive name of the file that is to be created for the upload to store all discarded records.

D&B File Load - Pass 1

Batch Identifier: Enter the batch ID that the Create Import Batch API generated. See Batch IDs.
Explicit NULL character value (G_MISS_CHAR): Enter the character value in the interface tables that, when imported into the TCA tables, would make the corresponding TCA character column null. If an interface table column is null, the corresponding TCA column, empty or not, is not affected by the import.