About parameterization
Parameterization is a way to dynamically configure connections and transformations based on input parameters. The input parameters can be global variables or flow variables.
Global Variables
Global variables are the key-value pairs that can either be set by JavaScript code or automatically when executing data integration flows.
Examples of global variables that are set automatically, when executing data integration flows:
Referencing Global Variables
To reference a global variable, use the following syntax: {variable name}.
The value of the variable must not be empty. When Etlworks Integrator replaces the {variable name} with an actual value, it ignores null and empty values.
Examples:
Input: http://host.com?startDate={stateDate}
Variable-value: startDate-null
Output: http://host.com?startDate={stateDate}
Input: http://host.com?startDate={stateDate}
Variable-value: startDate-""
Output: http://host.com?startDate={stateDate}
Input: http://host.com?startDate={stateDate}
Variable-value: startDate-today
Output: http://host.com?startDate=todayFlow Variables
- Flow variables are passed as URL parameters or URL variables to the user-created API endpoints.
- Flow variables are passed as URL parameters to the run flow by name API.
- Flow variables can also be defined when creating nested flows.
- Flow variables can be used in source and destination queries or accessed programmatically.
Types of parametrization
- Parameterization of the connections
- Parameterization of transformations
- Parameterization of file operations
- Parameterization of the source and destination queries
Converting flow variables to global variables
The flow variables can be used in source and destination queries or accessed programmatically.
They cannot be used to customize the connections or transformations.
Read how to convert the flow variables to the global variables and when doing so make sense.
Comments
0 comments
Please sign in to leave a comment.