Add data to spooled files via SQL

Add data to spooled files via SQL

If you want to add data from a database into a spooled file via SQL, then you should consider these options:

  1. Enrich spooled file from database workflow component inside your workflow.
  2. You can also consider to use the ng:databaseLookup function for a spooled file within a transformation. Here you can e.g. transform a spooled file into another spooled file and at the same time add extra data into a new attribute
  3. You can also add the extra SQL data into a spooled file line.
  4. You can even add data into a new, hidden attribute in the spooled file.
  5. After running this in the workflow you can refer to the extra data both in the workflow and in the designer and even save a copy of the changed contents with the To filesystem component.