Importing Catalog Data

  • Article

You use the Product catalog import task to import catalog data. Before you import catalog data, you must synchronize your site configuration with the Data Warehouse by executing the Configuration synchronization task. After you import catalog data, you must run the Report preparation task, which organizes the imported data into designated online analytical processing (OLAP) cubes.

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

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

To import catalog 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 Product catalog import (Commerce Server).

  4. In the Catalog 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.
    Incremental load Select this option to import only new catalog data based on a previous import.
    Full load Select this option to import all catalog 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.

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

Ee798322.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


All rights reserved.