Sample Service Configuration File

A sample of the service.xml configuration file in ESP_HOME/bin. You can use this as a reference for creating your custom service configuration file.

 <?xml version="1.0" ?>   
<Services>   
 <Service Name="SampleJDBCService" Type="DB">     
 <Parameter Name="DriverLibrary">esp_db_jdbc_sybase_lib</Parameter>      
 <Parameter Name="Host">localhost</Parameter>     
 <Parameter Name="Port">12345</Parameter>     
 <Parameter Name="User">user</Parameter>     
 <Parameter Name="Password">password</Parameter>     
 <Parameter Name="Database">db</Parameter>    
 </Service> 

 <!--  When defining a service with ODBC connectivity for Linux and -->   
 <!--  Solaris, the size of SQLLEN and SQLULEN type in the driver manager -->   
 <!--  determines the value to be	used for the DriverLibrary parameter. -->   
 <!--  For managers built with the above types being 8 bytes, -->   
 <!--  esp_db_odbc64_lib should be used. -->   
 <!--  If the type sizes are 4 bytes, use esp_db_odbc_lib. -->   
 <!--  For example if unixODBC is the driver manager, the odbcinst -->   
 <!--  command can be used to query this information: -->   
 <!--  odbcinst -j -->   
 <!--  unixODBC 2.3.1 -->   
 <!--  DRIVERS............: /usr/local/etc/odbcinst.ini -->   
 <!--  SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini -->   
 <!--  FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources -->   
 <!--  USER DATA SOURCES..: /usr/u/user/.odbc.ini -->   
 <!--  SQLULEN Size.......: 8 -->   
 <!--  SQLLEN Size........: 8 -->   
 <!--  SQLSETPOSIROW Size.: 8 -->   

 <!--  For Windows platform, use esp_db_odbc_lib. -->    
 <Service Name="SampleODBCService" Type="DB">     
  <Parameter Name="DriverLibrary">esp_db_odbc_lib</Parameter>     
  <Parameter Name="DSN">dsn</Parameter>     
  <Parameter Name="User">user</Parameter>     
  <Parameter Name="Password">password</Parameter>    
 </Service> 

 <!--  ONLY MEANT TO BE USED WITH ASE OUTPUT ADAPTER   -->    
 <Service Name="SampleOCSService" Type="DB">     
  <Parameter Name="DriverLibrary">esp_db_ocs_lib</Parameter>     
  <Parameter Name="Host">localhost</Parameter>     
  <Parameter Name="Port">5000</Parameter>     
  <Parameter Name="User">sa</Parameter>     
  <Parameter Name="Password"  />          
  <Parameter Name="AppName">ASEOutputAdapter</Parameter>    
 </Service>   
</Services>

Here is an example of connecting to the SAP HANA database using a generic JDBC connection through the Database Input or Output adapter:

First, copy the SAP HANA ngdbc.jar file to the $ESP_HOME/libj directory. Then, create a service definition for the connection in the service.xml file.

<Service Name="HANAarcherJDBC" Type="DB">
  <Parameter Name="DriverLibrary">esp_db_jdbc_lib</Parameter>
  <Parameter Name="DataSource">com/sap/db/jdbcext/DataSourceSAP</Parameter>
  <Parameter Name="Host">archer</Parameter>
  <Parameter Name="Port">30015</Parameter>
  <Parameter Name="User">SYSTEM</Parameter>
  <Parameter Name="Password">Password1</Parameter>
</Service>