Share via

Mapping a Profile Property to a Storage Location

  • Article

Profile properties use data members to map data that is entered by users on your Web site to the appropriate storage location. For example, when a user types a first name into the First Name property of the User Object profile definition, the name is stored in the database column that the data member for the First Name property specifies.

Profile properties from a single profile definition can be mapped to data members from different types of data sources. Make sure there is a primary key data member on the data object to be mapped.

To map a profile property to a storage location

  1. Expand Commerce Server Manager, expand Global Resources, expand Profiles, expand Profile Catalog, expand Profile Definitions, and then click the profile definition that contains the property you want to map to a storage location.

  2. In the Profile Designer screen, in the Properties list, expand the property group that contains the property you want to map, and then select the property.

  3. In the profile designer screen, in the Advanced Attributes section, in the Map to Data box, click the ellipsis [...] button to open the Data Source Picker dialog box.

  4. In the Data Source Picker dialog box, expand the data source that contains the data object that contains the data member with which you want to map the property.

  5. Expand the data object that contains the data member with which you want to map the property, select the data member, and then click OK.

  6. In the profile designer screen, in the Advanced Attributes section, select Exported to specify that this property will be exported to the Commerce Server Data Warehouse. You can export only mapped properties.

    Ee797665.note(en-US,CS.20).gifNote

    • You cannot export properties that are multi-valued and of the type Boolean or properties of type binary, long string, or password.

  7. Click Apply.

The profile property data will be stored in the designated data member, and will be imported into the Data Warehouse.

If you want to specify the location into which the data will be imported in the Data Warehouse, you will need to add the DWClassName custom attribute to the profile definition, and the DWMemberName custom attribute to the profile property.

See Also

Creating a Profile Definition with Two Data Sources

Copyright © 2005 Microsoft Corporation.
All rights reserved.