Supported Data Sources (SSAS Multidimensional)
Applies To: SQL Server 2016 Preview
This topic describes the types of data sources that you can use in a multidimensional model.
You can retrieve data from the data sources in the following table. When you install SQL Server Data Tools (SSDT), setup does not install the providers that are listed for each data source. Some providers might already be installed with other applications on your computer; in other cases you will need to download and install the provider.
Third party providers, such as the Oracle OLE DB Provider, may also be used to connect to third party databases, with support provided by those third parties.
Microsoft Access 2010, 2013, 2016
.accdb or .mdb
Microsoft Jet 4.0 OLE DB provider
SQL Server relational databases 4
Microsoft SQL Server 2008, 2008 R2, 2012, 2014, 2016, Azure SQL Database 2, Microsoft Analytics Platform System (APS)3
OLE DB Provider for SQL Server
SQL Server Native Client OLE DB Provider
SQL Server Native 11.0 Client OLE DB Provider
.NET Framework Data Provider for SQL Client
Oracle relational databases
Oracle 9i, 10g, 11g, 12g
Oracle OLE DB Provider
.NET Framework Data Provider for Oracle Client
.NET Framework Data Provider for SQL Server
Teradata relational databases
Teradata V2R6, V12
TDOLEDB OLE DB provider
.Net Data Provider for Teradata
Informix relational databases
Informix OLE DB provider
IBM DB2 relational databases
Sybase Adaptive Server Enterprise (ASE) relational databases
Sybase OLE DB provider
Other relational databases
OLE DB provider or ODBC driver
1 ODBC data sources are not supported for multidimensional solutions. Although Analysis Services itself will handle the connection, the designers in SQL Server Data Tools used for building data source views, dimensions, and cubes cannot connect to an ODBC data source, even when using MSDASQL driver (.NET driver for ODBC). If your business requirements include an ODBC data source, consider building a tabular solution instead.
2 For more information about SQL Database on Azure.com.
3 Analytics Platform System (APS) was formerly known as SQL Server Parallel Datawarehouse (PDW). Originally, connecting to PDW from Analysis Services required a special data provider. This provider was replaced in SQL Server 2012. Starting in SQL Server 2012, the SQL Server native client is used for connections to PDW/APS. For more information about APS, see the web site Microsoft Analytics Platform System.
4 Some features require a SQL Server relational database that runs on-premises. Specifically, writeback and ROLAP storage require that the underlying data source is a SQL Server relational database.