Consume SAP HANA Database OData Service

SAP HANA Database provides capability of exposing database table data as OData service.

General

The Consume SAP HANA Database OData Service activity helps you consume the OData services from TIBCO ActiveMatrix BusinessWorks. The following operations are supported by SAP HANA Database: GET, POST, PUT, and DELETE.

The following table lists the configurations in the General tab of the Consume SAP HANA Database OData Service activity:

Field Module Property Description
Name No The name to be displayed as the label for the activity in the process.
HANA OData Resource Yes Click to select a SAP HANA Database OData Connection shared resource.

If no matching SAP HANA Database OData Connection shared resource is found, click Create Shared Resource to create one. For more details, see Creating and Configuring the SAP HANA Database OData Connection Resource.

Entity No

Click to select an entity. The entities downloaded in selected SAP HANA Database OData Connection shared resource will be available for selection.

Service No Service corresponding to the selected Entity.
Operation No Select the operation. The operation visible depends on the type of the service.
Valid option examples: GET, PUT, POST, and DELETE.
Note: Underscores are used only for parameters. If the service name contains an underscore (_), the underscore is automatically removed from the displayed service name.

Description

In the Description tab enter a short description for the Consume SAP HANA Database OData Service activity.

Input

The input is generated based on the Service and the Operation selected by the user in the General tab.

The Input tab displays the input schema of the activity as a tree structure. The information in the schema varies based on the fields selected on the General tab. You must enter information as required for any mandatory fields.

For more information about SAP HANA Database datatype mapping to XSD mapping, see SAP HANA Database Datatype Mapping to XSD Mapping.

Output

The Output tab shows the response of the invoked service. The Output tab displays the output schema of the activity as a tree structure. The output is read-only. The information in the schema depends on the fields selected on the General tab.
Output Item Data Type Description
ResultCount Integer This ResultCount field from Output counts how many records are returned after the Consume SAP HANA Database OData Service activity is invoked.

Fault

The Fault tab lists exceptions that are thrown by this activity. The Consume SAP HANA Database OData Service activity throws the following exceptions:
  • SapHanaDatabaseODataSystemException: Thrown when the error originates from the SAP HANA Database system.
  • SapHanaDatabaseODataPluginException: Thrown when the error originates from the plug-in.
Error Schema Element Datatype Description
msg string The error message returned by the plug-in
msgCode string The error code returned by the plug-in
For more information, see Error Codes.