IBM Cognos Analytics 11.0.13 and 11.1.x or higher Connection Guide to Oracle ADW

Step-by-step guide to configure IBM Cognos Analytics to connect to Oracle Autonomous Data Warehouse using JDBC drivers and wallet setup.


IBM Cognos Analytics 11.0.13 and 11.1.x or higher Connection Guide to Oracle ADW - cover page
Brand
IBM
Document type
User Manual
Language
English
Pages
5
File format
PDF
File size
679 KB
Published
04 November, 2026
Updated
04 November, 2026
MD5 checksum
1E74AD9E464A6090B886EF03E49EE758

About this manual

This guide details how to configure IBM Cognos Analytics to connect to Oracle Autonomous Data Warehouse (ADW). It covers installing the Oracle JDBC Driver 18.3, setting up the wallet, and configuring the connection via JDBC Thin URI using TNSnames.ora.

The steps include downloading required JAR files, placing them in the Cognos drivers folder, installing JCE policy files in the JRE security directory, and testing the connection after configuration.

What's inside

  • Installing IBM Cognos Analytics
  • Configuring JDBC Driver
  • Setting Up Oracle Wallet
  • Creating JDBC Thin URI
  • Testing Connection

Frequently asked questions

What JDBC driver version is recommended for connecting to Oracle ADW?

Oracle recommends using the latest Oracle JDBC Driver version 18c (18.3 or higher).

Where should the downloaded JAR files be placed?

The JAR files should be placed into the Drivers Folder of each Cognos Analytics server installation, typically \drivers directory.

What JRE policy files are required?

IBM Cognos Analytics needs JCE unrestricted policy files installed, specifically local_policy.jar and ux_export_policy.jar.

Download PDF (679 KB)

More IBM Manuals


View all IBM manuals →