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.
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:
|
|
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.
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.