Data Warehouse DTS Tasks
To run the Commerce Server DTS tasks that import data into the Data Warehouse, you must use an account that is a member of the Administrators group, or is aliased to the dbo user in the Data Warehouse. For more information, see Permissions Required to Run DTS Tasks.
To secure the Commerce Server runtime databases and the Administration database so you can run the DTS tasks securely, use the Commerce Server DTS security scripts to create a DTS_ImportRole on each database. For more information, see Scripts for Securing Databases Accessed by DTS Tasks.
After you create the DTS_ImportRole on each database, assign the account for the user who will run the DTS task to the DTS_Import role on each database.
Following are the Commerce Server DTS tasks that import data and extend the Data Warehouse:
- Configuration synchronization
- Web server log import
- Transaction data import
- Product catalog import
- Profile data import
- Campaign data import
- Model Builder
- IP resolution
- Report preparation
- Report cachingData deletion
The following table lists the databases that these DTS tasks access, and the type of access required on each database. When you run the Commerce Server security scripts, the appropriate permissions are assigned to the DTS_ImportRole.
| Object | DTS task | Type of access |
|---|---|---|
| MSCS_Admin database | All DTS tasks | Select Insert Update Delete |
| Commerce Server runtime databases | Transaction data import Product catalog import Profile data import Campaign data import |
Select and create temporary tables in the tempdb database on the SQL Server computer hosting the Commerce Server runtime databases |
| Data Warehouse SQL Server database | All import tasks | Your login account must be a member of the Administrators group, or it must be aliased to the dbo in Data Warehouse |
| Data Warehouse OLAP database | Report preparation task | User needs to be a member of the OLAP administrator group |
| Active Directory | Profile data import | Select |
To run the Data Warehouse Import Wizard and save a package, your account must have Select, Insert, and Update permissions on the msdb database of the SQL Server on which you are running the DTS tasks.
The msdb database is used by SQL Server Agent for scheduling alerts and jobs, and it is accessed to save the DTS package. In addition, assign the same permissions on the sysDTSPackage object, which allows users to save a DTS package.
See Also
Scripts for Securing Databases Accessed by DTS Tasks
Copyright © 2005 Microsoft Corporation.
All rights reserved.