An object of ClassType clsDatasource specifies an external database that will be used as a source of data for an object of ClassType clsDatabase, clsCube, or clsPartition. The object of ClassType clsDatasource object provides collections, methods, and properties though its own internal interface.
Connections to data sources are initiated when Decision Support Objects (DSO) requires access to data or property information in the source database. Data sources are only connected to when needed or when explicitly requested by the program. Executing the IsConnected method of an object of ClassType clsDatasource causes the OLAP server to attempt to connect to the specified data source.
An object of ClassType clsDatabase may contain multiple objects of ClassType clsDatasource in its DataSources collection. Objects of ClassType clsCube and clsPartition can only contain a single object of ClassType clsDatasource in their respective Datasources collection. An aggregation object (ClassType clsAggregation) does not implement the DataSources collection of the MDStore interface.
About Decision Support Objects | Using Decision Support Objects |