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
- CatalogEntryMediator load catalog entry data under ATP store
- To load inventory data expected from a vendor, ensure that the vendor data has already been loaded to VENDOR table.
- If you want to modify ATP configuration, load data under
- utilities_root/samples/DataLoad/Inventory/ATPConfiguration
- WCDE_installdir\samples\DataLoad\Inventory\ATPConfiguration
Procedure
- On a command line, go to the WCDE_installdir\bin directory.
- Open a command line in the . Change the directory to utilities_root/bin directory. For information about entering and leaving containers, see Running utilities from the Utility server Docker container.
- Enter the following command:
- ./dataload.sh ../samples/DataLoad/Inventory/RA/wc-dataload.xml
- 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;