Importing User Profile Data

  • Article

You use the User profile data import task to import user profile data. User profile data is user data collected on your Web site with the User****Object profile definition. For information about creating profile definitions, see Running the Profiles Resource.

Before you import user data, you must synchronize your site configuration with the Data Warehouse by executing the Configuration synchronization task. After you import user data, you must run the Report preparation task, which organizes the imported data into designated online analytical processing (OLAP) cubes. For information about specifying user data for import into the Data Warehouse, see Adding Properties to Profile Definitions.

Ee810646.note(en-US,CS.10).gif Note

  • You must use the full load option and perform a full import the first time you import user profile data into the Data Warehouse. After you have imported user profile data, use the incremental load option to import only new data, created since you last imported user profile data.

To import user data into your Data Warehouse

  1. Expand Microsoft SQL Server, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.

  2. Right-click Data Transformation Services, and then click New Package.

    Alternatively, if you are changing an existing package, right-click Data Transformation Services, click All Tasks, and then select Open Package. Select the package you want to change, and then click Open.

  3. On the Task menu, click User profile data import (Commerce Server).

  4. In the User Import Properties dialog box, do the following:

    Use this To do this
    Description Type a description for this import task.
    Site name Select from the drop-down list the site that contains the data you want to import.
    Query interval (mins.) Type the time interval for the import. User data is imported in time intervals to prevent locking the database table. For example, a Web site with 10,000 users would import user data in 15-minute intervals.

    Setting a smaller value will lock the table for a shorter duration but will increase the number of queries against the table and therefore the time the task takes to run. Setting the value to zero will execute a single query, locking the table for the entire duration of import but may degrade site performance.
    Import start date Select a date from the drop-down calendar on which to begin your import.
    Incremental load Select this option to import only new users (based on a previous import).
    Full load Select this option to import all user data.

  5. Click OK.

  6. On the Package menu, click Execute.

    The Executing Package dialog box appears, showing the progress of your import. When the import process is complete, the Package Execution Results dialog box informs you it completed successfully.

  7. Click OK, and then click Done.

User profile data is imported into the Data Warehouse. You must run the Report preparation task to organize the imported data into the designated OLAP cubes.

Ee810646.note(en-US,CS.10).gif Note

  • You can add multiple Data Transformation Services (DTS) tasks to a package, add sequencing or workflow information, and then run all the tasks in the package.

See Also

Data Warehouse Components

Importing Data into the Data Warehouse

Synchronizing Site Configuration with the Data Warehouse

Preparing to Create Reports

Adding Properties to Profile Definitions


All rights reserved.