SQL Lookup


Returns results of executing an SQL query.

The SQL Lookup function configuration requires the user to specify a JDBC connection in Hero Platform_, add dynamic values, output fields, and type an SQL query.


  • Select an argument. (Any)
  • Optional: Select additional arguments. (Any)
  • Enter an output field name.
    • Select a data type. (Any)
  • Select a JDBC connection in Hero Platform_.
  • Enter an SQL query string.
  • Enter the query timeout value. (Seconds)
    • Query statements that are not completed by the timeout value are canceled.
    • The value of "0" disables the query timeout feature.
  • Click OK.