Samples > Data load utility samples


Sample: Setting up the data load utility

Before running the data load utility for the first time, configure the store and database environment settings.


About this sample

This sample sets the following default values in the environment configuration file:

Change any of these values (except inventory type) as needed to match the values of the existing environment and store.


Next topic: Sample: Loading initial data


Define the environment settings


Procedure

  1. Open the wc-dataload-env.xml configuration file in the appropriate directory:

    • WC_INSTALL/samples/DataLoad/Catalog

    • WCDE_INSTALL\samples\DataLoad\Catalog

  2. Optional: Change the values of the attributes inside the <_config:BusinessContext > element to match the store settings.

    <_config:BusinessContext storeIdentifier="Madisons" catalogIdentifier="Madisons" languageId="-1" currency="USD">
    </_config:BusinessContext>
    

  3. Encrypt the password of the database user:

    1. Open the command-line interface and navigate to the appropriate directory:

    2. Enter the following command:

      • ./wcs_encrypt.sh db_password

      • wcs_encrypt db_password

      Where db_password is the password for the database user.

    3. Use the encrypted password next to ASCII encrypted string as the value for the password attribute inside the <_config:Database> element.

    For security, the password should always be encrypted when specified inside of the configuration file.

  4. Optional: Change the attribute values inside the <_config:Database> element to match the database environment.

    • <_config:Database type="derby" name="..\..\db\mall" />

    • <_config:Database type="db2" name="database name" user="user" password="encrypted password" server="server" port="50000" schema="schema name" />

    • <_config:Database type="Oracle" name="database name" user="user" password="encrypted password" port="1521" schema="schema name" server="server" driverType="thin" />

    Where:

    type

    • derby

    • db2

    • oracle

    name

    The name of the database

    user

    The database user ID.

    password

    The database password needed to connect to the database. For security purposes, the password is always encrypted. If the password field is empty, we will be prompted to enter the password on the command line when you run the data load utility.

    server

    The name of the server the database is on. The server name can be the IP address or the fully qualified DNS name of the server the database is on.

    port

    The port to connect to the database.

    driverType

    The database driver type. It is optional. The default value for the driverType is thin. Another possible option for the driverType is oci8 which is the oracle thick driver.

    schema

    The name of the database schema.

  5. Save and close the configuration file.

  6. Optional: To set the inventory system to non-ATP, run the following SQL statement:

    UPDATE STORE SET INVENTORYSYSTEM=-2 WHERE STORE_ID in (SELECT STOREENT.STOREENT_ID FROM STOREENT WHERE STOREENT.IDENTIFIER ='storeIdentifier')
    

    Where storeIdentifier is the external identifier for the store, for example Madisons.

    By default, the Madisons store uses ATP inventory type. If an ATP store is desired, omit this step.

Related reference

Data load utility samples


Related information

Data load environment configuration file


+

Search Tips   |   Advanced Search