Transaction Import Properties Dialog Box
Use the Transaction Import Properties dialog box to specify the sites whose log file transaction data you want to import into the Data Warehouse by using the Transaction Data Import DTS task. Commerce Server generates transaction data on your Web site when a user adds and removes items from a shopping cart, or makes a purchase. After you import this data, you can run reports to analyze the data.
Use this |
To do this |
|---|---|
Description |
Type a description for the DTS task. The maximum number of characters for the description is 255 characters. |
Operation level |
From the drop-down list, select an operation level:
|
Site name |
From the drop-down list, select the site that contains the data that you want to import. |
Data Warehouse name |
From the drop-down list, select the Data Warehouse associated with the sites that contain the data that you want to import. |
Incremental load |
Select to only import new transaction data generated since the last time that you ran the import process. |
Full load |
Select to import all transaction data in the log file. |
Query interval |
Type the time interval for the import. Commerce Server imports user data in time intervals to prevent locking the database table. For example, a Web site that has 10,000 users would import user data in 15-minute intervals. Setting a smaller value will lock the table for a shorter duration but will increase the number of queries against the table and therefore the time the task takes to run. Setting the value to zero will run a single query, locking the table for the whole duration of import but may decrease site performance. |
Number of retries |
Type the number of times you want the task to retry connection failures to the Data Warehouse. The default number of retry attempts is 10 times. |
Seconds between retries |
Type the number of seconds you want the task to wait between retry attempts. The default time interval is 30 seconds. |
See Also
Other Resources
ETL Process for the Transaction Data Import DTS Task
How to Run the Transaction Data Import DTS Task
How to Specify the Location of a Log File to the Data Warehouse