MSBI -- SSAS -- Part-2

What is Data Source:

                                     A Data Source is nothing but a connection information like which server and database are going to use to generate the cube. 
                                    Data Source is used by SSAS to connect to the underlying database to load the data into SSAS during processing. 
                                    A Data Source primarily contains the following information.

·         Provider

·         Server Name

·         Database Name

·         Impersonation Information

 SSAS Supports both .Net and OLE DB Providers. Following are some of the major sources supported by SSAS: SQL Server, MS Access, Oracle, Teradata, IBM DB2, and other relational databases with the appropriate OLE DB provider.

Data Source