Use of Input Multipliers to insert values into DB collector where clause.

Scenario

Data is stored in a database, sometimes in massive volumes, where we only need to process a tiny subset of the data. Instead of processing the entire database table, collect a small subset of the data only, based on a variable value

Create a DB collector to retrieve data from a database. This collector should have a "where" clause in it, and the value of that where clause - the value being looked up, will be set automatically in PhixFlow.

Solution:

• Create a database collector to load some data into a stream in PhixFlow
• Create an Input Multiplier on that stream.
• Reference the Input Multiplier value(s) in the collector's SQL query using the {} or {=} notation .

See Also

• href="../../../../../../doc/training/Exercises.pdf">Patterns and Exercise Training Document
• href="http://www.phixflow-online.com:8081/patterns">PhixFlow Online Patterns and Training