Connect to Your Data

The way you connect your Oracle Analytics Cloud deployment on Oracle Cloud Infrastructure to your data is similar to your existing service on Oracle Cloud Infrastructure Classic. The steps you need to follow depend where your data is stored.

If you're currently using Oracle Analytics Cloud - Classic to analyze data in an Oracle Database on Oracle Cloud Infrastructure Classic, you must first move your data to Oracle Cloud Infrastructure before you migrate your Oracle Analytics Cloud - Classic instance.

Where is Your Data Stored? Description More Information
On-premises database You can keep your data in on-premises databases such as Oracle Database, Oracle Essbase, MS SQL Server, Teradata, and IBM DB2.

Use Data Gateway to access your on-premises data from the new Oracle Analytics Cloud instance on Oracle Cloud Infrastructure.

Connect to Data on On-premises Databases
Oracle Database on Oracle Cloud Infrastructure Classic

First, migrate your data to a database on Oracle Cloud Infrastructure.

Reconfigure the database connection to point to the new database before you migrate your Oracle Analytics Cloud Classic instance. There are two ways to do this:
  • Use the Database Connection dialog in the source Oracle Analytics Cloud Classic instance before you take the final snapshot.

    Use this method if you use Data Modeler.

  • Use the Model Administration Tool for Oracle Analytics Cloud to edit the connection information before you migrate the final snapshot.

    Use this method if you use Oracle Analytics Client Tools to manage your semantic models.

 Move Data from Oracle Cloud Infrastructure - Classic
Oracle Database on Oracle Cloud Infrastructure You can keep your data in the same database.

You must reconfigure the database connection on the new Oracle Analytics Cloud instance on Oracle Cloud Infrastructure.

Connect to Data on Oracle Cloud Infrastructure
Other cloud databases You can keep your data in the same database.

You must reconfigure the database connection on the new Oracle Analytics Cloud instance on Oracle Cloud Infrastructure.

Connect to Data on Other Cloud Databases