Introduced in Feature Pack 3

Tutorial: Customizing the Data Load utility to encrypt data

Introduced in Feature Pack 3 This tutorial demonstrates how to customize the Data Load utility to load user and password information into the WebSphere Commerce database separately.
For security reasons, the Data Load utility does not load user password information from CSV files into the WebSphere Commerce database by default. After user information is loaded into the database from a CSV file, the value for the user passwords is set to NULL.

After user data is loaded to the WebSphere Commerce database, each user password is automatically reset the first time that a user attempts to logon to the store. The password is reset regardless of the password that was entered at logon time, since the password in the database is null.

This automatic reset of the null password at logon time can be disabled by setting the following flag in the instance configuration file to false:
  • MemberSubSystem/ResetPassword/resetNullPasswordEnabled
This flag is enabled by default when the Foundation feature of WebSphere Commerce 7 Feature Pack 3 is enabled. An email is sent to the user with a temporary password that they can use to log on to the store and then change the password.

This tutorial shows you how to handle user password information by customizing the Data Load utility to load user passwords separately from the users.

Learning objectives

After completing this tutorial, you should be able to:
  • Configure the Data Load utility.
  • Extend the generic table loader.
  • Encrypt data by using Java classes.

Time required

Expect this tutorial to take 1 hour to complete.

Skill level



This tutorial is intended for WebSphere Commerce developers who want to extend the generic table loader to load customized data.

System requirements

Before you begin this tutorial, ensure that the following tasks are complete:
  • Member data is loaded into the database.
  • Password input (plain message text) is obtained from the external system by using data readers.
  • Passwords are stored in a CSV file.


To complete this tutorial, ensure that you have a basic understanding of the following concepts: