top of page
Search

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


28 views0 comments

Recent Posts

See All

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

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

bottom of page