odbc.ini File Examples for Configuring Data Encryption

Using the Driver : Using Security : SSL Encryption : Summary of Data Encryption Related Options : odbc.ini File Examples for Configuring Data Encryption

Try DataDirect Drivers Now

The following example odbc.ini files demonstrate how to configure the 32-bit Oracle Wire Protocol driver to use data encryption via the SSL Server Authentication and SSL Client Authentication methods. These examples include the necessary options to configure data encryption as well as the minimum options required to establish a connection.

SSL Server Authentication

This odbc.ini file configures the driver to use the SSL Server Authentication method. In this configuration, since ValidateServerCertificate=1, the driver validates the certificate sent by the server and the host name specified by the HostNameInCertificate option.

Driver=ODBCHOME/lib/ivhivexx.so
Description=DataDirect Apache Hive Wire Protocol driver
Database=Hivedb1
EncryptionMethod=1
HostName=HiveServer
HostNameInCertificate=MySubjectAltName
PortNumber=10000
Truststore=TrustStoreName
TruststorePassword=TSXYZZY
ValidateServerCertificate=1

SSL Client Authentication

This odbc.ini file configures the driver to use the SSL Client Authentication method. In this configuration, since ValidateServerCertificate=1, the driver validates the certificate sent by the server and the host name specified by the HostNameInCertificate option.

Driver=ODBCHOME/lib/ivsqlsxx.so
Description=DataDirect SQL Server Wire Protocol driver
Database=Hivedb1
EncryptionMethod=1
HostName=HiveServer
HostNameInCertificate=MySubjectAltName
PortNumber=10000
Truststore=TrustStoreName
TruststorePassword=TSXYZZY
ValidateServerCertificate=1