After you've installed Data Gateway, you configure your on-premise environment and register one or more Data Gateway agents for remote connectivity to visualization projects.
- Log into Oracle Analytics Cloud as an administrator.
- Copy your Oracle
Analytics Cloud URL:
- In a browser, navigate to the home page of your Oracle
Analytics Cloud instance.
Use the same URL that end users use to connect to Oracle Analytics Cloud.
- In the browser's address bar, copy the URL up to and including
<domain> (not the text after that).For example, if the URL is
https://oacinst-tenancy.analytics.ocp.oraclecloud.com/dv/ui, then copy
https://oacinst-tenancy.analytics.ocp.oraclecloud.com.You'll use this URL in Step 4 when you set up Data Gateway in Agent Configuration.
- In a browser, navigate to the home page of your Oracle Analytics Cloud instance.
- Enable Data Gateway in Console:
- From the Oracle Analytics Cloud Home page, click Console.
- Click Remote Data Connectivity.
- Enable the Enable Data Gateway option.Keep this browser page open as you complete the following steps.
- For each deployment of Data Gateway, use Data Gateway Agent Configuration to
generate an authorization key for that machine:If you're asked to log in, enter the same username and password that you specified in the Credentials page of the Data Gateway installer.
- Start the Data Gateway Configuration page.
- In a server deployment, open a web browser and enter
<Local hostname>:<port>/obiee/config.jsp. To obtain the URL used to start Data Gateway Agent Configuration, use the
/<Data Gateway install folder>/domain/bin/status.shcommand and refer to the URL output value displayed.
- For a personal deployment on Windows, from your
local installation folder, click
- For a personal deployment on MacOS, from your local
installation folder, click
- In a server deployment, open a web browser and enter the URL:
- In the URL field, enter the Oracle Analytics Cloud URL that you copied in Step 2.
- Click Generate Key, then click Copy
to Clipboard.Tip: Don't click Test, Save, or Enable yet.Leave the other fields blank.
- Start the Data Gateway Configuration page.
- Switch to the browser session where you have the Console page Remote
Data Connectivity displayed, and add a Date Gateway agent.
- Under Data Gateway, click Add.
- In Public Key, paste in the key that you copied
using the Copy to Clipboard option in Step
4.c.When you paste in the key, the Name, ID, and Host fields are completed with the details of the on-premise machine where you've installed Data Gateway.
- Click OK to save the details.
- Switch to the Data Gateway Configuration page.
- Optional: Use the Allowed Hosts field to restrict Data Gateway access to specific host machines. Leave the field blank to enable Data Gateway to access any host machine.You can specify host names and IP addresses with asterisk (*) wildcards, separated with a semi-colon.For example,
abcd*.example.com; 10.174.*.By default the Data Gateway agent will attempt to connect to a data source on any host specified in a remote connection in Oracle Analytics Cloud. The Allowed Hosts field allows you to constrain the target hosts and IP addresses that Data Gateway can connect to. However, you must configure Data Gateway so that all agents can serve all remote queries.
- Optional: Use the Allowed SQL Statements field to restrict Data Gateway to specific SQL or data manipulation language (DML) constructs. Leave the field blank to enable Data Gateway to execute any SQL statements or DML constructs on the data source.For example, specify
SELECTto restrict Data Gateway to read-only access to the remote data source. Or specify
SELECT; ALTER SESSIONto restrict Data Gateway to using SELECT and ALTER SESSION operations.Make sure that the SQL in any metadata repository/RPD connect scripts (or anywhere else) doesn't contain trailing whitespace or control characters (EOL - End of line, or CR - Carriage Return).
- Click Test, Save, then
Enable.To deploy multiple Data Gateway agents, repeat steps 4 to 9 for each agent.
If the test fails, this means that the Data Gateway agent can't authenticate. Possible reasons include:
- The agent key hasn't been copied to the Remote Data Connectivity page in Oracle Analytics Cloud Console.
- The agent key has been regenerated in the agent, but the new key hasn't been copied to the Remote Data Connectivity page in Oracle Analytics Cloud Console.
- There's no suitable network route from the agent to Oracle Analytics Cloud.
If you also want to connect remotely from reporting dashboards and analyses, perform the additional configuration steps in Configure and Register Data Gateway for Reporting.