Connecting to Oracle Database

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

The SaveToDB 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 ships the .NET data provider. So, you can use it from the box.

You can download and install Oracle Database Client components at
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html.

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

Connecting to Oracle Databases

Use the following server name format for Oracle:

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

Here is a sample of the connection to the service named XE on localhost port 1521:

Microsoft Excel does not support connections as SYSDBA or SYSOPER. You can use logon as SYSTEM.

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

Here is a sample of the connection to the service named XE: