List SQL Records

With this node you can list records from a database by running an SQL query.

It has the following configuration options:
  • SQL Query: here you can specify the SQL query to execute to obtain the list of records you want.
  • Database URL: here you can specify the JDBC URL where the database can be reached.
  • User Name: here you can specify the user name to use while logging in to the database.
  • Password: here you can specify the password to use while logging in to the database.
  • JSON Output: here you can specify where to save the JSON data. Options:
    • If you leave this field blank, the data will be sent to a container in the database and no physical file will be created.
    • If you define an absolute CLOUDFLOW URL (cloudflow://..., see Server URL for more information), containing a file name and an extension, a physical output file with the specified file name will be created.
  • Overwrite existing file: if you select this checkbox, files that already exist will be overwritten. If you leave this checkbox unselected, existing files will not be overwritten and an error is displayed.
Note: Make sure to add/enable the QUANTUM JAVA Worker to see this node.