Name

Name of the Service Endpoint.

X

Type

Type of the Service Endpoint.

The value is preset with “DB Inbound” and cannot be changed.

X

Description

Description of the Service Endpoint.

Table Name

Table or View from which the lines have to be read.

X

URL

Database Connection URL format:

Oracle with SID: jdbc:oracle:thin:@hostname:port:SID

Oracle with Servicename: jdbc:oracle:thin:@//hostname:port/servicename

PostgreSQL: jdbc:postgresql://hostname:port/databasename

MS SQLServer:        jdbc:sqlserver://hostname:portnumber;database=databasename

SAP HANA: jdbc:sap://hostname:port

X

Driver

Database JDBC Driver.

X

Table Owner

Database Table owner.

X

Username

Database user for login.

X

Password

Database password for login.

X

Where Clause

Optional condition when reading the data, e.g. STATUS=3

Quantity of Messages

Types:

•One message per row.

•One message per table.

X

XSL Parameter

Comma-separated list of parameters that are made available in the XSL transformation.

Example:

PARA1=VALUE1,PARA2=VALUE2

These parameters can be accessed in the XSL Transformation as xsl:param:

<xsl:param name="PARA1" />
<xsl:param name="PARA2" />

Response XML template

The XML template has 2 values:

•Request XML

•UT XML

X

Request XSL file

The incoming XML is transformed into UTI XML in order to process the data.

X

Response XSL file

XSL file to transform the UTI XML into the response message.

Target version

SDE version in which the data is stored.

X

Outbound endpoint

Additionally redirects the message to an outbound endpoint.