Typical Workflow to Connecting to On-premises Data Sources

Here are the common tasks for connecting to on-premises data sources.

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 Oracle Developer Client Tool.

Before You Start with Data Gateway

Install Data Gateway

Install Data Gateway on a local machine.

Install Data Gateway

Configure remote data connectivity

Configure your on-premises environment and register one or more Data Gateway agents.

Configure and Register Data Gateway for Visualization

Configure remote connectivity for reporting

(Optional) Perform additional configuration to enable remote connection from dashboards and analyses.

Configure and Register Data Gateway for Reporting

Test Data Gateway

Test your deployment by analyzing data in your on-premises database.

Connect to an On-premises Database from Oracle Analytics Cloud

Manage Data Gateway

Review installation details, start and stop, or deinstall Data Gateway.

Maintain Data Gateway