odbc.ini File Examples for Configuring Data Encryption
- Last Updated: March 16, 2026
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
The following example odbc.ini files demonstrate how to configure the 64-bit Greenplum 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 and EnableFIPS=1,
the driver validates the certificate sent by the server and the host name specified by the
HostNameInCertificate option, and loads the FIPS provider for data encryption.
Driver=ODBCHOME/lib/ddgplmxx.so
Description=DataDirect Greenplum Wire Protocol driver
...
EnableFIPS=1
...
EncryptionMethod=1
...
HostName=GreenplumServer
HostNameInCertificate=MySubjectAltName
...
PortNumber=5432
...
Database=Accounting
...
Truststore=TrustStoreLocation
...
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/ddgplmxx.so
Description=DataDirect Greenplum Wire Protocol driver
...
EncryptionMethod=1
...
HostName=GreenplumServer
HostNameInCertificate=MySubjectAltName
...
KeyPassword=YourKeyPassword
Keystore=KeyStoreLocation
KeystorePassword=YourKSPassword
...
PortNumber=5432
...
Database=Accounting
...
ValidateServerCertificate=1
...