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.
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.
Select the Agent and click Configure. Keep the default Collection.
Enter the DNS, driver, and authentication details: server, port, username, and password.
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.
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.
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.
File | Link | Security Key |
|---|---|---|
Data Stream | SAP HANA Data Filter.xuc | C0mp|ex123 |
Sample Data | Filters.csv | |