T-Loader

This is the main job creation and designer of the T-Suite Product

Main Screen

From this screen the user can filter what jobs they wish to look at and which jobs they wish to work on.

The user can create new jobs, delete exiting job, edit the job details and / or execute the jobs for processing. Statistics are provided for run dates, and successful completions.

Step 1

This is where the user provides a meaningful name for the job and an extended descriptions.

Optionally the user can choose a group and sub-group category for future filtering.

Step 2

This is where the user defines both the source and destination database connectors.

Database connectors can be traditional databases, Comma Separated Variable text files or an XML file.

Step 3

This is where the source pull can be modified to meet the job's requirements. Any valid SQL statement can be used to isolate the number and types of rows requested for processing.

Step 4

Further processing can be done at the column level to isolate columns for additional processing. This is very useful when one column may contain more compartmentalized data within it.

Step 5

This step allows for the setting of default values, forcing elements to be required and further definition of column type of data.

Step 6

This step is where all the previous steps join to provide the commands to be fed to the destination database. You will notice that their are 4 tabs.

• Conditional test. The question must come back with a true or false (0,1)
• Execute if true. This block of SQL will be executed if the condition test comes back true.
• Execute if false. This block of SQL will be executed if the condition test comes back false.
• Execute always. This block of SQL will be executed regardless of the value of the condition test in tab ONE.

Step 7

This final step allow you to flag this job to be seen by the T-Watcher function and/or the T-Monitor function. Only jobs that have a CSV or Spreadsheet source database source are visible to T-Watcher and T-Monitor.