Data transfer - Source / Target - Groovy script

You can reach this dialog in the following ways:
Integration module Data transfer / Create new connection Data source type: Groovy script, Continue to Source - Groovy script
Integration module Data transfer / Create new connection Target type: Groovy script, Continue to Target - Groovy script

Script file

First, select the storage location for the script file. Here the directory portal directory internal/cfg/datatransfer/scripts/ will be automatically suggested for the location of the new script file. Additionally, Intrexx will generate a unique file name, consisting of the character string "Src" (source) or "Dst" (destination) and a GUID with the ending .groovy. If you prefer a different save location, please note that the directory must be reachable from the server. Furthermore, the selected file name must be unique in the portal.

Select file
Opens a dialog where the file can be selected.

Open Intrexx editor
Opens the Intrexx Groovy script editor.

Open external editor
This link is available if the path to an external editor has been defined in the Extras menu / Options / General settings / Editor settings.

Time zone

The desired time zone can be selected for date values.

If you want to access column names using "getValue()" and "setValue()", they must be entered corresponding to the database using capital and lower-case letters. Please take note of the conventions from your database here.