Using an Aster database with InfoSphere Streams ODBC operators

Release notes


Abstract

When you use the ODBC operators provided by the Database Toolkit in your InfoSphere Streams applications to connect to an Aster database, you must specify additional database-specific configuration information.

Content

InfoSphere Streams applications can use the ODBC operators provided by the Database Toolkit to connect to external databases such as Aster by using UnixODBC with an Aster driver.

Before you can use the ODBC operators in your Streams applications, you must specify the environment variables for compiling Streams applications and for running ODBC operators with an Aster database. You must also create odbc.ini and aster.ini files.

Important:

  • You must use UnixODBC Version 2.2.12.
  • On IBM POWER7 systems that are running Red Hat Enterprise Linux Version 6 (RHEL 6), an Aster database is not supported.
  • The Aster ODBC driver does not run on RHEL 5, CentOS 5, and SLES 11.3.

Procedure

1. To compile SPL applications that connect to Aster data, set the STREAMS_ADAPTERS_ODBC_UNIX_OTHER environment variable:
export STREAMS_ADAPTERS_ODBC_UNIX_OTHER=1
This environment variable tells the compiler the database that you want to connect to.

2. Set the following environment variables based on where the database client library is installed:
export STREAMS_ADAPTERS_ODBC_INCPATH=<UnixODBC_installation_directory>/include
export STREAMS_ADAPTERS_ODBC_LIBPATH=<UnixODBC_installation_directory>/lib

3. Create an odbc.ini file with the following information on the machine that runs the processing elements (PEs) that contain the ODBC operators.

Note: In the following example, adtest is the data source name and must match the name that is used in the connections.xml file.

[adtest]
Driver=/home/mydir/asterdata/driver/stage/clients-odbc-linux64/ODBCDriver/libAsterDriver_unixODBC.so
SERVER=myServerName-or-IPAddress
PORT=2406
DATABASE=myDatabase

4. Create an aster.ini file with the following information in your home directory:

[driver]
DriverManagerEncoding=UTF-32
DSILogging=0
ErrorMessagesPath=/home/mydir/asterdata/driver/stage/clients-odbc-linux64/ErrorMessages

5. At runtime, set the following environment variables:

export LD_LIBRARY_PATH=<asterData_ODBC_Driver_directory>/stage/clients-odbc-linux64/Libs
export ODBCINI=<absolute_path_of_the_odbc.ini file>
export ODBCSYSINI=<directory_containing_the_odbc.ini file>

Related information

InfoSphere Streams and Database Toolkit documentation

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere Streams

Software version:

3.1, 3.2, 3.2.1

Operating system(s):

Linux

Reference #:

7038497

Modified date:

2014-04-03

Translate my page

Machine Translation

Content navigation