You can create and edit configuration groups of the software on this page. These can be considered as settings files that can be assigned to scheduled jobs and run arbitrarily to perform the actions appointed for them.

 

 

Page Configuration groups shows a list of groups (and buttons New, Save, Save as and Delete to manage them with) and details of the selected one - the list of  its configurations and group-level settings. These settings are shared by all the configurations in the group and can only be modified on this page.

 

Controls on panels Source and Target - concerning the source and target databases - have the same names and functions thus they are described here together.

 

Connection strings are the totality of parameters required to access an ODBC data source, apart from the name of the ODBC driver they may contain the location, address or name of the data source, a username, password and more. Pressing the button Connection string wizard makes building them easier. In connection strings you can use any of three references that point to three of the more commonly used directories of the system or the user currently logged in, 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.

 

You can verify a connection string and the current availability of the data source by clicking Test connection.

 

Contents of the input box Additional parameter correspond to the box with the same name shown if Show advanced settings is unchecked and can be accessed as constants sourceAdditionalParameter and targetAdditionalParameter (of the source and target databases, respectively) from Visual Basic code on pages VB code (1; 6), VB code on source data (4) and Own VB functions. These parameters are not used anywhere else.

 

Checkboxes below Fields enabled on basic settings page determine which input fields should be accessible on the interface displayed when Show advanced settings is off. Setting this up correctly - deactivating parameters not used by the current ODBC driver - can make the simple view more comprehensible.

 

The list on panel Configurations shows configurations belonging to the group currently open. You can manipulate these by using the buttons on the right and the windows brought up by them. Executing configuration groups means the execution of configurations created here. They run on multiple threads (see the description of the Job scheduler) in the order seen in the list but this alone does not guarantee the actual order of execution because of parallelity and different runtimes. If you would like to set up dependencies between configurations - ensuring that one only runs after the previous one has finished with the expected results (with or without errors) - check Do not run before the following configuration finished execution and select the configuration to be used as prerequisite, as well as whether its execution should end successfully, unsuccessfully or any of this two to allow the execution of the currently edited one.

 

Adding new configurations and editing existing ones can be performed in this window after clicking (Configurations groupbox) the corresponding buttons.

 

Select Show advanced settings to get to the view displaying all the features and settings of pages Configuration groups and Job scheduler. Unchecking it reverts to a significantly simplified version of page Configuration groups that only allows changing the important parameters of existing groups' connection strings as well as hides the panel Miscellaneous on page Job scheduler.