Configure the Data Extract utility environment settings

We must create an environment configuration file that specifies the environment settings so that the Data Extract utility can extract data objects from the WebSphere Commerce database.


Procedure

  1. Go to the following directory, which contains the sample configuration files for extracting data:

  2. Create a backup of the wc-dataextract-env.xml environment configuration files in the directory for the object to extract. The sample environment configuration file is configured for a default WebSphere Commerce Developer environment. If the environment settings are different, change the configured values in these files to match the environment.

  3. Open the environment configuration file (wc-dataextract-env.xml) for editing and configure the settings for the environment.

  4. Change the values of the business context attributes inside the <_config:BusinessContext> element to match the store settings:

      storeIdentifier
      The identifying name of the store that owns the object data, for example, Aurora.

      langId
      The language ID for the language of the data, for example, -1 for English.

  5. Change the values of the database configuration attributes inside the <_config:Database> element to match the database settings: 

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

    Where:

      type
      db2 or oracle

      name
      The name of the database

      user
      The database user ID.

      password
      The database password is necessary to connect to the database. For security purposes, the password is always encrypted. If the password field is empty, we are prompted to enter the password on the command line when you run the 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.

      schema
      The name of the database schema.

  6. (DB2) (Oracle) Encrypt the password of the database user:

    1. Open the command-line interface and go to the following directory:

    2. Enter the following command:

      • (Linux) ./wcs_encrypt.sh db_password

      • (Developer) wcs_encrypt.bat 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.

  7. Save and close the configuration file.


What to do next

  1. Configure the business object configuration file.

  2. Configure the data extract order.

  3. Run the Data Extract utility command.


Next topic: Configure the Data Extract utility business object configuration file


Related concepts
Overview of the Data Extract utility