Connection to Oracle using Enterprise User Security (EUS)

Applies to: Denodo 6.0 , Denodo 5.5 , Denodo 5.0
Last modified on: 25 Jan 2016
Tags: Administration Oracle

Download document

You can translate the document:

Goal

This document describes how to connect to an Oracle instance that uses Enterprise User Security (EUS).

Content

When trying to connect to an Oracle instance that uses EUS see the following error message will be shown when trying to create a JDBC data source in Virtual DataPort: "unsupported verifier type".

In order to avoid this issue, the following steps can be followed:

  • Open the Denodo Control Center.
  • Click on Configure.
  • Click on JVM Options.
  • Add the text -Doracle.jdbc.thinLogonCapability=o3 at the end of the text for the Virtual DataPort Server / ITPilot Wrapper Server configuration. For instance:

-mx1024m

-XX:MaxPermSize=256m

-Doracle.jdbc.thinLogonCapability=o3

  • Click Ok.
  • Save the changes and restart the Virtual DataPort server.

Once this option is added to the JVM configuration it will be possible to create a JDBC data source in Virtual DataPort against an Oracle instance with EUS.

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training