Options
Global Variables
Global Variables are used to replace Variable with Value, for example before input form is shown to the user <CustomerId> will be replaced with 1
EG
Select * from Customers where CustomerId = <CustomerId>
Is changed to
Select * from Customers where CustomerId = 1
Predefined variables:
<ATEUserName> <username> OS user name <computername> <datetime>
Note:
Works only with input forms SQL.
For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions
Confused? Ask question on our ETL Forum