This sample graph exposes an SAP HANA database through an OpenAPI server operator. A table name can be provided and the content of the table will be given as result.
The graph was tested with Data Hub version 2.4.
Before you start using the example, please make sure that:
- You are familiar with the basic concepts of SAP Data Hub Modeling such Pipelines (Graphs), Operators and Dockerfiles. For more information, you may refer to the Modeling Guide for SAP Data Hub that is available on the SAP Help Portal (https://help.sap.com/viewer/p/SAP_DATA_HUB).
- You are familiar with the basic concepts of Docker (https://docs.docker.com/get-started/) and Kubernetes (https://kubernetes.io/docs/concepts/overview/what-is-kubernetes/).
Sample graph
- Demonstrates a workflow where a HANA table is exposed via OpenAPI Server operator. In this case, user can query table via GET request.
- Import the sample graph
- Define a HANA connection in the Connection Management
- Change the 'SAP HANA Client' operator in the graph to use that HANA connection
- Start the graph
- To verify, go to the browser and execute below URL:
https://<vsystem-URL>/app/pipeline-modeler/openapi/service/samples/hanaServer/hana/{tablename}
For example
https://myhostname.com/app/pipeline-modeler/openapi/service/samples/hanaServer/hana/m_databases
https://myhostname.com/app/pipeline-modeler/openapi/service/samples/hanaServer/hana/sys.users
Additional information
Operator | Source Code |
---|---|
OpenAPI | swagger file |
Request JS | Request Code |
Response JS | Response Code |