Connect to Data Using JDBC

You can use JDBC to connect to databases that aren’t listed as connection types on the Create Connection dialog.

Note:

  • Oracle doesn't manage the license or usage compliance for any JDBC drivers that you deploy in your environment.
  • 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.
  • Oracle Analytics might be unable to list database objects with some JDBC drivers.
You use drivers in a JDBC JAR file to connect to databases.
Check with your administrator that the JDBC driver version must match the database version, even when using an Oracle database. A version mismatch can result in data issues.
For the connection criteria:
  • Avoid using instance-specific connection names such as host names, because the same connection can be configured against different databases in different environments, for example, development and production.
  • Check the driver documentation and the JAR file for specifying the URL of your JDBC data sources.
  • Find the driver class name in the JAR file or from wherever you downloaded the JAR file.
  • When you install a JDBC driver locally, make sure that it doesn't have the same driver class as an existing driver. If you do install two drivers with the same driver class, you'll get a connection error when you use this connection (for example, Failed to save connection Invalid hostname.).
  • For the URL value, specify the JDBC URL, for example, jdbc:oracle:thin:@host:port/database.
  • For the Driver Class Name value, use the name specified in the JDBC driver download pack that you're using, for example, oracle.jdbc.driver.OracleDriver.
  1. On the Data or Home page, click Create, then click Connection.
  2. In the Create Connection dialog, locate and click the JDBC icon.
  3. Enter the connection criteria.
  4. Click Save.
    You can now create datasets from the connection.
If you import a workbook containing a JDBC connection into an Oracle Analytics installation where the JDBC driver isn’t installed, the import still works. However, the connection doesn’t work when you try to run the workbook or Data Flow. You must recreate the JDBC connection and JDBC driver to a suitable data source.