Connect to Your Data

If you use Oracle BI Enterprise Edition to analyze hybrid data in on-premises databases, in cloud databases, or on your desktop you can do the same in Oracle Analytics Cloud. For optimum performance, Oracle recommends that you move your on-premises data to Oracle Cloud Infrastructure.

Topics

• About Data Source Connection Migration
• Move On-Premise Data to a Database on Oracle Cloud Infrastructure
• Connect to Data on On-premise Databases
• Connect to Data on Other Cloud Databases

About Data Source Connection Migration

Before you start, review the prerequisites listed here and understand the options available to you. The steps you need to take depend where your data is currently stored.

Data Source Prerequisites

• Understand which data sources Oracle Analytics Cloud supports. See Supported Data Sources.
• Check the version of each data sources that you're using and verify that Oracle Analytics Cloud supports it.
• Verify that Oracle Analytics Cloud is accessible from the host where you plan to install Data Gateway.

Data Source Migration Options

Where is Your Data Stored?	Description	More Information
On-premise database	You have two options: Recommended: Migrate your data to a database on Oracle Cloud Infrastructure. Use Oracle Analytics Model Administration Tool to reconfigure the database connection to point to the new database. Keep your data in on-premise databases such as Oracle Database, Oracle Essbase, MS SQL Server, Teradata, and IBM DB2. Use Data Gateway to access your on-premise data from the new Oracle Analytics Cloud instance on Oracle Cloud Infrastructure and then use Oracle Analytics Model Administration Tool to reconfigure the database connection in your semantic model .rpd file to point to the Data Gateway. If your remote on-premise data source is Oracle Essbase, you must use the legacy Remote Data Connector.	Move On-Premise Data to a Database on Oracle Cloud Infrastructure Connect to Data on On-premise Databases
Oracle Cloud database	You can keep your data in the same Oracle Cloud database, for example Oracle Autonomous Data Warehouse. You must configure the database connection on the new Oracle Analytics Cloud instance on Oracle Cloud Infrastructure.	Create a Connection to a Data Source
Other cloud databases	You can keep your data in the same database. If you configure Data Gateway to enable Oracle Analytics Cloud to access the database, you must use Oracle Analytics Model Administration Tool to reconfigure the database connection settings in your semantic model .rpd file.	Connect to Data on Other Cloud Databases

Move On-Premise Data to a Database on Oracle Cloud Infrastructure

Oracle recommends that you move data in your on-premise databases to Oracle Cloud Infrastructure.

1. Create a new database instance on Oracle Cloud Infrastructure and migrate your data.
   See

   Migrate an On-Premises Database to Oracle Cloud Infrastructure in Move to Oracle Cloud Using Zero Downtime Migration.

2. Determine the connection string for the new database.
3. Use the latest Model Administration Tool for Oracle Analytics Cloud to reconfigure the database connection in the source semantic model.
   See Clean Up and Reconfigure Your Semantic Model .rpd File.
4. If required, add the IP address of Oracle Analytics Cloud to the connection allowlist for the database on Oracle Cloud Infrastructure.

   See Find the IP Address or Host Name of Your Oracle Analytics Cloud Instance.

Connect to Data on On-premise Databases

If you decide to keep your data on-premise, you must install Data Gateway on the network where you host the data and set up a connection to the target Oracle Analytics Cloud.

Note:

To get the best performance, Oracle recommends that you move on-premise data to Oracle Cloud Infrastructure. Depending on your workload characteristics, you might experience a decrease in performance if you keep the data on premise.

1. Download Data Gateway from Oracle Technology Network.

   Download the version that matches your Oracle Analytics Cloud deployment. See Download Data Gateway.

2. Download Oracle Analytics Client Tools from Oracle Technology Network.

   Download the version that matches your Oracle Analytics Cloud deployment. See Download and Install Analytics Client Tools for Oracle Analytics.

3. Install and set up Data Gateway on the network where you host the on-premise data.
   See Set up Data Gateway.
4. Configure and register Data Gateway.

   See Configure and Register Data Gateway for Reporting.

5. If required, add the IP address of Oracle Analytics Cloud to the allowlist for your on-premise database (on your firewall).

   See Find the IP Address or Host Name of Your Oracle Analytics Cloud Instance.

Connect to Data on Other Cloud Databases

If your new Oracle Analytics Cloud instance on Oracle Cloud Infrastructure must connect to other cloud data sources (non-Oracle), you might need to add the IP address of the new Oracle Analytics Cloud instance to the allowlists for these data sources.

1. Determine the IP address of the target Oracle Analytics Cloud instance.

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

   • Oracle Analytics Cloud Subscription: See IP Ranges and Gateway IPs for Oracle Analytics Cloud
2. If required, add the IP range or Gateway IPs associated with your target Oracle Analytics Cloud to the allowlist for your cloud data sources.