The service configuration file (service.xml) contains database service definitions, which include all the properties and parameters required for a database connection.
Use these properties to create the database connection for a service. Adapters that require database access obtain connections from the database manager by specifying the service that the connection is created for. For example, you can define services for connecting to an Adaptive Server Enterprise database through JDBC and to SQL Server through ODBC. So if you create a project with a database (DB) adapter attached to a source stream that retrieve input data from an Adaptive Service Enterprise database over JDBC; specify the Adaptive Server Enterprise service name as part of the adapter configuration (service property). At runtime, the adapter obtains a connection from the database manager based on the properties in the service definition, and executes queries over it.
Each <Service> block represents one service definition entry with two attributes on the <Service> node, Name and Type. The Type attribute must be "DB" to indicate the service is a DB service type. The <Service> node has multiple <Parameter> tags, each representing one property or setting. A <Parameter> tag consists of a Name attribute and the actual parameter value. Event Stream Processor DB drivers parse this information and set up connections accordingly.