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.

  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, 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.
      If you don't see this option, make sure that the administrator has enabled one of the remote connectivity options in Console on the Remote Data Connectivity page.
  2. Create a new visualization project based on the connection that you created in the Step 1, and add columns from your on-premises database to the project.
  3. If you've also configured remote connection for reporting, in Classic Home, create a new analyis based on the connection that you created in Step 1, and add columns from your on-premises database to the analysis.