Administer > Transforming, loading, and extracting data > Overview of the data load utility > Run the data load utility


Data Load utility

This utility loads data from a source file into a target database. Loading the file populates and updates the WebSphere Commerce database. You can also use the data load utility to delete data from a database.

You can also run the data load utility in the WebSphere Commerce development environment.


Command syntax


Parameter values

full_path

Is the full path location of the load order configuration file.

-DXmlValidation

(Boolean) Used to turn XML validation on or off. For accuracy, the defined configurations inside the XML files are validated against the data load utility XSDs. By default, XML validation is turned on (true).

To turn off validation, enter -DXmlValidation=false.

-DLoadOrder

Specifies the order that data is loaded to the database. This parameter overrides the LoadOrder element in the wc-dataload.xml configuration file. You can specify any number of load items you want, with each item separated by a comma. Ensure that parameter values do not contain white space. If there is white space, enclose the parameters in double quotation marks. For example,

"-DLoadOrder=loadItemName1, loadItemName2"

-DConsoleHandler.level

Used to override the console logging level defined in the WC_INSTALL\wc.ear\xml\config\dataload\logging.properties file. For example, enter -DConsoleHandler.level=SEVERE to change the console logging level to SEVERE.

-DFileHandler.level

Used to override the file logging level defined in the WC_INSTALL\wc.ear\xml\config\dataload\logging.properties file. For example, enter -DFileHandler.level=WARNING to change the file logging level to WARNING.

-Dpackage_ name.level

Where package_name is the name of any package. This parameter is used to override the logger level for the specified package. If package_name is blank (-D.level=level name) then the logging level is changed for all packages. The level name is defined in the java.util.logging.Level API documentation. The level name can be: OFF, SEVERE, WARNING, INFO, CONFIG, FINE, FINER, FINEST, ALL.

-Dinstance

(Optional) The name of the WCS instance with which you are working on (for example, demo). Specify this parameter when you deploy any custom JAR files or Data Service Layer configuration files from the development environment to the WebSphere Commerce server.

Specify this parameter only when you deploy custom Data Service Layer configuration files from the development environment to the WebSphere Commerce server.


Previous topic: Configure the data load environment settings


Next topic: Verify the results of the data load


Related concepts

Overview of the data load utility


Related tasks

Load data into workspaces using the Data load utility

Run the data load utility in the WebSphere Commerce development environment

Related reference

Troubleshoot: Data load error occurs when the VM argument is misspelled or omitted

Data load best practices

Troubleshoot: Data Load ID not found error

Troubleshoot: Business object changes are not reflected in the Management Center


+

Search Tips   |   Advanced Search