1. Using Oracle Autonomous Database Serverless
  2. Tasks
  3. Link Data
  4. Use Database Links
  5. Create Database Links to Non-Oracle Databases
  6. Create Database Links to Non-Oracle Databases with Customer-Managed Heterogeneous Connectivity
  7. Prerequisites to Create Database Links to Non-Oracle Databases with Customer-Managed Heterogeneous Connectivity

Prerequisites to Create Database Links to Non-Oracle Databases with Customer-Managed Heterogeneous Connectivity

Use DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK to create database links from an Autonomous Database to an Oracle Database Gateway to access Non-Oracle databases.

An Oracle Database Gateway is a gateway that is designed for accessing a specific non-Oracle system. Using an Oracle Database Gateway, you can access data anywhere in a distributed database system without knowing either the location of the data or how it is stored. Using database links on Autonomous Database with Oracle Database Gateway supports heterogeneous environments and eliminates the need to customize your applications to access data from non-Oracle systems.

Note:

Before you create database links to a target gateway, do the following:

  1. Configure the Oracle Database Gateway to access a non-Oracle database.

  2. Configure Oracle Net Listener to handle incoming requests on the Oracle Database Gateway.

  3. Create a self signed wallet on the Oracle Database Gateway.

For more information on Oracle Database Gateway, see Oracle Database Gateways in Oracle Database Heterogeneous Connectivity User's Guide. Also see the Installation and Configuration Guide and the Gateway User's Guide for the database you want to connect to. For example, for Oracle Database Gateway for SQL Server see:

Parent topic: Create Database Links to Non-Oracle Databases with Customer-Managed Heterogeneous Connectivity