JDBC

You can connect Oracle Analytics to JDBC-supported data sources using the JDBC connection type.

Although the JDBC connection type is certified, Oracle can't guarantee to resolve issues with uncertified data sources that you connect to using the JDBC connection type. Make sure that you fully test data sources and database features before deployment to production.

Before you start, check with your service administrator that remote connectivity is enabled in Oracle Analytics and that your data source is accessible from the instance where Data Gateway is installed.

Supported Versions

Latest version.

Prerequisites

None.

Connectivity

Use Data Source With Support Connectivity Options Notes
Datasets Yes
  • Private
    • Remote Data Connectivity
  • Data access - Cache only
 -
Semantic Modeler Yes
  • Public
  • Private
    • Private access channel
    • Remote data connectivity

-
Model Administration Tool No

-

 -
Oracle Analytics Publisher No

-

 -

For more information about this connectivity table, see Key to Connectivity Information.

Other Connectivity Information

  • None.

Useful Documentation Links