Managing Data Sources

  • Article

You use the Profiles resource to modify the data sources you created. For example, you make changes in the data store that your profile properties map to, and you need to edit or delete obsolete data objects and data members. Or, you create a new data source and you want to delete the old one. You can change and delete data sources, data objects, and data members.

Consider the following restrictions on modifying your data sources:

  • You can only add partitions to a data source that has never been partitioned. You must add partitions to a source before you use it to store data. If you partition a source that contains data, the existing data will be lost.

  • You cannot delete data source partitions, but you can modify them. You must be careful when you modify the partitions of a data source that contains data because changes can result in data loss or corruption.

  • When you delete a data source, you cannot recover it. All of the data objects and data members associated with the data source are also deleted. You must re-map the profile definitions mapped with the deleted data members to the data storage with existing data members.

  • When you delete a data object, you cannot recover it. All of the data members associated with the deleted data object are also deleted. You must re-map the profile definitions mapped with the deleted data members to the data storage with existing data members.

  • When you delete a data member, you cannot recover it. You must re-map the profile definitions mapped with the deleted data member to the data storage with an existing data member.

To change the properties of a data source

To delete a data source

To change the display name and description of a data object

To delete a data object

To change the display name and description of a data member

To delete a data member

To change the properties of a data source

  1. Expand Commerce Server Manager, expand Global Resources, expand Profiles, expand Profile Catalog, expand Data Sources, right-click the data source you want to change, and then click Properties.

  2. In the <data source> Properties dialog box, on the General tab, do the following:

    Use this To do this
    Display Name Edit the name for the data source. The display name can contain a maximum of 127 Unicode characters.
    Description Edit the description for the data source. The description can contain a maximum of 127 Unicode characters.

  3. To save your changes and return to Commerce Server Manager, click OK.

The data source is saved with your changes. You can change the connection string of an existing partition, or add a new partition that is the same type as the data source (LDAP or OLE DB). To add a new partition or edit an existing partition for an OLE DB-ANSI Provider, see To add a new SQL Server data source. To add a new partition or edit an existing partition for an LDAPv3-Compliant Source, see To add a new LDAPv3-Compliant Source data source.

To delete a data source

  1. Expand Commerce Server Manager, expand Global Resources, expand Profiles, expand Profile Catalog, expand Data Sources, right-click the data source you want to delete, and then click Delete.

  2. In the Delete Data Source confirmation dialog box, click Yes.

The data source, all of its data objects, and all of its data members are deleted.

To change the display name and description of a data object

  1. Expand Commerce Server Manager, expand Global Resources, expand Profiles, expand Profile Catalog, expand Data Sources, expand the data source that contains the data object you want to change, expand Data Objects, right-click the data object you want to change, and then click Properties.

  2. In the <data object> Properties dialog box, on the Identity tab, do the following:

    Use this To do this
    Display Name Edit the name for the data object. The display name can contain a maximum of 127 Unicode characters.
    Description Edit the description for the data object. The description can contain a maximum of 127 Unicode characters.

  3. Click OK.

The display name and description of the data object are changed.

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

  • You can change the display name of a data object; however, you cannot change the programmatic name of a data object.

To delete a data object

  1. Expand Commerce Server Manager, expand Global Resources, expand Profiles, expand Profile Catalog, expand Data Sources, expand the data source that contains the data object you want to delete, expand Data Objects, right-click the data object you want to delete, and then click Delete.

  2. In the Delete Data Object confirmation dialog box, click Yes.

The data object is deleted from the data source.

Ee785174.caution(en-US,CS.10).gif Caution

  • You cannot recover a data object after you delete it.

To change the display name and description of a data member

  1. Expand Commerce Server Manager, expand Global Resources, expand Profiles, expand Profile Catalog, expand Data Sources, expand the data source that contains the data object that contains the data member you want to change, expand Data Objects, and then click the data object that contains the data member you want to change.

  2. In the data member list, right-click the data member you want to change, and then click Properties.

  3. In the <data member> Properties dialog box, on the General tab, do the following:

    Use this To do this
    Display Name Edit the name for the data member. The display name can contain a maximum of 127 Unicode characters.
    Description Edit the description for the data member. The description can contain a maximum of 127 Unicode characters.

  4. Click OK.

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

  • You can change the display name of a data member; however, you cannot change the programmatic name of a data member.

To delete a data member

  1. Expand Commerce Server Manager, expand Global Resources, expand Profiles, expand Profile Catalog, expand Data Sources, expand the data source that contains the data object that contains the data member you want to delete, expand Data Objects, and then click the data object that contains the data member you want to delete.

  2. In the data member list, right-click the data member you want to delete, and then click Delete.

  3. In the Delete Data Member confirmation dialog box, click Yes.

The data member is deleted from the data source.

Ee785174.caution(en-US,CS.10).gif Caution

  • You cannot recover a data member after you delete it.

See Also

About the Profiles Resource

Adding a New Data Source

Adding a New Data Object

Adding a New Data Member

Example: Creating a Profile Definition with Two Data Sources


All rights reserved.