Connecting to a Data Source

Analysis Services Programming

Analysis Services Programming

Connecting to a Data Source

The primary way to interact with PivotTableĀ® Service is to connect to a data source using a Connection object or the ActiveConnection property of a Catalog object. Parameters for this connection can be set using a connection string. For example, the properties in the connection string of a Connection object determine whether a connection connects to an Analysis server, creates a new cube, or connects to an existing local cube file. For more information about these data source properties, see Connection String Properties.

After a connection to an OLE DB for OLAP provider or a local cube has been established, queries can be issued against the data source and the results displayed. Information about the schema of the data source can also be retrieved. For more information about data sources in OLE DB, see the OLE DB documentation.