Export (0) Print
Expand All

Data Sources (Analysis Services)

A data source in Microsoft SQL Server 2005 Analysis Services (SSAS) represents a connection to a data source and contains the connection string that defines how Analysis Services connects to a physical data store using a managed Microsoft .NET Framework or native OLE DB provider. The connection string contains server name, database, security, timeout, and other connection-related information. Analysis Services directly supports many data sources. Supported data sources include Microsoft SQL Server databases and databases created by other products, including Oracle, DB2, and Teradata.

You can define a new data source or define a data source based on a previously defined data source. For information about how to define a data source, see Defining a Data Source Using the Data Source Wizard.

For information on securing data sources, see: Securing the Data Sources Used by Analysis Services.

For information on working with and persisting data source definitions, see Working with Data Sources (Analysis Services) and Developing Analysis Services Solutions and Projects.

Release History

14 April 2006

Changed content:

Removed security and storage information and added links detailed discussion of these topics.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft