Stores back-end information that is displayed in the SCRM Administrator console, such as job history and data source information.
data retention group
A list of related tables in the SCRM data warehouse, for which data is retained for the same period of time.
data retention period
The period of time that data is kept.
A particular computer with a SQL Server instance and database, which contains data compatible with SCRM 2006. For SCRM 2006, valid data sources are instances of MOM 2005 and SMS 2003 SP2.
data transformation service
Extracts, transforms, and manages data movement between multiple data sources.
A SQL Server 2005 database specifically structured for query and analysis. The SCRM 2006 data warehouse typically contains MOM, SMS, and potentially custom data, such as Active Directory information.
Moves data from the data sources to the SCRM 2006 data warehouse. Reports generated from the data warehouse do not contain data from data sources until DTS jobs have successfully moved the data, updating the reports into the data warehouse.
Removal of data from the data warehouse after a specified period of time.
Stores SMS, MOM, and business context data. This database is the reporting layer database where the transformed data from SMS is loaded.
Multiple reports bundled together in XML files. You cannot add or remove reports from the report collections shipped with MOM 2005 or SCRM 2006.
SCRM Administrator console
Provides the interactive interface you use to configure the operation of the SCRM data warehouse. The primary activities accomplished with the SCRM Administrator console include the following: adding data sources to the data warehouse, modifying existing data transformation service (DTS) jobs and creating new DTS jobs, configuring global settings such as setting grooming policy for MOM and SMS data, and importing report collections to the SQL Reporting Services server.
Data store where data from SMS is imported and cleansed, purged of duplicate information, and transformed before it is loaded into the presentation database.
Used during the data transformation process when a SCRM data source is established. This database is located on the fastest drive of the SCRM 2006 server.