This example Data Stream demonstrates how to use this Context Provider to return data from the SAP HANA database table.
Drag the SAP HANA Context Provider Agent onto the canvas, link the output endpoint to the printer, and save the Data Stream.
Select the Agent and click Configure. Keep the default Collection and polling interval.
Enter the DSN and driver and the 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, rows to return, and sort order.
In this case, click '+' and add the filter Name Contains Seasonal. Leave rows to return as blank. Click '+' and add a sort by on OID in ascending order.
Apply the changes and save the Data Stream.
Let's look at the Live Data View. The filtered and sorted rows from the RS_TABLES_ table are printed.
SAP HANA Context Provider.xuc