Data Source Objects

Data source objects are described in the OLE DB specification.

Supported Interfaces

Microsoft PivotTable Service Issues

Cube information is cached for each data source, and may not reflect current data for multi-user data sources.

The following table lists the properties used for initialization:

Property Description
DBPROP_INIT_DATASOURCE Name of server machine or local cube file
DBPROP_INIT_CATALOG Name of default (initial) database (catalog)
DBPROP_AUTH_USERID Ignored in this release
DBPROP_AUTH_PASSWORD Ignored in this release
DBPROP_INIT_ASYNCH Used for asynchronous initialization
DBPROP_MSMD_CREATE_CUBE (optional) CREATE CUBE statement to create a local cube file

Otherwise: NULL

DBPROP_MSMD_INSERT_INTO (optional) INSERT INTO statement to populate a local cube file created with CREATE CUBE

Otherwise: NULL

DBPROP_MSMD_SOURCE_DSN ODBC connection string, OLEDB connection string, or DSN for source relational database, used only when creating a local cube file
DBPROP_MSMD_SOURCE_UID ODBC UID for source relational database, used only when creating a local cube file
DBPROP_MSMD_SOURCE_PWD ODBC PWD for source relational database, used only when creating a local cube file
DBPROP_INIT_PROVIDERSTRING A predefined string containing other initialization properties.
MSMD_USEEXISTINGFILE If the first character of this string is Y, T, or a numeric digit other than 0, CREATE CUBE and INSERT INTO properties will be ignored.
MSMD_ARTIFICIALDATA If the first character of this string is Y, T, or a numeric digit other than 0, artificial aggregate values will be calculated using a simple algorithm instead of calculating real values.

Limitations

IDBInfo is not fully tested.

IPersistFile is not fully supported

Asysnchronous initialization supports polling only through IDBAsynchStatus. The IDBAsynchNotify connection point is not supported.