A Data Source contains the connection information 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 (apart from various other properties like Query timeout, Isolation etc.):

• 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.

A Data Source contains the connection information 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 (apart from various other properties like Query timeout, Isolation etc.):

• 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.