Install Oracle Database Gateway for ODBC

Last modified: July 25, 2025

The Oracle Database Gateway for ODBC enables Oracle client applications to access non-Oracle data stored in databases that support a compatible Windows ODBC driver. Although the data remains in its native storage, it appears to Oracle applications as if it resides in a single, local Oracle database.

This section explains how to install the Oracle Database Gateway, which can then be integrated with the ODBC Driver for Salesforce to access different kinds of data sources, including Salesforce data.

Tip

Starting with Oracle 11g, Oracle Database Gateway is included in the Oracle software package. You can also download it from the Oracle website.

1. Navigate to the folder containing the gateway installation package and double-click the setup.exe file.

2. In the Oracle Universal Installer: Welcome wizard, click Next.

3. In Oracle Universal Installer: Specify Home Details, enter proper information in the Name field, specify the installation destination Path, and click Next.

4. In Oracle Universal Installer: Product-Specific Prerequisite Checks, click Next.

5. In Oracle Universal Installer: Available Product Components, select the Oracle Database Gateway for ODBC 11.2.0.4.0 checkbox, then click Next.

6. In the Summary wizard, click Install.

As a result, the Oracle Universal Installer: Configuration Assistants wizard appears, followed by the Oracle Net Configuration Assistant: Welcome wizard.

7. Click Next.

8. In Oracle Net Configuration Assistant: Listener Configuration, Listener Name, leave the default LISTENER name, then click Next. (Optional: Enter a different listener name if needed.)

9. In Oracle Net Configuration Assistant: Listener Configuration, Select Protocols, leave the default settings, then click Next. (Optional: Use the arrow icons to select the desired protocol.)

10. In Oracle Net Configuration Assistant: Listener Configuration, TCP/IP Protocol, leave the default setting and click Next.

11. In Oracle Net Configuration Assistant: Listener Configuration, More Listeners?, leave the default setting No, then click Next.

12. In Oracle Net Configuration Assistant: Listener Configuration Done, click Next.

13. In Oracle Net Configuration Assistant: Naming Methods Configuration, configure the necessary settings by selecting the corresponding checkboxes or leaving the default setting No, then click Next.

14. In the Oracle Net Configuration Assistant: Done wizard, click Finish.

15. In Oracle Universal Installer: End of Installation, click Exit. Confirm your action by clicking Yes in the confirmation dialog.

Oracle Database Gateway for ODBC has been successfully installed on your computer.