Specifying Data Sources

Analysis Services

Analysis Services

Specifying Data Sources

For each of your databases, specify one or more data sources that will provide data for your cubes, data mining models, and other objects. When you specify a data source, Analysis Manager retrieves a list of available OLE DB providers. If you want to use a database accessible through an ODBC driver as a data source, select Microsoft® OLE DB Provider for ODBC Drivers as the OLE DB provider, and then select the ODBC data source name (DSN) for the database as defined in ODBC Data Source Administrator from a separate dropdown list. You can easily select a provider and, if necessary, a DSN from these lists.

Note  DSNs defined in ODBC Data Source Administrator must be defined as system DSNs.

If you later edit the data source and change the provider, errors can occur during subsequent processing of objects. For example, in a time dimension, the values for the levels' Member Key Column and Member Name Column properties are frequently SQL expressions. If the syntax of the expressions is supported by the original provider, but not by the new provider, processing the dimension will fail.

To specify a data source, use the Data Link Properties dialog box.

To specify a data source