Click Connection tab to adjust these settings.

 

 

Source

Here you can see the ODBC connection string used to access the source database (it can be modified on group-level). Here you can use any of three references that point to three of the more commonly used directories of the system or the currently logged in user, these are: ${windows}, ${temp} and ${myDocuments}. The software will substitute these with the path of the computer's Windows directory and the user's Temp and My Documents directories when using the connection string.

 

Connection timeout is the timeout (in seconds) used for connection attempts to the source database and for commands issued on it.

 

Click Test connection to verify that the connection string is correct and the data source is online. When done, press Refresh database structure to get a list of tables and views on the source database. Select the Table/view containing data you want to work with.

 

Filter can be a Transact-SQL expression that could be used in a WHERE clause when querying the source table or view. If, for example, the source table has a column named ID containing whole numbers and you would like rows with an ID below 100 to be excluded from data transfer, type [ID] >= 100 in this field to keep unwanted records from being loaded.

 

Lists by Auxiliary tables allow you to select tables of the source database so their contents can be accessed on pages Data transfer (3), VB code (1; 6) or VB code on source data (4) (they are, however, not yet accessible from code executed before data transfer as they will only be read after that step). These tables are loaded right before data transfer starts and are available from VB code in Dictionary(Of String, DataTable) object auxiliaryTables using their names as keys (e.g. auxiliaryTables("firstAuxiliaryTable")) or queried on page Data transfer (3) using command AUXTBL.

AuxiliaryTables contains eight predefined, empty tables by default named virtualTable1, ..., virtualTable8, even if you haven't selected any auxiliary tables. These can be used and referenced in the same way as described above.

Warning: loading extraordinarily large auxiliary tables may take a long time and possibly lead to out of memory errors.

 

The value of Additional parameter is equal to that of the field with the same name seen when Show advanced settings is unchecked and can be accessed from Visual Basic code on pages VB code (1; 6), VB code on source data (4) and Own VB functions as constant sourceAdditionalParameter. This value is shared by every configuration of a group and cannot be edited here.

 

Target

Controls on page Target correspond to those with the same name on panel Source and can be used to supply information on the target database. Click Refresh database structure to fill fields on page Data transfer (3) with the appropriate values.

 

Clicking Table editor - after specifying the target connection string - brings up a simple editor with which you can view and manually edit the contents of tables of the target database. Updating and deleting records is only possible if given table includes a primary key. New records can be added to any table.

 

Contents of input box Additional parameter can be referenced from Visual Basic code as targetAdditionalParameter.