Source Definition Meta-data
The Source meta-data describes the data source for the Commerce Server 2000 Data Warehouse. The SourceName and SourceID attributes of the Source meta-data are used in the SourceDefName and SourceID attributes, respectively, of the Class meta-data.
The following table defines the attributes of the SourceDef****meta-data.
| Attribute | Data Type | Constraint | Requirement | Description |
| SourceID | int | NOT NULL | Leave blank | Stores the unique identifier for the source. |
| SourceName | nvarchar (128) | NULL | Required | Stores the name of the data source. |
| ADDomainName | nvarchar (128) | NULL | Optional for PROFILING SYSTEM.
Leave blank for Analysis |
Used by the Profiling System only. |
| CatalogID | int | NULL | Leave blank | Stores the identifier for the Commerce Server 2000 schema catalog. |
| CatalogName | nvarchar (128) | NULL | Leave blank | Stores the name of the schema catalog. For this release of Commerce Server, the catalog name is "DWSchema." |
| ClsComponentID | int | NULL | Optional | Used by the Profiling System. |
| ConnStr | nvarchar (128) | NULL | Required | Stores the connection string for the data source. |
| CreatedTime | datetime | NULL | Leave blank | Records when the source definition was created. |
| DBCodePage | int | NULL | Optional | Used by the Profiling System. |
| Description | nvarchar (128) | NULL | Optional | Stores the description for the source potentially displayed on the UI. |
| DisplayName | nvarchar (128) | NULL | Optional | Stores the name potentially displayed on the UI for the source. |
| DoesDistributedTrans | tinyint | NULL | Optional | Indicates if the data source supports distributed transactions. |
| DoesSQLBatch | tinyint | NULL | Optional | Indicates if the data source supports SQL batch operations. |
| DoesSQLDelete | tinyint | NULL | Optional | Indicates if the data source supports SQL Delete operations. |
| DoesSQLInsert | tinyint | NULL | Optional | Indicates if the data source supports SQL Insert operations. |
| DoesSQLStoredProc | tinyint | NULL | Optional | Indicates if the data source supports storing SQL procedures. |
| DoesSQLUpdate | tinyint | NULL | Optional | Indicates if the data source supports SQL Update operations. |
| DoesTransactions | tinyint | NULL | Optional | Indicates if the data source supports transactions. |
| IsDefault | tinyint | NULL | Indicates if this is the default data source. | |
| MajorVersion | int | NULL | Optional | Stores the major version number. |
| MaxColNameSize | int | NULL | Optional | Stores the maximum size of the names for columns in the data source. |
| MaxTblNameSize | int | NULL | Optional | Stores the maximum size of the names for tables in the data source. |
| MinorVersion | int | NULL | Optional | Stores the minor version number. |
| ModifiedTime | datetime | NULL | Leave blank | Records when the source definition was last modified. |
| SourceGroupName | nvarchar (128) | NULL | Optional for the Profiling System.
Leave blank for Analysis. |
Used by the Profiling System only. |
| Status | int | NULL | Leave blank | Reserved. |
| Type | int | NULL | Optional | Stores a code for the type of data store. See the table immediately following this table. |
The following table contains the valid source types used for the Type attribute of the Source meta-data. This information is more relevant for the Profiling System than for Data Warehouse and Analysis.
| Source Type | Code | Description |
| stOLEDB20 | 1 | Generic OLE DB 2.0 |
| stSQL7x | 2 | SQL Server 7.0 or greater |
| stSQL65 | 3 | SQL Server 6.5 |
| stActiveDirectory | 4 | Active Directory |
| stGeneric | 5 | Generic data source |