Use the service.xml file to store service definitions that store connection properties required for a database connection.
Create a separate service definition for every external database you want the Event Stream Processor Server to connect to.
You can use the sample service configuration file in ESP_HOME/bin as a basis to create your custom service.xml file. To use the file in a running project, modify the services-file parameter in the cluster configuration file of the node on which you will run the project. This ensures that the project can find the service.xml file. For example, <Property name="services-file">${ESP_HOME}/bin/service.xml</Property>.
To set up this type of connection from within Sybase Event Stream Processor: