Using an Aster database with InfoSphere Streams ODBC operators

Release notes


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.


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.


  • 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.

  1. To compile SPL applications that connect to Aster data, set the STREAMS_ADAPTERS_ODBC_UNIX_OTHER environment variable:


    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.

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

  5. 5. At run time, 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

Document information

More support for:

InfoSphere Streams

Software version:

3.1, 3.2, 3.2.1

Operating system(s):


Reference #:


Modified date:


Translate my page

Machine Translation

Content navigation