Dynamic Filter Parameter in Sap Connector

Matteo Miele · 2024-02-08T06:44:51+00:00

There was an error rendering this rich post.

the idea is to make more parametrical the theobald sap connector.

right know is not possible to link a selection made at screen level (example with a selector) to the data reader allowing to reduce the dataset to be loaded.

so for example if we are loading large dataset the loading process will take a lot.

the parameter field in sap datareader procedure step is already available but not dynamic.

idea is to link to the entity of board data model, such for example:

@Parameter1=@BoardEntity

Find more posts tagged with

Open For Voting

Data Integration

Data Sources

Data Connectors

Data Reader

Status: Open For Voting

Comments

Helmut Heimann

although the example is missing, I appreciate your approach. Thought about the same a few minutes ago but you were first @Matteo Miele ;-)

The idea would be to make the connector more useful by applying the same possibilities as with an API call which already can utilize @selection_ex for example.

Currently, the SAP DataReader supports parameters only in a hard-coded way. Here's our howto-paper regarding this solution:

https://community.board.com/discussion/16869/how-to-set-parametric-where-clause-for-sap