Import Data - Relational Data Source

For tabular models at the 1200 and lower compatiblity levels, you can import data from a variety of relational databases by using the Table Import Wizard. The wizard is available in SQL Server Data Tools (SSDT), on the Model menu. To connect to a data source, you must have the appropriate provider installed on your computer. For more information about supported data sources and providers, see Data Sources Supported (SSAS Tabular).

The Table Import Wizard supports importing data from the following data sources:

Relational Databases

  • Microsoft SQL Server database

  • Microsoft SQL Azure

  • Microsoft Access database

  • Microsoft SQL Server Parallel Data Warehouse

  • Oracle

  • Teradata

  • Sybase

  • Informix

  • IBM DB2


    Multidimensional Sources

  • Microsoft SQL Server Analysis Services cube

    The Table Import Wizard does not support importing data from a Power Pivot Workbook as a data source.

To import data from a database

  1. In SQL Server Data Tools (SSDT), click the Model menu, and then click Import from Data Source.

  2. On the Connect to a Data Source page, select the type of database to connect to, and then click Next.

  3. Follow the steps in the Table Import Wizard. On subsequent pages, you will be able to select specific tables and views or apply filters by using the Select Tables and Views page or by creating a SQL query on Specify a SQL Query page.

See Also

Import Data (SSAS Tabular)
Data Sources Supported (SSAS Tabular)