Oracle Cloud Infrastructure Documentation

Add the IP Address of Your Oracle Analytics Cloud Instance to Allowlists

Before you try to connect Oracle Analytics Cloud to an Oracle Cloud database, ask the database administrator to add the Gateway IP Address (or address range) for your Oracle Analytics Cloud instance to the target database's allowlist. The database administrator must add a security rule on the target Oracle Cloud database that allows TCP/IP traffic from Oracle Analytics Cloud on a specific database port.

This topic describes how to add Oracle Analytics Cloud to the allowlist for an Oracle Cloud database. If you want to connect to other data sources, follow similar steps, as required.

  1. Make a note of the Gateway IP Address of your Oracle Analytics Cloud instance or the Egress IP address of the private access channel that you or your database administrator must allow access to.
  2. Include the Gateway IP Address that you made a note of in Step 1 in the security list for your Oracle Cloud database.

    The way you register the IP address of your Oracle Analytics Cloud instance depends on whether the database you're trying to connect to is deployed on Oracle Cloud Infrastructure or Oracle Cloud Infrastructure Classic:

    • Database on Oracle Cloud Infrastructure
      1. Add an ingress rule.
        Description of uc1_securitylist.jpg follows

      2. Specify the IP address in the SOURCE CIDR field.
        Description of uc1_ingressrules.jpg follows

    • Database on Oracle Cloud Infrastructure Classic
      1. Add an access rule.Description of access_rules_ocic1-png.png follows
      2. Specify the IP address in the field below the Source fieldDescription of access_rules_ocic2-png.png follows