Show TOC

Adding an ODBC Connection to an External DatabaseLocate this document in the navigation structure

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

  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 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.
  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. 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.
  7. (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.
  8. 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.