Configuring Options at Runtime - 23.1

Spectrum Dataflow Designer Guide

Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Dataflow Designer Guide
First publish date
2007
Last updated
2024-05-09
Published on
2024-05-09T23:01:03.226155

Table Lookup options can be configured and passed at runtime if they are exposed as dataflow options. This enables you to override the existing configuration with JSON-formatted strings. You can also set stage options when calling the job through a process flow or through the job executor command-line tool.

You can find a schema for LookupRule in the following folder:

<Spectrum Location>\server\modules\jsonSchemas\tableLookup

To define Table Lookup rules at runtime:

  1. In Enterprise Designer, open a dataflow that uses the Table Lookup stage.
  2. Save and expose that dataflow.
  3. Go to Edit > Dataflow Options.
  4. In the Map dataflow options to stages table, expand Table Lookup. Check the box for LookupRule.
  5. Optional: Change the name of the options in the Option label field.
  6. Click OK twice.