Import Profiles Data
You use the Profile Import DTS task to import the profile information that Commerce Server 2009 collects on your Web site. The task updates the Data Warehouse with user profile information from the Profiles data store. It also keeps the schema of a user profile in the Profiles data store and any other exported profile synchronized with the Data Warehouse.
After you run the Profile DTS import task, business managers can run reports on the imported profile data and analyze the profiles to characterize users, organizations, addresses, credit cards, currencies, and other objects to track your business objectives.
Imported Data
You use the Profile Import Properties Dialog Boxto import profile data.
The following tables list the columns extracted from the source tables in the Site_Profiles database, the transformation made, and the tables to which the data is saved in the Data Warehouse.
Most Data Warehouse tables also contain a SiteName column. This column, like TableID and TableInternalFlag, is not listed in the following tables because the SiteName is always extracted from the same location for all DTS tasks.
Source columns from the Addresses table of the Site_Profiles database |
Transformation |
Target columns from the Address table in the Data Warehouse |
|---|---|---|
u_address_id |
Copy Column |
ID -When you try to access UserID of UserObject profile or an Address profile, make sure that you use braces around the unique identifier. Strings that are stored as a global unique identifier (GUID) must begin and end with braces "{" and "}". |
u_address_name |
Copy Column |
AddressName |
i_address_type |
Copy Column |
AddressType |
u_city |
Copy Column |
City |
u_country_code |
Copy Column |
CountryCode |
u_country_name |
Copy Column |
CountryName |
u_first_name |
Copy Column |
FirstName |
u_last_name |
Copy Column |
LastName |
u_postal_code |
Copy Column |
PostalCode |
u_tel_extension |
Copy Column |
TelephoneExtension |
u_tel_number |
Copy Column |
TelephoneNumber |
d_date_created |
Copy Column |
DateCreated |
Source columns from the UserObject table of the Site_Profiles database |
Transformation |
Target columns from the RegisteredUser table in the Data Warehouse |
|---|---|---|
dt_date_registered |
Copy Column |
DateRegistered |
u_email_address |
Copy Column |
|
u_first_name |
Copy Column |
FirstName |
u_last_name |
Copy Column |
LastName |
u_tel_number |
Copy Column |
TelephoneNumber |
u_user_id |
Copy Column |
UserId |
u_user_type |
Copy Column |
UserType |
dt_date_created |
Copy Column |
DateCreated |
dt_date_last_changed |
Copy Column |
DateLastChanged |