Configuring Event Stream Processor

Configure your Event Stream Processor environment.

1. Edit the SYBASE.sh and SYBASE.csh files in the Event Stream Processor installation folder so that Event Stream Processor can find your driver manger and your driver manager can find the Sybase IQ drivers. In each file:
   1. Set the environment variable ODBCINI to the absolute path of your .odbc.ini file.
      • Add these lines to the bottom of the SYBASE.sh script:
        • ODBCINI=<Path to ODBC INI File>/.odbc.ini, where <Path to ODBC INI File> is the absolute path to the .odbc.ini file created or modified in the previous step.
        • export ODBCINI
      • Add a line to the bottom of the SYBASE.csh script: setenv ODBCINI <Path to ODBC INI File>/.odbc.ini where <Path to ODBC INI File> is the absolute path to the .odbc.ini file created or modified in the previous step.
   2. Add the absolute path to your driver manager libraries and the library symbolic link to the beginning of the LD_LIBRARY_PATH.
      • Add these lines to the bottom of the SYBASE.sh script:
        • (Linux and Solaris) LD_LIBRARY_PATH="<path to lib folder in driver manager>":"<path to IQ Client install location>/IQ15_4/lib64":$LD_LIBRARY_PATH, where <path to lib folder in driver manager> is the absolute path to the directory which contains the ODBC driver manager’s libraries.
        • (Linux and Solaris) export LD_LIBRARY_PATH
        • (Solaris only)LD_LIBRARY_PATH_64="<path to lib folder in driver manager>":"<path to IQ Client install location>/IQ15_4/lib64":$LD_LIBRARY_PATH_64, where <path to lib folder in driver manager> is the absolute path to the directory which contains the driver manager’s libraries.
        • (Solaris only)export LD_LIBRARY_PATH_64
      • Add these lines to the bottom of the SYBASE.csh script:
        • (Linux and Solaris) setenv LD_LIBRARY_PATH <path to lib folder in driver manager>:<path to IQ Client install location>/IQ15_4/lib64:"$LD_LIBRARY_PATH" where <path to lib folder in driver manager> is the absolute path to the directory which contains the driver manager’s libraries.
        • (Solaris only) setenv LD_LIBRARY_PATH_64 <path to lib folder in driver manager>:<path to IQ Client install location>/IQ15_4/lib64:"$LD_LIBRARY_PATH_64", where <path to lib folder in driver manager> is the absolute path to the directory which contains the driver manager’s libraries.
2. If you selected native OS authentication for your cluster, see the Event Stream Processor Administrators Guide and follow the instructions in the Configuring a Pluggable Authentication Module (PAM) for UNIX topic to enable this feature on your operating system.
3. Enable persistence on your cluster to ensure that projects added to the cluster will stay added between sessions. Edit the file $ESP_HOME/cluster/nodes/<node name>/<node name>.xml where <node name> is the name of the node you chose in the Event Stream Processor installer. Change the tag <Persistence enabled=“false”> to <Persistence enabled=“ true”>.
4. If you plan to use the SAP HANA sample project with Event Stream Processor:
   1. Install the SAP HANA client on the machine containing Event Stream Processor.
   2. Edit the SYBASE.sh and the SYBASE.csh file in the Event Stream Processor installation folder, and add the SAP HANA driver library directory to the LD_LIBRARY_PATH.
      • For Sybase.sh, add the lines to the bottom of the script:
        (Linux and Solaris)

        LD_LIBRARY_PATH=$LD_LIBRARY_PATH:"<path to SAP HANA ODBC Driver Library>"
        export LD_LIBRARY_PATH

        (Solaris only)

        LD_LIBRARY_PATH_64=$LD_LIBRARY_PATH_64:"<path to SAP HANA ODBC Driver Library>"
        export LD_LIBRARY_PATH_64

      • For Sybase.csh, add the lines to the bottom of the script:
        (Linux and Solaris)

        setenv LD_LIBRARY_PATH $LD_LIBRARY_PATH:"<path to SAP HANA ODBC Driver Library>"

        (Solaris only)

        setenv LD_LIBRARY_PATH_64 $LD_LIBRARY_PATH_64:"<path to SAP HANA ODBC Driver Library>"