T-Loader Screenshots

T-Loader

This is the main job creation and definition tool of the !Tsuite 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 existing jobs, edit job details, as well as execute jobs. Statistics are provided, including run dates and successful completions.

Step 1

This is where the user provides a meaningful name for the job and an extended description. 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 the destination database connectors. Database connectors can be traditional databases, CSV 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 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 there 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 allows you to flag this job to be seen by the T-Watcher and/or the T-Monitor function. Only jobs that have a CSV or spreadsheet as their source database are visible to T-Watcher and T-Monitor.