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:
<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>
<Service Name="HANA_Generic_JDBC_Service" Type="DB"> <Parameter Name="DriverLibrary">esp_db_jdbc_lib</Parameter> <Parameter Name="DataSource">com/sap/db/jdbcext/DataSourceSAP</Parameter> <Parameter Name="ConnectString">host:port://HANA_DB_SERVER_HOST:PORT_NUMBER/?encrypt=true&validateCertificate=true&hostNameInCertificate=HANA_DB_SERVER_HOST&keyStore=KEYSTORE_FILE&keyStoreType=JKS&keyStorePassword=KEYTSTORE_PASSWORD&trustStore=KEYSTORE_FILE&trustStoreType=JKS&trustStorePassword=KEYTSTORE_PASSWORD</Parameter> <Parameter Name="DriverManager">true</Parameter> <Parameter Name="User">USERNAME</Parameter> <Parameter Name="Password">PASSWORD</Parameter> </Service>To connect using SSL encryption, ensure the DriverManager parameter is specified and set to true. If you specified a relative keystore filepath, place the keystore file under the base project directory.