The driver supports authenticating to the server using an access token obtained from Microsoft Entra ID (Azure Active Directory). The driver encrypts data using TLS/SSL encryption when using Entra ID access token authentication; therefore, the Encryption Method (EncryptionMethod) option is automatically set to 1 (SSL) when Entra ID authentication is enabled.

To enable authentication Entra ID access token authentication:

  • Set the Host (Hostname) option to specify either the IP address in IPv4 or IPv6 format or the server name for your Oracle server.
  • Set the Port Number (PortNumber) option to specify the TCP port of the primary database server that is listening for connections to the database.
  • Set the Authentication Method (AuthenticationMethod) option to 38 (EntraIDAccessToken).
  • Set the Entra Access Token (EntraAccessToken) option to specify the access token that you have obtained from Entra ID.
    Note: If you are using the Setup dialog, the Entra Access Token is exposed on the logon dialog box when Authentication Method is set to EntraIDAccessToken.
  • Set the Encryption Method (EncryptionMethod) to 1 (SSL).

The following examples show the connection information required to establish a session with Entra ID access token authentication.

Connection string

DRIVER=DataDirect 8.0 Oracle Wire Protocol;AuthenticationMethod=38;
       EncryptionMethod=1;EntraAccessToken="access_token";
       HostName=myserver;PortNumber=1521;

odbc.ini

[Oracle Wire Protocol]
Driver=ODBCHOME/lib/ivora28.so
...
Description=DataDirect 8.0 Oracle Wire Protocol
...
AuthenticationMethod=38
...
EncryptionMethod=1
...
EntraAccessToken="access_token"
...
HostName=myserver
...
PortNumber=1521
...