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.
- Create a connection to your on-premises database:
- Create a workbook using the connection that you created in the Step 1.
- At the Oracle Analytics home page, click Create, then click Workbook.
- At the Add Dataset dialog, select the on-premises database and add columns from it to a visualization.
- 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.
- At the Oracle Analytics home page, from the Page menu, then click Open Classic Home.
- 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.