Overview to Connecting to On-premises Data Sources
You can connect to remote on-premises data sources from Oracle Analytics Cloud. This enables you to deploy Oracle Analytics Cloud with large on-premises datasets without migrating the data to the cloud. Users can analyze the data in data visualizations, and in reporting dashboards and analyses.
You can connect to remote on-premises data sources over a private access channel or use Data Gateway. In most cases, using a private access channel is better than using Data Gateway because it provides direct and secure connectivity without having to install agents in-between. While a private access channel offers you on-going simplicity and better performance, it does require a Virtual Private Network (VPN) or some other direct network connectivity between Oracle Cloud and your data center, which is not a requirement for Data Gateway.
Before you choose your preferred approach, use Oracle Analytics Cloud's supported data source matrix to check whether you can use a private access channel or Remote Data Connectivity to connect to your on-premises data source. See List of Supported Databases in Oracle Analytics Cloud.
To find out how to set up a private access channel or Data Gateway, see: