Example
This example Data Stream demonstrates how to use this Function to filter and sort the contents of a table in SAP HANA System, based on the specified filter criteria and sort order.
Refer to configuration to understand all configuration options of this Agent.
Step 1: Add the Agent
Drag the SAP HANA Function Agent onto the canvas. Link the input endpoint to the filters data, the output to the printer, and rename the Agent. Save the Data Stream.
Step 2: Configure General
Select the Agent and click Configure. Keep the default Collection.
Step 3: Configure Connection Details
Enter the DNS, driver, and authentication details: server, port, username, and password.
Step 4: Object Details
Select the database, schema, table, and columns to return. In this case, set the database to HXE, the schema to SYS, and the table to RS_TABLES_. Select all columns to be returned.
Step 5: Configure Filtering & Sorting
Specify the filter criteria. In this case, click '+' and add the filter Name like Filters.
Our example does not require a limited result or sorting, so leave rows to return and sort order blank.
Apply the changes and save the Data Stream.
Step 6: Results
Click Publish.
Let's look at the Live Data View. The RS_TABLES_ table is queried for each incoming event's filters, and the details are printed.
Files
See the Import, Export, and Clone - XMPro article for steps to import a Data Stream.
Last updated
