This blog is one example on how to connect OAC to an Oracle Cloud database with a private endpoint using OAC's private access channel. The basic steps are:
- Use Console to configure a private access channel within your OAC instance.
- From your OAC instance create a data connection to the private database.
Refer to the documentation for all of the detail regarding setting this up, in particular the prerequisites.
I used the following OCI Services:
- Oracle Analytics Cloud (OAC) with the Enterprise Analytics feature.
- Exadata Cloud Service (ExaCS) with an 19c pluggable database.
Step 1 -- Creating private access channel
Using the OCI Console access your OAC instance, navigate to the section, click , and then click .
The private access channel above and the ExaCS were in the same private subnet which makes it easier. Private access channel requires four IP addresses, two IP addresses are required for network traffic egress, one IP address for the private access channel, and one reserved for future use.
After about 30 minutes you can click on the created private access channel and note the ip addresses it is using within the subnet.
Step 2 -- Creating private access channel
can't access private data sources on an Oracle Database that uses a Single Client Access Name (SCAN). If you want to connect to an Oracle Database that uses a SCAN, use one of the following methods to set up the connection in : connect directly to the Oracle Database nodes, instead of SCAN or configure an Oracle Connection Manager in front of SCAN.
From your OAC Home Page, click Create, and then click .
When using ExaCS the default connection strings all use SCAN. Below are three examples connecting to a PDB on ExaCS that uses the compute node names instead.
|Basic connection to a single compute node|
Advanced with easy connection string