1. Connecting Oracle Analytics Cloud to Your Data
  2. Connecting Oracle Analytics Cloud to Your Data
  3. Connect to On-premises Data Sources
  4. Connect to On-premises Data Sources Using Data Gateway
  5. Before You Start with Data Gateway

Before You Start with Data Gateway

Download and install the required software.

  • Download the latest update of Oracle Analytics Cloud Data Gateway from Oracle Technology Network. For a list of supported operating systems, see Download page for Oracle Analytics Cloud.

  • To upgrade an earlier server installation of Data Gateway on Linux, install the latest update of Data Gateway into the existing installation folder on each machine where you've deployed Data Gateway. See Install or Upgrade Data Gateway.

  • (Optional) If you're creating remote connections for analyses and dashboards, download and install Oracle Analytics Client Tools on a Windows machine to get the latest Model Administration Tool for Oracle Analytics Cloud from Oracle Technology Network. If you have a visualization-only deployment (for example, Oracle Analytics Cloud Professional Edition), you don't need Model Administration Tool.

  • If you're deploying Data Gateway on Linux, unless you're performing a silent installation, make sure that you have an X server set up with the correct DISPLAY variable setting.

Download Data Gateway

Download Data Gateway from Oracle Technology Network (OTN) to a Linux or Windows machine where you want to install Data Gateway.

To find out the supported versions of operating systems, refer to the OTN download page.
  1. Navigate to the OTN download page for Oracle Analytics Cloud.
  2. Under Oracle Data Gateway <Month Year> Update, click Oracle Analytics Cloud Data Gateway <Month Year> Update Self-contained Installer for Linux and Windows to display the Oracle Software Delivery Cloud page.
  3. Click the Platforms down arrow and select the platform(s) onto which you're deploying Data Gateway, then click outside of the drop-down list or press Enter.
    The ZIP files available for each Platform are selected by default.
  4. If you selected "All" or "Microsoft Windows x64" in the Platforms option, de-select any components that you don't want to download.
    For example, you might de-select Oracle Analytics Power BI Connector.
  5. Accept the Oracle Cloud Service License Agreement.
  6. Click Download to start Oracle Download Manager, and follow the on-screen instructions.
  7. When the download is complete, click Open Destination.
  8. Extract the Oracle installer from the downloaded ZIP file.
    For example, for Linux, extract DataGateway_<update>Linux64.bin, or for Windows extract DataGateway_<update>Windows64.exe.

Download and Install Oracle Analytics Client Tools

Download and install Oracle Analytics Client Tools to enable remote connections from reporting dashboards and analyses. In addition, you might use Administration Tool (one of the client tools available for Microsoft Windows) to edit a semantic model (.rpd file) that isn't supported by Semantic Modeler.

You install Oracle Analytics Client Tools on Windows or Linux platforms.
  • On Windows, the software pack installs the graphical user-interface version of Administration Tool , as well as command line utilities such as runcat.cmd (for catalog management).
  • On Linux, the software pack installs runcat.sh and datamodel.sh command line utilities.

Note:

Oracle updates Oracle Analytics Client Tools with each Oracle Analytics Cloud update. Make sure that you're using the latest update of Oracle Analytics Client Tools.
  1. Navigate to the download page for Oracle Analytics Client Tools.
  2. Click the latest Oracle Analytics Client Tools <Month Year> Update link to display the Oracle Software Delivery Cloud page.
  3. Click the Platforms down arrow, click All, then click outside of the drop-down list or press Enter.
  4. In the Software column of the table, select the download pack for the platform you want.
    • For Windows, select Oracle Analytics Client May2023-Win for (Microsoft Windows x64 (64-bit)), <Size in MB>.
    • For Linux, select Oracle Analytics Client May2023-Linux for (Linux x86-64), <Size in MB>.

    Make sure that other components are de-selected (for example, Data Gateway and Power BI Connector).

  5. Accept the Oracle Cloud Service License Agreement.
  6. Click Download to start Oracle Download Manager, and follow the on-screen instructions.
  7. When the download is complete, click Open Destination.
  8. Extract and run the Oracle installer from the downloaded ZIP file.

    For example, extract and run the installer file oac_client-<update ID>-win64.exe, and follow the on-screen instructions.

    To start the tools on Windows, go to your Windows Start menu, click Oracle Analytics Client Tools, and then select the name of the tool you want to use. For example, to edit your semantic model, click Model Administration Tool.

    On Linux, use the runcat.sh and datamodel.sh command line utilities. See Using Oracle Analytics Client Tools on Linux.