Show TOC

Discovering a ServiceLocate this document in the navigation structure

Use the data services view in Studio to discover databases or tables from a data service.

Prerequisites

  • You have the permissions required to perform discovery on a data service:
    • privilege: execute
    • privilege-type: service
    • resource-type: service
    • resource: discovery
    Refer to the User Authorization Policies section of the SAP Event Stream Processor: Security Guide.
  • Set up a connection to the ESP server.

Context

In order to use discovery, start a local cluster in the background during ESP perspective activation. When you start the local cluster, you may see projects that have run previously in other Studio sessions, because of the persistence feature.

If you have database definitions in a service.xml file from previous versions of ESP, migrate them to the data services format using the service.xml migration command of the streamingclusterutil command line utility.

Procedure

  1. In Studio, open the SAP ESP Authoring perspective.
  2. In the data services view, right-click the SAP ESP server, and select Load Workspaces.
  3. Right-click on the appropriate workspace, and select Load Services.
  4. Right-click on a data service, and select Discover.

  5. Right-click on the either the Schemas or Models folder, and select Discover to activate schema and key discovery, or machine-learning model discovery.
    • Dependent on a combination of database, connectivity and adapter details, some tables do not support schema discovery. In this case, key discovery results only will be displayed.
    • Activation of cluster discovery services may be in progress when you try to perform a discovery operation. If so, check the SAP ESP Run-Test perspective to verify that the local host is connected.
    • You may be prompted to set an SAP HANA service entry if it has not already been set.