Configuring the Data Extract utility environment settings
You must create an environment configuration file that specifies your environment
settings so that the Data Extract utility can extract data objects from your HCL Commerce
database.
Procedure
-
Go to the following directory, which contains the sample configuration files for extracting
data:
- WCDE_installdir\samples\DataExtract
- Create a backup of the wc-dataextract-env.xml environment configuration files in the directory for the object that you want to extract. The sample environment configuration file is configured for a default HCL Commerce Developer environment. If your environment settings are different, you must change the configured values in these files to match your environment.
- Open the environment configuration file (wc-dataextract-env.xml) for editing and configure the settings for your environment.
-
Change the values of the business context attributes inside the
<_config:BusinessContext>
element to match your 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.
-
Change the values of the database configuration attributes inside the
<_config:Database>
element to match your database settings:
Where:<_config:Database type="db2" name="name" user="user" password="password" server="server" port="port" schema="schema" />
- 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, you 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.
-
Encrypt the password of the database user:
- Enter the following command:
- ./wcs_encrypt.sh db_password
- wcs_encrypt.bat db_password
- Use the encrypted password next to ASCII encrypted string as the
value for the
password
attribute inside the<_config:Database>
element.
- Enter the following command:
- Save and close the configuration file.