Why aren't my Profile objects copied to the Data Warehouse?
In Commerce Server 2007, using our profile system to create Users (UserObjects), Addresses and Currency objects that you would like to transfer (via DTS Import) to a site level Data Warehouse, you must remember the following:
On all Guid values in a profile, you must include a bracket before and after the Guid in order for the DTS Import to successfully import the profile object. For instance, here is example of a Guid which would NOT work with our Data Warehouse. This is a Guid from the u_address_id, which is part of the Address schema:
000025df-2143-4e09-b2db-05bc8f873e34
In order for that Address cooresponding to the above Guid to be successfully imported, it must be modified/created like this:
{000025df-2143-4e09-b2db-05bc8f873e34}
It's imperative that your Commerce Server site code take this into account if you plan on integrating your Commerce data into a Data Warehouse!
Hope this helps!
Alan
