Connect to an On-premises Database from Oracle Analytics Cloud

After you've installed and deployed Data Gateway, you can start analyzing data in your on-premises database.

If you don't see a Use Remote Data Connectivity option on the Create Connection dialog, ask the Oracle Analytics administrator to enable one of the remote connectivity options in Console on the Remote Data Connectivity page.

1. Create a connection to your on-premises database:
   1. From the Home page, click Create, then Connection.
   2. Click a connection type that supports remote connectivity. For example, you want to connect remotely to an Oracle database.
   3. Use the Create Connection dialog to specify the connection details of your on-premises database.
      For example, for an on-premises Oracle Database, specify the Host, Port, Service Name, and credentials.
   4. Enable the Use Remote Data Connectivity option.
2. Create a workbook using the connection that you created in the Step 1.
   1. At the Oracle Analytics home page, click Create, then click Workbook.
   2. At the Add Dataset dialog, select the on-premises database and add columns from it to a visualization.
3. If you've also configured remote connection for reporting, in Classic Home, create an analysis based on the connection that you created in Step 1.
   1. At the Oracle Analytics home page, from the Page menu, then click Open Classic Home.
   2. From the top toolbar, click Create, then click Analysis. In the Select Subject Area drop-down list, select a subject area in the on-premises database and add columns from it to a visualization.