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
dataload.sh /path/to/sourcefile
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
Troubleshoot: Data Load ID not found error
Troubleshoot: Business object changes are not reflected in the Management Center