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