Connect to Data on On-premises Databases

You can keep data in your on-premises database. If you haven’t done so already you need to install Data Gateway on the network where you host the data and set up a connection to the target Oracle Analytics Cloud instance on Oracle Cloud Infrastructure.

1. Set up Data Gateway.
   1. Install and set up Data Gateway.
      See Set up Data Gateway.
   2. Configure and register Data Gateway.
      See Configure and Register Data Gateway.

   You don't need to reconfigure your semantic model (.rpd).

2. Connect to the on-premises database from Oracle Analytics Cloud.
   See Connect to an On-premises Database from Oracle Analytics Cloud.
3. If required, add the IP address range or Gateway IPs associated with your target Oracle Analytics Cloud to the allowlist for your on-premises database (on your firewall).

   • Oracle Analytics Cloud (Universal Credits): See Find the IP or Host Name of Your Oracle Analytics Cloud Instance on Oracle Cloud Infrastructure (Gen 2)