Overview of the mass load utilities

The mass load utilities provide an efficient way to load large amount of data. However, the new enhanced business object based loading utility (the Data Load utility) is the recommended loading utility.

To load large amounts of data and to update data in your WebSphere Commerce database with the mass load utilities, follow these basic steps:

  1. Generate a document type definition (DTD) with the dtdgen utility.
  2. Resolve identifiers in the input files with the idresgen utility.
  3. Load the data with the massload utility.

    Feature Pack 6 or laterThe massload utility is deprecated for WebSphere Commerce Version 7 Feature Pack 6. The Data Load utility is the recommended command-line loading utility. If you are currently using the mass load utility, you are recommended to switch to the Data Load utility to load your CSV and XML input files into your target database. If your system contains scheduled and automated processes that use massload, it is recommended that you update these processes to use the Data Load utility. Other WebSphere Commerce utilities that use the massload utility, such as the acpload utility, continue to use the massload utility in WebSphere Commerce Version 7 Feature Pack 6. If you have business reasons to continue using the massload utility, you can continue to use this utility. For more information about the Data Load utility, see Overview of the Data Load utility. You can switch to the Data Load utility by using the TableObjectMediator to load your data when no business object mediator exists for the data that you are loading. For more about the TableObjectMediator formation, see Data Load utility table-based mediator and builder.

  4. Load managed files with the fileloader utility.

The following diagram illustrates the basic loading process:

Loading Process: Before you load data into WebSphere Commerce, you must generate a document type definition (DTD) and resolve identifiers in the input files. To do generate this definition and resolve identifiers, use the dtdgen utility and idresgen utility. Then, load the data into your database.