Using the data services view in the Studio
SAP ESP Authoring perspective, create a service definition for an
ODBC connection to the database of your choice.
Prerequisites
- Install an ODBC driver. If you are running only
Studio on Linux, and have no other components of
ESP installed on the machine, also install
and configure the unixODBC driver manager, version 2.3.1. See Configuring an External unixODBC Driver Manager.
- Set up a connection to the ESP server.
Procedure
- In the data services view, right-click the SAP ESP
server, and select Load Workspaces.
- Choose a location, then right-click it and select Add ODBC
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.
- (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.
- 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.
- (Optional) Add a description of the database service in the
Description parameter.
- Set the ODBC DSN parameter to the data source name to be used by
your service. You should already have this data source set up with the ODBC
driver manager.
- (Optional) Select Connection to HANA database to set this database
service as an SAP HANA service entry.
If you select this checkbox, you can later establish a reference to a table in an external
SAP HANA database, using the CREATE REFERENCE
statement.
- 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.