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

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

An Oracle AI Database Gateway is a gateway that is designed for accessing a specific non-Oracle system. Using an Oracle AI 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 AI Database with Oracle AI Database Gateway supports heterogeneous environments and eliminates the need to customize your applications to access data from non-Oracle systems.

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

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

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

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

For more information on Oracle AI Database Gateway, see Oracle AI Database Gateways in Oracle AI 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 AI Database Gateway for SQL Server see: