Aracılığıyla paylaş


Supported Data Source Types (SSAS Multidimensional)

This topic describes the types of data sources that you can use in a multidimensional model.

Supported Data Sources

You can retrieve data from the data sources in the following table. When you install SQL Server Veri Akışı Araçları (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.

[!NOT]

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.

Source

Versions

File type

Providers 1

Access databases

Microsoft Access 2003, 2007, 2010.

.accdb or .mdb

Microsoft Jet 4.0 OLE DB provider

SQL Server relational databases 5

Microsoft SQL Server 2005, 2008, 2008 R2, 2012, Windows Azure SQL Veritabanı 2

(not applicable)

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

SQL Server Parallel Data Warehouse (PDW) 3

2008 R2; 2012

(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

MSDAORA OLE DB provider 4

OraOLEDB

MSDASQL

Teradata relational databases

Teradata V2R6, V12

(not applicable)

TDOLEDB OLE DB provider

.Net Data Provider for Teradata

Informix relational databases

V11.10

(not applicable)

Informix OLE DB provider

IBM DB2 relational databases

8.1

(not applicable)

DB2OLEDB

Sybase relational databases

V15.0.2

(not applicable)

Sybase OLE DB provider

Other relational databases

(not applicable)

(not applicable)

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 Veri Akışı Araçları 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 Veritabanı, see WindowsAzure.com.

3 For more information about SQL Veritabanı PDW, see SQL Server 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.

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

Ayrıca bkz.

Kavramlar

Data Sources Supported (SSAS Tabular)

Data Sources in Multidimensional Models

Data Source Views in Multidimensional Models