Adding an Endpoint for a Database Service

To run a database service, you must connect to a supported database. A JDBC endpoint provides this connection, or binding, between the service and the target database.

Consider the following:

Each database service interface can have one endpoint.
Adding an endpoint is optional during service development. Endpoints can be added to a service during service development, or later in the process during package definition or deployment definition. Additionally, if an endpoint is added during service development, the endpoint binding can be modified during package definition and/or during development.
Before adding a service endpoint to your service, review choosing an endpoint binding strategy. It is important that you understand the implications of binding endpoints at the various times.
For information about working with endpoints during the packaging phase, see Configuring Endpoints for a Services Package Profile.
Some endpoint types can be configured and grouped as connection profiles. You can create a connection profile for JDBC, Sybase ASA, Sybase ASE, and Sybase ASIQ.

To add an endpoint to a database service:

Choose from the following methods.

Drag-and-Drop from a Connection Profile

Use this method if you have a connection profile readily available.

Select the Service Interface page in the service editor.
In the Enterprise Explorer, expand the Databases node to locate the connection profile.
If a connection has not been made, right-click and select Connect to connect to the database and display its contents.
Drag the endpoint from the connection profile in the Enterprise Explorer to the interface object in the service diagram.
The endpoint graphically displays in the service diagram.
To edit the endpoint, right-click and select Edit End Point.
The New JDBC Endpoint Wizard appears.

New JDBC Endpoint Wizard

Use this method if a connection profile is not available, to add a logical endpoint, or to edit an existing endpoint in the service diagram.

Select the Service Interface page in the service editor.
Right-click on the Interface page and select Add Endpoint.
The New JDBC Endpoint wizard opens.
Select the endpoint type: server or logical.
Enter a meaningful name for the endpoint and click Next.
Specify the JDBC connection properties for the endpoint:
1. Select Browse for a valid endpoint in the Enterprise Explorer and click Browse.
2. Select a JDBC connection profile and click OK.
To expose stored procedures as operations on the selected endpoint, select one or more of the available stored procedures listed.
Click Next to view the Summary.
Click Finish.
The new endpoint is added to the interface and a series of new operations are added for the selected stored procedures.