Import a Profile schema using Commerce Server Manager

Abstract

  1. From the Windows Start menu, search for "Commerce Server Manager", and then clickCommerce Server Manager.

    CSM_search.png

  2. Expand to the Commerce Server Manager > Global Resources > Profiles(*) > Profile Catalog node. Right-click the Profile Catalog node, and then click on the Import Profile Schema option.

    CSM_ImportProfileSchema.png

  3. Use the file browser dialog to find and select your profile schema xml file.. Once you have selected your file you will be presented with the Profile Schema Import dialog. Click on the SQLSource node, and then click Edit.

    CSM_SQLSource.png

  4. On the Provider tab, select the Microsoft OLE DB Provider for SQL Server node, and then click Next.

    CSM_DataLinkProperties.png

  5. On the Connection tab, use the steps to point to the SQL Server database that you will be using to store your profiles. It is strongly recommended that you use Windows NT Integrated security as the log on option. Once you are finished with your selection, click OK.

    CSM_DataLinkProperties2.png

  6. You will be returned to the Profile Schema Import dialog screen. Select the SQLSource node, and then click Import.

    CSM_SQLImport.png

  7. When the import process is finished, you will receive a dialog that says "Profile schema import succeeded". Then click OK.

    CSM_SQLImportOK.png

  8. If you browse under the Profile Catalog node, you should see all of the profiles that have been imported.

    CSM_ProfileCatalog.png