top of page

Autonomous Database Connect to Non-Oracle Databases

Autonomous Database is able to connect Non-Oracle Database (DB2, Teradata, SQL Server etc) via Oracle Database Gateway.


Oracle Database Gateway supports heterogeneous environments and eliminates the need to customize your applications to access data from non-Oracle systems. Autonomous Database supports creating database links only if the target gateway is accessible through a public IP or public hostname, or using an Oracle Database Gateway. Oracle Database Gateway provide queries and applications with access to data anywhere in a distributed database system without knowing either the location of the data or how it is stored.


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.


For more information on Oracle Database Gateway, see Oracle Database Gateways


48 views0 comments

Recent Posts

See All

How to Connect MySQL Without Root Password.

Many times, I got the question from my colleague or training participants, how to login MySQL if I forgot the password. I have explained the process in many times to them but thought to write this sce

Step by Step Oracle 21c Installation on Linux

Oracle Database 21c is the first Oracle database release with CDB-only architecture. Oracle 20c was announced only CDB architecture but it was not release for on premises. Only for Cloud. That's why i

Comentários


bottom of page