Typical Workflow to Connecting to On-premises Data Sources with Data Gateway
Here are the common tasks for connecting to on-premises data sources with Data Gateway.
You can review frequently asked questions before you start. See Frequently Asked Questions about Data Gateway.
Task | Description | More Information |
---|---|---|
Perform the prerequisite tasks |
Download Data Gateway and optionally download Model Administration Tool. |
|
Install Data Gateway |
Install a Data Gateway agent on a local machine. |
|
Upgrade Data Gateway | 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. | Install or Upgrade Data Gateway |
Configure remote data connectivity |
Configure your on-premises environment and register one or more Data Gateway agents. |
|
Configure remote connectivity for reporting |
(Optional) Perform additional configuration to enable remote connection from dashboards and analyses. |
|
Test Data Gateway |
Test your deployment by analyzing data in your on-premises database. |
To connect from BI Analytics, see Connect to an On-premises Database from Oracle Analytics Cloud To connect from Publisher, see Set Up a JDBC Connection to an On-premises Data Source. |
Monitor Data Gateway | Use the Status page in Data Gateway to monitor the jobs that Data Gateway uses to fetch remote data. | Diagnosing Connection Issues Using The Status Page |
Manage Data Gateway |
Review installation details, adjust logging levels, or uninstall Data Gateway. |
|
Manage Data Gateway agents | Add agents to improve performance or provide a backup, check the status of agents, and check for remote connection issues. | Manage Data Gateway Agents |