Connect to an Oracle database

Before you can connect to an Oracle database, you need the Oracle client software v8.1.7 or greater on your computer. To install the Oracle client software, go to http://go.microsoft.com/fwlink/p/?LinkID=272376 and download (at minimum) Basic Instant Client for Microsoft Windows.

  1. In the POWER QUERY ribbon tab, click From Database > From Oracle Database.
  2. In the Oracle Database dialog box, in Server Name specify the Oracle Server to connect to. If a SID is required, this can be specified in the form of “ServerName/SID”.
  3. If you want to import data using native database query, specify your query in the SQL Statement box. For more information, see Import Data from Database using Native Database Query.
  4. Click OK.
  5. If the Oracle server requires database user credentials:
  1. In the Access a Database dialog box, enter your username and password.
  2. Click Save.

Related Topics

Import data from external data sources

 
 
Applies to:
Excel 2013, Excel 2010