Adding an OCS Connection to an External Database

Using the data services view in the Studio SAP ESP Authoring perspective, create a service definition for an Open Client (OCS) connection to the SAP Adaptive Server Enterprise (ASE) database. OCS connections are supported only through the SAP ASE Output adapter.

1. In the data services view, right-click the SAP ESP server, and select Load Workspaces.
2. Choose a location, then right-click it and select Add OCS Service.
   • To create a data service that is available to all workspaces on the cluster, choose Server-wide.
   • To create a data service that is only available to one workspace, choose a specific workspace.
3. (Optional) Right-click the new database service, and select Rename Service. Create a name that:
   • begins with a letter,
   • is unique,
   • is case-sensitive,
   • contains a character string consisting of any letters, numbers, underscores, dots, and colons.
   This service name is the value you specify to components, such as the database adapter, that access external databases.
4. Select the new data service. In the properties view, set the User and Password parameters to the credentials necessary for communicating with the external database.
5. (Optional) Add a description of the database service in the Description parameter.
6. Enter details for the Host and Port.
7. (Optional) Set the TDSPacketSize parameter for optimal performance. If not set, ESP uses the default value for Open Client.
   See the CS_PACKETSIZE connection property in the Open Client documentation for more information.
8. (Optional) Set the Application Name parameter to help identify Open Client database connections used by the ASE Output adapter.
   See the CS_APPNAME connection property in the Open Client documentation for more information.
9. Right-click on the data service and select Save Service.
   Note If the data service cannot be saved due to missing or incomplete information, a notification appears in the authoring console.