Data Sources Supported (SSAS Tabular)
This topic describes the types of data sources that can be used with tabular models.
This article contains the following sections:
Supported Data Sources
Unsupported Sources
Tips for Choosing Data Sources
Supported Data Sources
You can import 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.
Source |
Versions |
File type |
Providers 1 |
Access databases |
Microsoft Access 2003, 2007, 2010. |
.accdb or .mdb |
ACE 14 OLE DB provider |
SQL Server relational databases |
Microsoft SQL Server2005, 2008, 2008 R2; SQL Server 2012, Microsoft SQL Azure Database 2 |
(not applicable) |
OLE DB Provider for SQL Server SQL Server Native Client OLE DB Provider SQL Server Native 10.0 Client OLE DB Provider .NET Framework Data Provider for SQL Client |
SQL Server Parallel Data Warehouse (PDW) 3 |
2008 R2 |
(not applicable) |
OLE DB provider for SQL Server PDW |
Oracle relational databases |
Oracle 9i, 10g, 11g. |
(not applicable) |
Oracle OLE DB Provider .NET Framework Data Provider for Oracle Client .NET Framework Data Provider for SQL Server OraOLEDB MSDASQL |
Teradata relational databases |
Teradata V2R6, V12 |
(not applicable) |
TDOLEDB OLE DB provider .Net Data Provider for Teradata |
Informix relational databases |
|
(not applicable) |
Informix OLE DB provider |
IBM DB2 relational databases |
8.1 |
(not applicable) |
DB2OLEDB |
Sybase relational databases |
|
(not applicable) |
Sybase OLE DB provider |
Other relational databases |
(not applicable) |
(not applicable) |
OLE DB provider or ODBC driver |
Text files |
(not applicable) |
.txt, .tab, .csv |
ACE 14 OLE DB provider for Microsoft Access |
Microsoft Excel files |
Excel 97-2003, 2007, 2010 |
.xlsx, xlsm, .xlsb, .xltx, .xltm |
ACE 14 OLE DB provider |
PowerPivot workbook |
Microsoft SQL Server 2008 R2 Analysis Services |
xlsx, xlsm, .xlsb, .xltx, .xltm |
ASOLEDB 10.5 (used only with PowerPivot workbooks that are published to SharePoint farms that have PowerPivot for SharePoint installed) |
Analysis Services cube |
Microsoft SQL Server 2005, 2008, 2008 R2 Analysis Services |
(not applicable) |
ASOLEDB 10 |
Data feeds (used to import data from Reporting Services reports, Atom service documents, Microsoft Azure Marketplace DataMarket, and single data feed) |
Atom 1.0 format Any database or document that is exposed as a Windows Communication Foundation (WCF) Data Service (formerly ADO.NET Data Services). |
.atomsvc for a service document that defines one or more feeds .atom for an Atom web feed document |
Microsoft Data Feed Provider for PowerPivot .NET Framework data feed data provider for PowerPivot |
Office Database Connection files |
|
.odc |
|
1 You can also use the OLE DB Provider for ODBC.
2 For more information about SQL Azure, see the web site SQL Azure.
3 For more information about SQL Server PDW, see the web site SQL Server 2008 R2 Parallel Data Warehouse.
4 In some cases, using the MSDAORA OLE DB provider can result in connection errors, particularly with newer versions of Oracle. If you encounter any errors, we recommend that you use one of the other providers listed for Oracle.
Unsupported Sources
The following data source is not currently supported:
- Server documents such as Access databases already published to SharePoint, cannot be imported.
Tips for Choosing Data Sources
Importing tables from relational databases saves you steps because foreign key relationships are used during import to create relationships between tables in the model designer.
Importing multiple tables, and then deleting the ones you don't need, can also save you steps. If you import tables one at a time, you might still need to create relationships between the tables manually.
Columns that contain similar data in different data sources are the basis of creating relationships within the model designer. When using heterogeneous data sources, choose tables that have columns that can be mapped to tables in other data sources that contain identical or similar data.
OLE DB providers can sometimes offer faster performance for large scale data. When choosing between different providers for the same data source, you should try the OLE DB provider first.