Creating a Data Source

The first task in creating an Analysis Services project is to create a data source. The data source contains the information that Analysis Services uses to connect to the source database. It contains the data provider name, the server and database name, and the authentication credentials that Analysis Services will use.

The source data must be contained in a relational database. Analysis Services can read data contained in SQL Server 2008, Microsoft Access, Teradata, Oracle, IBM DB2, and other relational databases for which you have an OLE DB or ODBC driver, but it cannot read data from a Microsoft Office Excel file, a text file, or other nonrelational data sources. Analysis Services connects to a relational database using ...

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.