Step 6: Add SQL Server Properties to AD-SQL User

You have created a profile definition named AD-SQL User that has two property groups: Active Directory and SQL Server. You have already included the Active Directory properties. Next, you need to add the SQL Server properties.

To add SQL Server User Object properties to the AD-SQL User profile definition

1. Expand Commerce Server Manager, expand Global Resources, expand Profiles, expand Profile Catalog, expand Profile Definitions, and then click AD-SQL User.

2. In the profile definition screen, in the Properties list, click Common Name. The property attributes appear to the right.

3. In the Advanced Attributes section, do the following:

   Use this	To do this
   Key Type	Select Dual (Primary and Join). When using multiple data sources in a profile definition, it is necessary to create a join key that maps to both sources.
   Map to Data	Click the ellipsis [...] button. In the Data Source Picker dialog box, expand ProfileService_ADSource, and then expand AD-SQL User. Select ProfileService_SQLSource, and then select User Object.

4. Hold down the CTRL key, and select both u_logon_name (located under User Object), and cn (located under AD-SQL User), and then click OK to close the Data Source Picker dialog box.

   Both properties appear in the Map to Data box.

5. In the Advanced Attributes section, select the RDN box, and then click Apply.

   Here, the join key properties are designated as the Relative Distinguished Name (RDN) for the profile. The RDN must exist to create a valid profile that is mapped to an LDAPv3 source, such as Active Directory. (This is not required for OLE DB sources, such as SQL Server.)

6. In the Properties list, click the directional arrow to the left of SQL Server, and then click Add.

7. In the Add -- Web Page dialog box, select Add a new property, and then click OK.

8. In the Properties list, select New Property 1.

   Add the properties in the following New Properties table to the AD-SQL User profile definition.

   Name	Display name	Type	Map to data
   u_user_security_password	Password	String	u_user_security_password
   i_account_status	Account Status	Number	i_account_status
   u_user_catalog_set	Catalog Set	String	u_user_catalog_set
   d_data_registered	Date Registered	Date/ Time	d_date_registered
   i_partner_desk_role	Partner Service Role	Number	i_partner_desk_role
   d_date_last_changed	Date Last Changed	Date/ Time	d_date_last_changed

9. In the Attributes section, do the following:

   Use this	To do this
   Name	Type the programmatic name for the property from the Name column in the previous table.
   Display Name	Type the display name for the property from the Display name column in the previous table.
   Type	Select from the drop-down list the property type for the property from the Type column in the previous table.

10. In the Advanced Attributes section, click the Map to Data ellipsis [...] button. Navigate to SQLServerUser Object, and then select the data member for the property from the Map to data column in the previous table.

11. To apply the changes you made to the property, click Apply.

12. Repeat Steps 7 through 12 until you have added all of the properties in the New Properties table. The properties designer screen should look like the following figure.

    

13. To save the profile definition, click on the toolbar.

If you used the AD-SQL User profile definition on your Web site, it would store data in both a SQL Server database and an Active Directory database.

See Also

About the Profiles Resource

Adding a New Data Source

Adding a New Profile Definition

Managing Data Sources

Managing Profile Definitions

All rights reserved.