Configuring Your Service.xml File

Configure your service.xml file to connect to the SAP HANA (or ASE) and Sybase IQ databases from Event Stream Processor.

1. Run your installed Event Stream Processor cluster to encrypt the passwords for the database to which you wish to connect using Event Stream Processor. Encrypt any Sybase IQ, SAP HANA, or Adaptive Server Enterprise passwords that you intend to use:
   1. Source the SYBASE.sh or SYBASE.csh script in the Event Stream Processor installation directory.
   2. Run the cluster you created during the Event Stream Processor install to use its encryption facilities. Replace <node name> with the node name specified in the installer and run this command as a background process: $ESP_HOME/bin/esp_server --cluster-node $ESP_HOME/cluster/nodes/<node name>/<node name>.xml
      If your are running a certain version of Solaris, an error may display stating that the libraries for the executable cannot be located. To correct this issue, see the instructions in the Known Issues for Event Stream Processor topic in the Sybase RAP Release Bulletin.
   3. Connect to your cluster node and encrypt all of your database passwords for use in the Event Stream Processor configuration files:
      • Connect to the cluster using the cluster admin tool. Replace <RPC port> with the RPC port for your ESP cluster, and <user name> with your cluster user name (with native OS authentication this is your OS login name). Run this command : $ESP_HOME/bin/esp_cluster_admin --uri esp://localhost:<RPC port> --username <user name>
      • The tool prompts you for your password and then for commands. Encrypt your password using this command: encrypt <password>. Replace <password> with the password for RAP_USER in the corresponding database. Repeat this for each database password you need to encrypt, and copy the encrypted results as you will need this information later.
      • After encrypting all database passwords, stop the Event Stream Processor node using the command: stop node <node name>, where <node name> is the name of the ESP node you created.
      • Type quit to exit the cluster admin tool.
2. Edit the Event Stream Processor service.xml file in $ESP_HOME/bin/service.xml to add information about the Sybase IQ database and make it available for connections within Event Stream Processor.

   Replace <encrypted password> with the encrypted password for your Sybase IQ database, and add the following ODBC entry for Sybase IQ:

   <Service Name="SybaseIQService" Type="DB">
    <Parameter Name="DriverLibrary">esp_db_odbc64_lib</Parameter>
    <Parameter Name="DSN">RAPIQ</Parameter>
    <Parameter Name="User">RAP_USER</Parameter>
    <Parameter Name="Password" encrypted="true"><encrypted password>
    </Parameter>
   </Service>

   If you are using a 32-bit driver manager, change the DriverLibrary value to esp_db_odbc_lib. Also, ensure that no other entries in the file use esp_db_odbc64_lib.

3. If you plan to use the SAP HANA sample project with Event Stream Processor, edit the Event Stream Processor service.xml file in $ESP_HOME/bin/service.xml to add information about the SAP HANA database and make it available for connections within Event Stream Processor.

   Replace <encrypted password> with the encrypted password for your SAP HANA database:

   <Service Name="HANAService" Type="DB">
    <Parameter Name="DriverLibrary">esp_db_odbc64_lib</Parameter>
    <Parameter Name="DSN">RAPHANA</Parameter>
    <Parameter Name="User">RAP_USER</Parameter>
    <Parameter Name="Password" encrypted="true"><encrypted password></Parameter>
   </Service>

   If you are using a 32-bit driver manager, change the DriverLibrary value to esp_db_odbc_lib. Also, ensure that no other entries in the file use esp_db_odbc64_lib.

4. If you plan to use the Adaptive Server Enterprise sample project with this server, edit the Event Stream Processor service.xml file in $ESP_HOME/bin/service.xml to add information about the Adaptive Server database and make it available for connections within Event Stream Processor.
   Replace:

   • <ASE Host Name> with the host name for your ASE server
   • <ASE Port> with the port of your ASE server
   • <encrypted password> with the encrypted password for your ASE database

   <Service Name="SybaseASEService" Type="DB">
    <Parameter Name="DriverLibrary">esp_db_ocs_lib</Parameter>
    <Parameter Name="Host"><ASE Host Name></Parameter>
    <Parameter Name="Port"><ASE Port></Parameter>
    <Parameter Name="User">RAP_USER</Parameter>
    <Parameter Name="Password" Encrypted="true"><encrypted password></Parameter>
    <Parameter Name="AppName">ASEOutputAdapter</Parameter>
   </Service>