Sample: Loading general information about inventory expected from vendors

This sample demonstrates how to load general information about inventory expected from vendor.

About this sample

1. CatalogEntryMediator load catalog entry data under ATP store

2. To load inventory data expected from a vendor, ensure that the vendor data has already been loaded to VENDOR table.

3. To modify ATP configuration, load data under

   • (Linux) utilities_root/samples/DataLoad/Inventory/ATPConfiguration

   • (Developer) WCDE_installdir\samples\DataLoad\Inventory\ATPConfiguration

Procedure

1. (Developer) On a command line, go to the WCDE_installdir\bin directory.

2. (Linux) Open a command line in the Utility server Docker container. Change the directory to utilities_root/bin directory.
   For information about entering and leaving containers, see Running utilities from the Utility server Docker container.

3. Enter the following command:

   • (Linux) ./dataload.sh ../samples/DataLoad/Inventory/RA/wc-dataload.xml

   • (Developer) dataload ../samples/DataLoad/Inventory/RA/wc-dataload.xml

Verifying the results

Run the following SQL statement:

select * from RA where RA_ID >= $startKey and RA_ID < $endKey;

The $startKey and $endKey are set in samples\DataLoad\Inventory\RA\wc-dataload.xml. For example, select * from RA where RA_ID >= 100000001 and RA_ID < 200000000;

Cleaning up the data

To clean up the data loaded in the database, run the following SQL statement:

delete from RA where RA_ID >= $startKey and RA_ID < $endKey;