Data transfer - Data source / Target "Groovy script"

Here you will find the instructions for configuring a data transfer if you selected "Groovy script" as the type of the data source or the type of the data destination in the first step when creating the connection.

Source / Target - Groovy script

Script file

First, select the storage location for the script file. The portal directory "internal/cfg/datatransfer/scripts/" is automatically suggested here. Additionally, Intrexx generates a unique filename, consisting of the character string Src (source) or Dst (destination/target) and a GUID with the extension .groovy. If you prefer a different save location, please note that the directory must be reachable from the server. The selected filename 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 displayed if the path to an external editor is entered via the main menu "Extras / Options / General / 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()" with Groovy, the column names must be entered corresponding to the database using capital and lower-case letters. Please take note of the conventions from your database here.

Click "Next" to complete the configuration of the connection.

More information

Data transfer

Creating a connection

Target options

Transformation field assignment

Schedule

Subsequent jobs

"Data transfer" application