CDC Guide for Linux, UNIX, and Windows

10.5.1
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Configuring ODBC on Linux

On Linux, use the DataDirect ODBC driver for SAP HANA or the unixODBC driver to establish the ODBC connection.

If you use the DataDirect driver, you must enter the database name when you create a capture registration.

If you use the unixODBC driver, you must specify a DSN for the connection.

Create environment variables for the paths to odbc.ini and odbcinst.ini files and to the ODBC library, as follows:

ODBCINST=/dtl/installdirectory/ODBC/linux-x64/ODBC7.1/lib/odbcinst.ini
ODBCINI=/dtl/installdirectory/ODBC/linux-x64/ODBC7.1/lib/odbc.ini

The path for ODBCHOME variable depends on the installation of the ODBC driver on the Linux system.

The following example shows the path for the unixODBC driver:

ODBCHOME=/usr/lib64

The following example shows the path for the DataDirect driver:

export
ODBCHOME=/dtl/installdirectory/ODBC/linux-x64/ODBC7.1

The following example shows a sample entry for the SAP HANA driver in the odbcinst.ini file:

 [ODBC Drivers]
HDBODBC=Installed
[HDBODBC]
DRIVER=/dtl/installdirectory/ODBC/linux-x64/ODBC7.1/lib/libodbcHDB.so
DESCRIPTION=HANA Driver
SETUP=/dtl/installdirectory/ODBC/linux-x64/ODBC7.1/lib/libodbcHDB.so
CPTIMEOUT=0
DriverManagerEncoding=UTF-8

The following example shows a sample entry in the odbc.ini file for the SAP HANA data source:

[HXEHOST]
DRIVER=/dtl/installdirectory/ODBC/linux-x64/ODBC7.1/lib/libodbcHDB.so
SERVERNODE=ip_address:port_number
USER=user_name
PASSWORD=password
DATABASENAME=db_name
DRIVERUNICODETYPE=1
DESCRIPTION=description