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.

See Also

Concepts

Analysis Services Objects
Data Source Views (Analysis Services)

Other Resources

Analysis Services Concepts
Working with Data Sources (Analysis Services)

Help and Information

Getting SQL Server 2005 Assistance

Change History