Connecting to Oracle Database

The SaveToDB add-in enables connections to Oracle Database tables, views, stored procedures, and table functions.

The add-in supports the following data providers:

• Oracle OLE DB Provider
• Oracle ODBC drivers (including DSN files)
• Oracle Data Provider for .NET Framework

The add-in includes the .NET data provider, so you can use it right out of the box.

To download and install the Oracle Database Client components, visit
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html.

Below is a sample of the Database Connection Wizard page where you can select the data provider:

Connecting to Oracle Databases

Use the following format for the server name when connecting to Oracle:

[<Server name or IP-address>[:<Port>]/]<Service name>

Here’s an example of connecting to the service named XE on localhost at port 1521:

Note that Microsoft Excel does not support connections as SYSDBA or SYSOPER. You can log in as SYSTEM instead.

You can also use a service name configured in the tnsnames.ora file on your local machine with OLE DB providers and ODBC drivers.

Here’s an example of connecting to the service named XE: