Configuring Connections to Databases Using Specific Network Cards

Configure Event Stream Processor to communicate with the SAP HANA (or ASE) and Sybase IQ databases using specific network cards instead of the defaults.

The process of configuring a connection to a database differs depending on the database you are connecting to and the adapter you are using. In RAP, you connect to the Sybase IQ and SAP HANA (or ASE) databases using the Sybase IQ and SAP HANA (or ASE) adapters.

Use an ODBC connection for the Sybase IQ and SAP HANA adapters, and an Open Client connection for the ASE adapter. When creating your connections, set the value for the host machine parameter to the IP address of the desired non-default NIC on the machine hosting the database. All communication between the adapter and the database then occurs on this network card. Therefore, the machine hosting the adapter must have at least one network card configured to use the same network as the card you are using on the database server machine.

Specifying the destination network card is the only configuration required to ensure that communication between Event Stream Processor and the destination databases occurs on the desired card. By default, the SAP HANA (or ASE) and Sybase IQ databases listen for connection requests on all cards.

The SAP Sybase RAP Installation and Configuration Guide provides instructions on configuring ODBC for Event Stream Processor. This procedure involves modifying the odbc.ini file to enable communication with Sybase IQ and SAP HANA. To change your ODBC configuration to communicate with non-default network cards on the Sybase IQ and SAP HANA machines, modify the odbc.ini file as follows:
  1. Locate the [RAPIQ] section identifier in the odbc.ini file.
  2. Within the [RAPIQ] section, locate the CommLinks parameter. The value for this parameter includes the host name for the Sybase IQ database sever. For example: CommLinks=tcpip{host=MySybaseIQ_DB;port=2638}
  3. Replace the host name of the Sybase IQ database server with the IP address of the non-default network card you want to use for communication on the machine hosting Sybase IQ.
  4. Locate the [RAPHANA] section identifier.
  5. Within the [RAPHANA] section, locate the ServerNode parameter. The value for this parameter includes the host name for the SAP HANA database server. For example: ServerNode=MySAPHANA_DB:2639
  6. Replace the host name of the SAP HANA database server with the IP address of the non-default network card you want to use for communication on the machine hosting SAP HANA.
  7. Save and close the file.

For additional information on configuring the obdc.ini file for Event Stream Processor, see Configuring ODBC for Event Stream Processor in the SAP Sybase RAP Installation and Configuration Guide.

The SAP Sybase RAP Installation and Configuration Guide provides instructions on configuring the ESP service.xml file to establish database connections. To change your service definition for ASE to use a non-default network card, modify the service.xml file as follows:
  1. Locate the Service Name parameter with the value SybaseASEService.
  2. Within this service definition, change the Host parameter to the IP address of the non-default network card you want to use for communication on the machine hosting ASE.
  3. Save and close the file.

For additional information on configuring service definitions for Event Stream Processor, see Configuring Your Service.xml File in the SAP Sybase RAP Installation and Configuration Guide.

Parent topic: Configuring End-to-End Communication on Non-Default Network Cards