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 oac_bi_rdc_client_<update>Windows.exe.

Download, Install, and Start Oracle Analytics Client Tools

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

You can install Oracle Analytics Client Tools on Windows or Linux platforms.
  • V1048278-01.zip Oracle Analytics Client March2025-Win for (Microsoft Windows x64 (64-bit)) - For Windows, the software pack installs the graphical user-interface version of Model Administration Tool, as well as command line utilities such as runcat.cmd (for catalog management).
  • V1048279-01.zip Oracle Analytics Client March2025-Linux for (Linux x86-64) - For 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. Using mismatched versions leads to incompatibility issues.
  1. Navigate to the download page for Oracle Analytics Client Tools.
  2. Click the latest Oracle Analytics Client Tools Latest Update link to display the Oracle Software Delivery Cloud page.
  3. Click the Platforms down arrow, click All.
  4. In the Software column of the table, select the download pack for your platform (Windows or Linux).
    • For Windows, select V1048278-01.zip Oracle Analytics Client March2025-Win for (Microsoft Windows x64 (64-bit)).
    • For Linux, select V1048279-01.zip Oracle Analytics Client March2025-Linux for (Linux x86-64).

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

  5. In the Oracle Software Delivery Cloud page, click the license agreement checkbox.
  6. Click Download.
  7. Navigate to the downloaded installer (.exe) file on your computer.
  8. Run the installer file as Administrator.
  9. Start the Oracle Analytics Client Tools:
    • For Windows, go to the Windows Start menu, click Oracle Analytics Client Tools, and select the name of the tool you want to use. For example, to edit your semantic model, click Model Administration Tool.
    • For Linux, run the runcat.sh and datamodel.sh command line utilities. See Using Oracle Analytics Client Tools on Linux.