Configuring External Database Access

The ESP server accesses external databases through data service definitions, which are managed and stored in separate databases for each cluster. Use the data services view in the SAP ESP Authoring perspective of SAP Event Stream Processor Studio to manage database service definitions for local and remote clusters.

You can create a data service either for a specific workspace, or make it available to all workspaces on the server.

If you have any database services saved in a streaming.xml file from ESP 5.1 SP04 or earlier, migrate them to the new data service format using the streamingclusterutil command line utility. See streamingclusterutil in the SAP Event Stream Processor: Utilities Guide.

Adapters that require database access obtain connections from the database manager, which stores data service connection information. When you are setting up a database adapter, specify the relevant data service name. For example, you can define a service for connecting to an SAP ASE database through JDBC, or to SQL Server through ODBC. At run time, the adapter obtains a connection from the database manager based on the properties in the data service, and executes queries over it.

For the server to communicate with external databases, you must have a working JDBC, ODBC, or Open Client connection. An installation of the ESP client includes a preconfigured ODBC driver manager. Otherwise, the appropriate JDBC or OCS driver for the desired external database must be installed manually.

The SAP HANA ODBC client must be installed to connect to an SAP HANA database. Use version 1.0.73 or later of the SAP HANA ODBC client.