ETL Process for the Configuration Synchronization DTS Task
The Configuration synchronization DTS task synchronizes information between the Administration database and the Data Warehouse. Specifically, the task synchronizes updates made to the site topology, query strings, crawlers, and report definitions. The Configuration synchronization DTS task should be run before any of the other import or delete tasks are run.
The following tables list the columns extracted from the source tables in the Administration database, the transformation performed, and the tables that the data is saved to in the Data Warehouse.
Synchronizing the Site Topology
Source property name from the ResourceProps table of the Administration database | Transformation | Target columns in the Site table of the Data Warehouse |
---|---|---|
|
Generated
Value of s_Value plus 1 is loaded. |
|
|
Generated
Set to zero (0). |
|
|
Copy Column |
|
|
Generated
Value of s_Value plus 1 is loaded. |
|
|
Copy Cell |
|
|
Copy Cell |
|
|
Copy Cell |
|
|
Copy Cell |
|
|
Generated
Value of s_Value plus 1 is loaded. |
|
|
Copy Cell |
|
|
Copy Cell |
|
|
Copy Cell |
|
|
Copy Cell |
|
|
Copy Cell |
|
|
Copy Cell |
|
|
Copy Cell
Default value is zero (0). |
|
Source PropertyName from the ResourceProps table of the Administration database | Transformation | Target columns from the ServerGroup table in the Data Warehouse |
---|---|---|
|
Copy Cell |
|
|
Copy Cell |
|
|
Copy Cell |
|
|
Concatenation
"LDS For" s_WebServerMachine/ s_WebServerName. Used only if varList is empty. |
|
|
Generated
Value of 25 (GMT) is loaded. |
|
|
Copy Cell |
|
|
Copy Cell |
|
Source PropertyName from the ResourceProps table of the Administration database | Transformation | Target columns from the VirtualServer table in the Data Warehouse |
---|---|---|
|
Copy Cell |
|
|
Copy Cell
If cell is empty load “Unknown” |
|
|
Generated
s_WebServerName on s_WebServerMachine |
|
|
Generated
Value of 1 is loaded. |
|
Source PropertyName from the ResourceProps table of the Administration database | Transformation | Target columns from the ServerBinding table in the Data Warehouse |
---|---|---|
|
Middle of String |
|
|
Middle of String |
|
|
Generated
If the binding is secure, 443 is loaded. If it is insecure, 80 is loaded. |
|
Source PropertyName from the ResourceProps table of the Administration database | Transformation | Target columns from the SiteURL table in the Data Warehouse |
---|---|---|
|
Concatenation
Asterisk (*) separated list of expressions and types. |
|
|
Copy Cell |
|
|
Copy Cell |
|
|
Concatenation
http://" & s_NonSecureHostname & "/" & s_VirtualRootName |
|
|
Concatenation
http://" & s_NonSecureHostname & "/" & s_VirtualRootName |
|
Query String Updates
Source Property Name from the ResourceProps table of the Administration database | Transformation | Target columns from the URIQuery table in the Data Warehouse |
---|---|---|
|
Copy Cell |
|
|
Generated |
|
Source Property Name from the ResourceProps Table of the Administration Database | Transformation | Target Columns from the SVQStringName Table in the Data Warehouse |
---|---|---|
|
Copy Cell |
|
Source Property Name from the ResourceProps table of the Administration database | Transformation | Target columns from the LinkSVQStringName table in the Data Warehouse |
---|---|---|
|
Copy Cell
Load a LinkSVQStringName for every SiteURLID listed in s_OSApplicationList. |
|
Source Property Name from the ResourceProps table of the Administration database | Transformation | Target columns from the MVQStringName table in the Data Warehouse |
---|---|---|
|
Copy Cell |
|
Crawler Updates
Source Property Name from the ResourceProps table of the Administration database | Transformation | Target columns from the Crawler table in the Data Warehouse |
---|---|---|
|
Read File |
|
|
Copy Cell |
|
See Also
Running the Configuration Synchronization DTS Task
Scripting the Configuration Synchronization DTS Task
Workflow for Running DTS Tasks
Copyright © 2005 Microsoft Corporation.
All rights reserved.