Created by Miki Yanagi, last modified on Aug 30, 2019
Generated documentation
Jobs
Generated by Talend Open Studio for Data Integration


Project NameFN_StagingGENERATION DATEAug 26, 2019 10:00:39 AM
AUTHORuser@talend.comTalend Open Studio VERSION 7.1.1.20181026_1147

Summary

Project Description
Description
Preview Picture
Settings
Context List
Component List
Components Description


Project Description


PropertiesValues
NameFN_Staging
Languagejava
Description


Description


PropertiesValues
NameFNS00_dbConnect
Authoruser@talend.com
Version1.0
Purpose
Status
Description
CreationJul 17, 2019 2:28:20 PM
ModificationAug 26, 2019 9:11:08 AM

Preview Picture


No image available
tDBConnection_1tDBConnection_2tDBConnection_3tDie_1tDie_2tDie_3tJavaFlex_1tJavaFlex_2tJavaFlex_3tJava_1tJava_10tJava_2tJava_3tJava_4tJava_5tJava_6tJava_7tJava_8tJava_9tLogCatcher_1tLoop_1tLoop_2tLoop_3tMap_1tSendMail_5tSetGlobalVar_1

Settings

Extra settings

NameValue
COMP_DEFAULT_FILE_DIR
Multi thread executionfalse
Implicit tContextLoadfalse


Status & Logs

NameValue
Use statistics (tStatCatcher)true
Use logs (tLogCatcher)false
Use volumetrics (tFlowMeterCatcher)true
On Consoletrue
On Filesfalse
On Databasestrue
Property Type
PropertyREPOSITORY
Property:sourceDI_CNTL
Db TypetMSSqlOutput
Hostcontext.DI_CNTL_Server
Portcontext.DI_CNTL_Port
Db Name context.DI_CNTL_Database
Additional parameterscontext.DI_CNTL_AdditionalParams
Schemacontext.DI_CNTL_Schema
Usercontext.DI_CNTL_Login
Password ************************
Datasource""
Logs Table"cntl_logCatcher"
Meter Table"cntl_flowMeter"
Stats Table"cntl_statCatcher"
Catch components statisticstrue
Catch runtime errorstrue
Catch user errorstrue
Catch user warningstrue


Context List

ContextDefault

NamePromptNeed Prompt?TypeValueSource
DI_CNTL_SchemaDI_CNTL_Schema?falseid_StringdboDI_CNTL_Context
DI_CNTL_LoginDI_CNTL_Login?falseid_StringsaDI_CNTL_Context
DI_CNTL_ServerDI_CNTL_Server?falseid_StringlocalhostDI_CNTL_Context
DI_CNTL_DatabaseDI_CNTL_Database?falseid_StringDI_CNTLDI_CNTL_Context
DI_CNTL_PasswordDI_CNTL_Password?falseid_Password********DI_CNTL_Context
DI_CNTL_PortDI_CNTL_Port?falseid_String1433DI_CNTL_Context
DI_CNTL_AdditionalParamsDI_CNTL_AdditionalParams?falseid_StringDI_CNTL_Context
FNContext_ServerFNContext_Server?falseid_Stringfndev.db.its.maine.eduFNContext
FNContext_ServiceNameFNContext_ServiceName?falseid_StringFNDEVFNContext
FNContext_SchemaFNContext_Schema?falseid_StringSYSADMFNContext
FNContext_PortFNContext_Port?falseid_String1521FNContext
FNContext_PasswordFNContext_Password?falseid_Password**********FNContext
FNContext_AdditionalParamsFNContext_AdditionalParams?falseid_StringFNContext
FNContext_LoginFNContext_Login?falseid_StringDARTSFNContext
SSS_Context_AdditionalParamsSSS_Context_AdditionalParams?falseid_StringSS_Staging_Context
SSS_Context_PasswordSSS_Context_Password?falseid_Password********SS_Staging_Context
SSS_Context_DatabaseSSS_Context_Database?falseid_StringTalendStagingSS_Staging_Context
SSS_Context_LoginSSS_Context_Login?falseid_StringsaSS_Staging_Context
SSS_Context_PortSSS_Context_Port?falseid_String1433SS_Staging_Context
SSS_Context_SchemaSSS_Context_Schema?falseid_StringdboSS_Staging_Context
SSS_Context_ServerSSS_Context_Server?falseid_StringlocalhostSS_Staging_Context
tsendMailUsernametsendMailUsername?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailPasswordtsendMailPassword?falseid_Password****tsendMail_Context
tsendMailCctsendMailCc?falseid_StringnulltsendMail_Context
tsendMailSMTPPorttsendMailSMTPPort?falseid_String465tsendMail_Context
tsendMailSubject_FailuretsendMailSubject_Failure?falseid_String"*** ERROR *** Talend Job " +((String)globalMap.get("vErrorJob")) +" (" +((String)globalMap.get("vErrorJobPID")) +") *** Failed ***"tsendMail_Context
tsendMailToFailuretsendMailToFailure?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu;tsendMail_Context
tsendMailMessage_FailuretsendMailMessage_Failure?falseid_StringtsendMail_Context
tsendMailSMTPHosttsendMailSMTPHost?falseid_Stringsmarthost.maine.edutsendMail_Context
tsendMailToSuccesstsendMailToSuccess?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu;tsendMail_Context
tsendMailSubjecttsendMailSubject?falseid_StringtsendMail_Context
tsendMailMessagetsendMailMessage?falseid_StringtsendMail_Context
tsendMailSubject_SuccesstsendMailSubject_Success?falseid_StringtsendMail_Context
tsendMailFromtsendMailFrom?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailBcctsendMailBcc?falseid_StringnulltsendMail_Context
tsendMailMessage_SuccesstsendMailMessage_Success?falseid_StringtsendMail_Context
FY_StartFY_Start?falseid_Integer2020FN_Specific_Contexts
FY_EndFY_End?falseid_Integer9999FN_Specific_Contexts
TGT_Schema_8TGT_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_9TGT_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_2TGT_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_3TGT_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_1TGT_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_6TGT_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_7TGT_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_4TGT_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_5TGT_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsTotal_10TGT_RowsTotal_10?falseid_Integer0General_Job_Contexts
TGT_SOR_SK_10TGT_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsUpdated_10TGT_RowsUpdated_10?falseid_Integer0General_Job_Contexts
TGT_TableName_9TGT_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_8TGT_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_5TGT_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_4TGT_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_7TGT_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_6TGT_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
ThreadTimeThreadTime?falseid_Integer3000General_Job_Contexts
TGT_TableRowCount_Before_1TGT_TableRowCount_Before_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_2TGT_TableRowCount_Before_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_3TGT_TableRowCount_Before_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_4TGT_TableRowCount_Before_4?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_5TGT_TableRowCount_Before_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_6TGT_TableRowCount_Before_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_7TGT_TableRowCount_Before_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_8TGT_TableRowCount_Before_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_9TGT_TableRowCount_Before_9?falseid_Integer0General_Job_Contexts
SRC_Table_DI_Purpose_10SRC_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_1TGT_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_3TGT_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_2TGT_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_10TGT_RowsRejected_10?falseid_Integer0General_Job_Contexts
SRC_Schema_10SRC_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_3SRC_Query_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_2SRC_Query_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_1TGT_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_5SRC_Query_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_4SRC_Query_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_7SRC_Query_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_4TGT_Database_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_6SRC_Query_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_5TGT_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_9SRC_Query_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_2TGT_Database_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_8SRC_Query_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_3TGT_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_8TGT_Database_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_9TGT_Database_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_6TGT_Database_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_7TGT_Database_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_10SRC_Table_No_10?falseid_Integer1General_Job_Contexts
TGT_Table_DI_Purpose_10TGT_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
LoopCounterLoopCounter?falseid_Integer0General_Job_Contexts
SRC_Query_1SRC_Query_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_8TGT_RowsInserted_8?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_9TGT_RowsInserted_9?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_6TGT_RowsInserted_6?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_7TGT_RowsInserted_7?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_4TGT_RowsInserted_4?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_5TGT_RowsInserted_5?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_2TGT_RowsInserted_2?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_3TGT_RowsInserted_3?falseid_Integer0General_Job_Contexts
SRC_TableName_10SRC_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_10TGT_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_1TGT_RowsInserted_1?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_2TGT_RowsRejected_2?falseid_Integer0General_Job_Contexts
TGT_Server_10TGT_Server_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_3TGT_RowsRejected_3?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_4TGT_RowsRejected_4?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_5TGT_RowsRejected_5?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_6TGT_RowsRejected_6?falseid_Integer0General_Job_Contexts
TGT_Database_10TGT_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_7TGT_RowsRejected_7?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_8TGT_RowsRejected_8?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_9TGT_RowsRejected_9?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_10SRC_TableRowCount_10?falseid_Integer0General_Job_Contexts
SRC_Table_No_1SRC_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_RowsRejected_1TGT_RowsRejected_1?falseid_Integer0General_Job_Contexts
ContinueLoopContinueLoop?falseid_BooleanfalseGeneral_Job_Contexts
TGT_SOR_SK_2TGT_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_3TGT_SOR_SK_3?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_1TGT_SOR_SK_1?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_6TGT_SOR_SK_6?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_7TGT_SOR_SK_7?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_4TGT_SOR_SK_4?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_5TGT_SOR_SK_5?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_8TGT_SOR_SK_8?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_9TGT_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_Server_6SRC_Server_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_3SRC_Table_No_3?falseid_Integer1General_Job_Contexts
SRC_Server_5SRC_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_2SRC_Table_No_2?falseid_Integer1General_Job_Contexts
SRC_Server_8SRC_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_5SRC_Table_No_5?falseid_Integer1General_Job_Contexts
SRC_Server_7SRC_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_4SRC_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_Server_2SRC_Server_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_7SRC_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Server_1SRC_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_6SRC_Table_No_6?falseid_Integer1General_Job_Contexts
SRC_Server_4SRC_Server_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_9SRC_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Server_3SRC_Server_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_8SRC_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Server_9SRC_Server_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_SOR_SK_10SRC_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsInserted_10TGT_RowsInserted_10?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_8TGT_RowsUpdated_8?falseid_Integer0General_Job_Contexts
SRC_Database_10SRC_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_7TGT_RowsUpdated_7?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_9TGT_RowsUpdated_9?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_4TGT_RowsUpdated_4?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_3TGT_RowsUpdated_3?falseid_Integer0General_Job_Contexts
SRC_TableName_9SRC_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_6TGT_RowsUpdated_6?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_5TGT_RowsUpdated_5?falseid_Integer0General_Job_Contexts
SRC_TableName_7SRC_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_8SRC_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_5SRC_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_2TGT_RowsUpdated_2?falseid_Integer0General_Job_Contexts
SRC_TableName_6SRC_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_1TGT_RowsUpdated_1?falseid_Integer0General_Job_Contexts
SRC_TableName_3SRC_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_4SRC_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_10TGT_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_1SRC_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_2SRC_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_9SRC_Database_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_2SRC_Database_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_9TGT_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Database_1SRC_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_4SRC_Database_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_7TGT_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Database_3SRC_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_8TGT_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Database_6SRC_Database_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_5SRC_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_8SRC_Database_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_7SRC_Database_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_1TGT_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_Table_No_2TGT_Table_No_2?falseid_Integer1General_Job_Contexts
TGT_Table_No_5TGT_Table_No_5?falseid_Integer1General_Job_Contexts
TGT_Table_No_6TGT_Table_No_6?falseid_Integer1General_Job_Contexts
TGT_Table_No_3TGT_Table_No_3?falseid_Integer1General_Job_Contexts
TGT_Table_No_4TGT_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_7SRC_SOR_SK_7?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_8SRC_SOR_SK_8?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_9SRC_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_2SRC_TableRowCount_2?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_1SRC_TableRowCount_1?falseid_Integer0General_Job_Contexts
TGT_Table_No_10TGT_Table_No_10?falseid_Integer1General_Job_Contexts
LoopInterationsLoopInterations?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_3SRC_SOR_SK_3?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_4SRC_TableRowCount_4?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_4SRC_SOR_SK_4?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_3SRC_TableRowCount_3?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_5SRC_SOR_SK_5?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_6SRC_TableRowCount_6?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_6SRC_SOR_SK_6?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_5SRC_TableRowCount_5?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_1SRC_SOR_SK_1?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_2SRC_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_TableRowCount_After_9TGT_TableRowCount_After_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_5TGT_TableRowCount_After_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_6TGT_TableRowCount_After_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_7TGT_TableRowCount_After_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_8TGT_TableRowCount_After_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_1TGT_TableRowCount_After_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_2TGT_TableRowCount_After_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_3TGT_TableRowCount_After_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_4TGT_TableRowCount_After_4?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_8SRC_TableRowCount_8?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_7SRC_TableRowCount_7?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_9SRC_TableRowCount_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_1TGT_RowsTotal_1?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_4TGT_RowsTotal_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_7TGT_RowsDeleted_7?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_5TGT_RowsTotal_5?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_8TGT_RowsDeleted_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_2TGT_RowsTotal_2?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_5TGT_RowsDeleted_5?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_3TGT_RowsTotal_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_6TGT_RowsDeleted_6?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_8TGT_RowsTotal_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_9TGT_RowsTotal_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_6TGT_RowsTotal_6?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_9TGT_RowsDeleted_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_10TGT_TableRowCount_After_10?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_7TGT_RowsTotal_7?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_3TGT_RowsDeleted_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_4TGT_RowsDeleted_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_1TGT_RowsDeleted_1?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_2TGT_RowsDeleted_2?falseid_Integer0General_Job_Contexts
TGT_Server_2TGT_Server_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_3TGT_Server_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_4TGT_Server_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_5TGT_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_8SRC_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_7SRC_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_9SRC_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_1TGT_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_4SRC_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_3SRC_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_6SRC_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_5SRC_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_6TGT_Server_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_7TGT_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_2SRC_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_8TGT_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_1SRC_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_9TGT_Server_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableRowCount_Before_10TGT_TableRowCount_Before_10?falseid_Integer0General_Job_Contexts
SRC_Schema_7SRC_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_8SRC_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsDeleted_10TGT_RowsDeleted_10?falseid_Integer0General_Job_Contexts
SRC_Schema_9SRC_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Server_10SRC_Server_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_3SRC_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_4SRC_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_5SRC_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_6SRC_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_1SRC_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_2SRC_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_1TGT_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_2TGT_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_3TGT_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_4TGT_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_10SRC_Query_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_5TGT_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_6TGT_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_7TGT_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_8TGT_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_9TGT_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts


ContextDEV

NamePromptNeed Prompt?TypeValueSource
FNContext_LoginFNContext_Login?falseid_StringDARTSFNContext
FNContext_ServerFNContext_Server?falseid_Stringfndev.db.its.maine.eduFNContext
FNContext_PortFNContext_Port?falseid_String1521FNContext
FNContext_AdditionalParamsFNContext_AdditionalParams?falseid_StringFNContext
FNContext_SchemaFNContext_Schema?falseid_StringSYSADMFNContext
FNContext_ServiceNameFNContext_ServiceName?falseid_StringFNDEVFNContext
FNContext_PasswordFNContext_Password?falseid_Password**********FNContext
SSS_Context_AdditionalParamsSSS_Context_AdditionalParams?falseid_StringSS_Staging_Context
SSS_Context_PasswordSSS_Context_Password?falseid_Password**********SS_Staging_Context
SSS_Context_DatabaseSSS_Context_Database?falseid_StringUMS_STAGING_DEVSS_Staging_Context
SSS_Context_LoginSSS_Context_Login?falseid_StringPS_TO_DMSS_Staging_Context
SSS_Context_PortSSS_Context_Port?falseid_String1433SS_Staging_Context
SSS_Context_SchemaSSS_Context_Schema?falseid_StringdboSS_Staging_Context
SSS_Context_ServerSSS_Context_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduSS_Staging_Context
DI_CNTL_SchemaDI_CNTL_Schema?falseid_StringdboDI_CNTL_Context
DI_CNTL_LoginDI_CNTL_Login?falseid_StringPS_TO_DMDI_CNTL_Context
DI_CNTL_ServerDI_CNTL_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduDI_CNTL_Context
DI_CNTL_DatabaseDI_CNTL_Database?falseid_StringUMS_DI_CNTL_DEVDI_CNTL_Context
DI_CNTL_PasswordDI_CNTL_Password?falseid_Password**********DI_CNTL_Context
DI_CNTL_PortDI_CNTL_Port?falseid_String1433DI_CNTL_Context
DI_CNTL_AdditionalParamsDI_CNTL_AdditionalParams?falseid_StringDI_CNTL_Context
tsendMailUsernametsendMailUsername?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailPasswordtsendMailPassword?falseid_Password****tsendMail_Context
tsendMailCctsendMailCc?falseid_StringnulltsendMail_Context
tsendMailSMTPPorttsendMailSMTPPort?falseid_String465tsendMail_Context
tsendMailSubject_FailuretsendMailSubject_Failure?falseid_String"*** ERROR *** Talend Job " +((String)globalMap.get("vErrorJob")) +" (" +((String)globalMap.get("vErrorJobPID")) +") *** Failed ***"tsendMail_Context
tsendMailToFailuretsendMailToFailure?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu; asgeir.whitney@maine.edu; gary.blake@maine.edutsendMail_Context
tsendMailMessage_FailuretsendMailMessage_Failure?falseid_StringtsendMail_Context
tsendMailSMTPHosttsendMailSMTPHost?falseid_Stringsmarthost.maine.edutsendMail_Context
tsendMailToSuccesstsendMailToSuccess?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu; asgeir.whitney@maine.edu; gary.blake@maine.edutsendMail_Context
tsendMailSubjecttsendMailSubject?falseid_StringtsendMail_Context
tsendMailMessagetsendMailMessage?falseid_StringtsendMail_Context
tsendMailSubject_SuccesstsendMailSubject_Success?falseid_StringtsendMail_Context
tsendMailFromtsendMailFrom?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailBcctsendMailBcc?falseid_StringnulltsendMail_Context
tsendMailMessage_SuccesstsendMailMessage_Success?falseid_StringtsendMail_Context
FY_StartFY_Start?falseid_Integer2006FN_Specific_Contexts
FY_EndFY_End?falseid_Integer9999FN_Specific_Contexts
TGT_Schema_8TGT_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_9TGT_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_2TGT_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_3TGT_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_1TGT_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_6TGT_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_7TGT_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_4TGT_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_5TGT_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsTotal_10TGT_RowsTotal_10?falseid_Integer0General_Job_Contexts
TGT_SOR_SK_10TGT_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsUpdated_10TGT_RowsUpdated_10?falseid_Integer0General_Job_Contexts
TGT_TableName_9TGT_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_8TGT_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_5TGT_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_4TGT_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_7TGT_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_6TGT_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
ThreadTimeThreadTime?falseid_Integer3000General_Job_Contexts
TGT_TableRowCount_Before_1TGT_TableRowCount_Before_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_2TGT_TableRowCount_Before_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_3TGT_TableRowCount_Before_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_4TGT_TableRowCount_Before_4?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_5TGT_TableRowCount_Before_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_6TGT_TableRowCount_Before_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_7TGT_TableRowCount_Before_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_8TGT_TableRowCount_Before_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_9TGT_TableRowCount_Before_9?falseid_Integer0General_Job_Contexts
SRC_Table_DI_Purpose_10SRC_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_1TGT_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_3TGT_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_2TGT_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_10TGT_RowsRejected_10?falseid_Integer0General_Job_Contexts
SRC_Schema_10SRC_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_3SRC_Query_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_2SRC_Query_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_1TGT_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_5SRC_Query_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_4SRC_Query_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_7SRC_Query_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_4TGT_Database_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_6SRC_Query_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_5TGT_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_9SRC_Query_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_2TGT_Database_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_8SRC_Query_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_3TGT_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_8TGT_Database_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_9TGT_Database_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_6TGT_Database_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_7TGT_Database_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_10SRC_Table_No_10?falseid_Integer1General_Job_Contexts
TGT_Table_DI_Purpose_10TGT_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
LoopCounterLoopCounter?falseid_Integer0General_Job_Contexts
SRC_Query_1SRC_Query_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_8TGT_RowsInserted_8?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_9TGT_RowsInserted_9?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_6TGT_RowsInserted_6?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_7TGT_RowsInserted_7?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_4TGT_RowsInserted_4?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_5TGT_RowsInserted_5?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_2TGT_RowsInserted_2?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_3TGT_RowsInserted_3?falseid_Integer0General_Job_Contexts
SRC_TableName_10SRC_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_10TGT_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_1TGT_RowsInserted_1?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_2TGT_RowsRejected_2?falseid_Integer0General_Job_Contexts
TGT_Server_10TGT_Server_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_3TGT_RowsRejected_3?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_4TGT_RowsRejected_4?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_5TGT_RowsRejected_5?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_6TGT_RowsRejected_6?falseid_Integer0General_Job_Contexts
TGT_Database_10TGT_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_7TGT_RowsRejected_7?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_8TGT_RowsRejected_8?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_9TGT_RowsRejected_9?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_10SRC_TableRowCount_10?falseid_Integer0General_Job_Contexts
SRC_Table_No_1SRC_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_RowsRejected_1TGT_RowsRejected_1?falseid_Integer0General_Job_Contexts
ContinueLoopContinueLoop?falseid_BooleanfalseGeneral_Job_Contexts
TGT_SOR_SK_2TGT_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_3TGT_SOR_SK_3?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_1TGT_SOR_SK_1?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_6TGT_SOR_SK_6?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_7TGT_SOR_SK_7?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_4TGT_SOR_SK_4?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_5TGT_SOR_SK_5?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_8TGT_SOR_SK_8?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_9TGT_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_Server_6SRC_Server_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_3SRC_Table_No_3?falseid_Integer1General_Job_Contexts
SRC_Server_5SRC_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_2SRC_Table_No_2?falseid_Integer1General_Job_Contexts
SRC_Server_8SRC_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_5SRC_Table_No_5?falseid_Integer1General_Job_Contexts
SRC_Server_7SRC_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_4SRC_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_Server_2SRC_Server_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_7SRC_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Server_1SRC_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_6SRC_Table_No_6?falseid_Integer1General_Job_Contexts
SRC_Server_4SRC_Server_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_9SRC_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Server_3SRC_Server_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_8SRC_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Server_9SRC_Server_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_SOR_SK_10SRC_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsInserted_10TGT_RowsInserted_10?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_8TGT_RowsUpdated_8?falseid_Integer0General_Job_Contexts
SRC_Database_10SRC_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_7TGT_RowsUpdated_7?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_9TGT_RowsUpdated_9?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_4TGT_RowsUpdated_4?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_3TGT_RowsUpdated_3?falseid_Integer0General_Job_Contexts
SRC_TableName_9SRC_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_6TGT_RowsUpdated_6?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_5TGT_RowsUpdated_5?falseid_Integer0General_Job_Contexts
SRC_TableName_7SRC_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_8SRC_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_5SRC_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_2TGT_RowsUpdated_2?falseid_Integer0General_Job_Contexts
SRC_TableName_6SRC_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_1TGT_RowsUpdated_1?falseid_Integer0General_Job_Contexts
SRC_TableName_3SRC_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_4SRC_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_10TGT_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_1SRC_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_2SRC_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_9SRC_Database_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_2SRC_Database_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_9TGT_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Database_1SRC_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_4SRC_Database_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_7TGT_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Database_3SRC_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_8TGT_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Database_6SRC_Database_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_5SRC_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_8SRC_Database_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_7SRC_Database_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_1TGT_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_Table_No_2TGT_Table_No_2?falseid_Integer1General_Job_Contexts
TGT_Table_No_5TGT_Table_No_5?falseid_Integer1General_Job_Contexts
TGT_Table_No_6TGT_Table_No_6?falseid_Integer1General_Job_Contexts
TGT_Table_No_3TGT_Table_No_3?falseid_Integer1General_Job_Contexts
TGT_Table_No_4TGT_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_7SRC_SOR_SK_7?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_8SRC_SOR_SK_8?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_9SRC_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_2SRC_TableRowCount_2?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_1SRC_TableRowCount_1?falseid_Integer0General_Job_Contexts
TGT_Table_No_10TGT_Table_No_10?falseid_Integer1General_Job_Contexts
LoopInterationsLoopInterations?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_3SRC_SOR_SK_3?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_4SRC_TableRowCount_4?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_4SRC_SOR_SK_4?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_3SRC_TableRowCount_3?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_5SRC_SOR_SK_5?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_6SRC_TableRowCount_6?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_6SRC_SOR_SK_6?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_5SRC_TableRowCount_5?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_1SRC_SOR_SK_1?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_2SRC_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_TableRowCount_After_9TGT_TableRowCount_After_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_5TGT_TableRowCount_After_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_6TGT_TableRowCount_After_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_7TGT_TableRowCount_After_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_8TGT_TableRowCount_After_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_1TGT_TableRowCount_After_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_2TGT_TableRowCount_After_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_3TGT_TableRowCount_After_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_4TGT_TableRowCount_After_4?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_8SRC_TableRowCount_8?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_7SRC_TableRowCount_7?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_9SRC_TableRowCount_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_1TGT_RowsTotal_1?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_4TGT_RowsTotal_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_7TGT_RowsDeleted_7?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_5TGT_RowsTotal_5?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_8TGT_RowsDeleted_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_2TGT_RowsTotal_2?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_5TGT_RowsDeleted_5?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_3TGT_RowsTotal_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_6TGT_RowsDeleted_6?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_8TGT_RowsTotal_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_9TGT_RowsTotal_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_6TGT_RowsTotal_6?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_9TGT_RowsDeleted_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_10TGT_TableRowCount_After_10?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_7TGT_RowsTotal_7?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_3TGT_RowsDeleted_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_4TGT_RowsDeleted_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_1TGT_RowsDeleted_1?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_2TGT_RowsDeleted_2?falseid_Integer0General_Job_Contexts
TGT_Server_2TGT_Server_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_3TGT_Server_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_4TGT_Server_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_5TGT_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_8SRC_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_7SRC_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_9SRC_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_1TGT_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_4SRC_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_3SRC_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_6SRC_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_5SRC_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_6TGT_Server_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_7TGT_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_2SRC_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_8TGT_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_1SRC_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_9TGT_Server_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableRowCount_Before_10TGT_TableRowCount_Before_10?falseid_Integer0General_Job_Contexts
SRC_Schema_7SRC_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_8SRC_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsDeleted_10TGT_RowsDeleted_10?falseid_Integer0General_Job_Contexts
SRC_Schema_9SRC_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Server_10SRC_Server_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_3SRC_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_4SRC_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_5SRC_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_6SRC_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_1SRC_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_2SRC_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_1TGT_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_2TGT_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_3TGT_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_4TGT_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_10SRC_Query_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_5TGT_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_6TGT_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_7TGT_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_8TGT_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_9TGT_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts


ContextPRD

NamePromptNeed Prompt?TypeValueSource
DI_CNTL_SchemaDI_CNTL_Schema?falseid_StringdboDI_CNTL_Context
DI_CNTL_LoginDI_CNTL_Login?falseid_StringPS_TO_DMDI_CNTL_Context
DI_CNTL_ServerDI_CNTL_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduDI_CNTL_Context
DI_CNTL_DatabaseDI_CNTL_Database?falseid_StringUMS_DI_CNTL_PRDDI_CNTL_Context
DI_CNTL_PasswordDI_CNTL_Password?falseid_Password**********DI_CNTL_Context
DI_CNTL_PortDI_CNTL_Port?falseid_String1433DI_CNTL_Context
DI_CNTL_AdditionalParamsDI_CNTL_AdditionalParams?falseid_StringDI_CNTL_Context
FNContext_ServerFNContext_Server?falseid_Stringfnprd.db.its.maine.eduFNContext
FNContext_ServiceNameFNContext_ServiceName?falseid_StringFNPRDFNContext
FNContext_SchemaFNContext_Schema?falseid_StringSYSADMFNContext
FNContext_PortFNContext_Port?falseid_String1521FNContext
FNContext_PasswordFNContext_Password?falseid_Password**********FNContext
FNContext_AdditionalParamsFNContext_AdditionalParams?falseid_StringFNContext
FNContext_LoginFNContext_Login?falseid_StringDARTSFNContext
SSS_Context_AdditionalParamsSSS_Context_AdditionalParams?falseid_StringSS_Staging_Context
SSS_Context_PasswordSSS_Context_Password?falseid_Password**********SS_Staging_Context
SSS_Context_DatabaseSSS_Context_Database?falseid_StringUMS_STAGING_PRDSS_Staging_Context
SSS_Context_LoginSSS_Context_Login?falseid_StringPS_TO_DMSS_Staging_Context
SSS_Context_PortSSS_Context_Port?falseid_String1433SS_Staging_Context
SSS_Context_SchemaSSS_Context_Schema?falseid_StringdboSS_Staging_Context
SSS_Context_ServerSSS_Context_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduSS_Staging_Context
tsendMailUsernametsendMailUsername?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailPasswordtsendMailPassword?falseid_Password****tsendMail_Context
tsendMailCctsendMailCc?falseid_StringnulltsendMail_Context
tsendMailSMTPPorttsendMailSMTPPort?falseid_String465tsendMail_Context
tsendMailSubject_FailuretsendMailSubject_Failure?falseid_String"*** ERROR *** Talend Job " +((String)globalMap.get("vErrorJob")) +" (" +((String)globalMap.get("vErrorJobPID")) +") *** Failed ***"tsendMail_Context
tsendMailToFailuretsendMailToFailure?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu; rachel.groenhout@maine.edu; asgeir.whitney@maine.edu; johns@maine.edu; gary.blake@maine.edutsendMail_Context
tsendMailMessage_FailuretsendMailMessage_Failure?falseid_StringtsendMail_Context
tsendMailSMTPHosttsendMailSMTPHost?falseid_Stringsmarthost.maine.edutsendMail_Context
tsendMailToSuccesstsendMailToSuccess?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu; rachel.groenhout@maine.edu; asgeir.whitney@maine.edu; johns@maine.edu; gary.blake@maine.edutsendMail_Context
tsendMailSubjecttsendMailSubject?falseid_StringtsendMail_Context
tsendMailMessagetsendMailMessage?falseid_StringtsendMail_Context
tsendMailSubject_SuccesstsendMailSubject_Success?falseid_StringtsendMail_Context
tsendMailFromtsendMailFrom?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailBcctsendMailBcc?falseid_StringnulltsendMail_Context
tsendMailMessage_SuccesstsendMailMessage_Success?falseid_StringtsendMail_Context
FY_StartFY_Start?falseid_Integer2006FN_Specific_Contexts
FY_EndFY_End?falseid_Integer9999FN_Specific_Contexts
TGT_Schema_8TGT_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_9TGT_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_2TGT_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_3TGT_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_1TGT_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_6TGT_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_7TGT_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_4TGT_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_5TGT_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsTotal_10TGT_RowsTotal_10?falseid_Integer0General_Job_Contexts
TGT_SOR_SK_10TGT_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsUpdated_10TGT_RowsUpdated_10?falseid_Integer0General_Job_Contexts
TGT_TableName_9TGT_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_8TGT_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_5TGT_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_4TGT_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_7TGT_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_6TGT_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
ThreadTimeThreadTime?falseid_Integer180000General_Job_Contexts
TGT_TableRowCount_Before_1TGT_TableRowCount_Before_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_2TGT_TableRowCount_Before_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_3TGT_TableRowCount_Before_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_4TGT_TableRowCount_Before_4?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_5TGT_TableRowCount_Before_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_6TGT_TableRowCount_Before_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_7TGT_TableRowCount_Before_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_8TGT_TableRowCount_Before_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_9TGT_TableRowCount_Before_9?falseid_Integer0General_Job_Contexts
SRC_Table_DI_Purpose_10SRC_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_1TGT_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_3TGT_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_2TGT_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_10TGT_RowsRejected_10?falseid_Integer0General_Job_Contexts
SRC_Schema_10SRC_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_3SRC_Query_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_2SRC_Query_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_1TGT_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_5SRC_Query_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_4SRC_Query_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_7SRC_Query_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_4TGT_Database_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_6SRC_Query_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_5TGT_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_9SRC_Query_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_2TGT_Database_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_8SRC_Query_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_3TGT_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_8TGT_Database_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_9TGT_Database_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_6TGT_Database_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_7TGT_Database_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_10SRC_Table_No_10?falseid_Integer1General_Job_Contexts
TGT_Table_DI_Purpose_10TGT_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
LoopCounterLoopCounter?falseid_Integer0General_Job_Contexts
SRC_Query_1SRC_Query_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_8TGT_RowsInserted_8?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_9TGT_RowsInserted_9?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_6TGT_RowsInserted_6?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_7TGT_RowsInserted_7?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_4TGT_RowsInserted_4?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_5TGT_RowsInserted_5?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_2TGT_RowsInserted_2?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_3TGT_RowsInserted_3?falseid_Integer0General_Job_Contexts
SRC_TableName_10SRC_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_10TGT_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_1TGT_RowsInserted_1?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_2TGT_RowsRejected_2?falseid_Integer0General_Job_Contexts
TGT_Server_10TGT_Server_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_3TGT_RowsRejected_3?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_4TGT_RowsRejected_4?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_5TGT_RowsRejected_5?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_6TGT_RowsRejected_6?falseid_Integer0General_Job_Contexts
TGT_Database_10TGT_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_7TGT_RowsRejected_7?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_8TGT_RowsRejected_8?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_9TGT_RowsRejected_9?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_10SRC_TableRowCount_10?falseid_Integer0General_Job_Contexts
SRC_Table_No_1SRC_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_RowsRejected_1TGT_RowsRejected_1?falseid_Integer0General_Job_Contexts
ContinueLoopContinueLoop?falseid_BooleanfalseGeneral_Job_Contexts
TGT_SOR_SK_2TGT_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_3TGT_SOR_SK_3?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_1TGT_SOR_SK_1?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_6TGT_SOR_SK_6?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_7TGT_SOR_SK_7?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_4TGT_SOR_SK_4?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_5TGT_SOR_SK_5?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_8TGT_SOR_SK_8?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_9TGT_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_Server_6SRC_Server_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_3SRC_Table_No_3?falseid_Integer1General_Job_Contexts
SRC_Server_5SRC_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_2SRC_Table_No_2?falseid_Integer1General_Job_Contexts
SRC_Server_8SRC_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_5SRC_Table_No_5?falseid_Integer1General_Job_Contexts
SRC_Server_7SRC_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_4SRC_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_Server_2SRC_Server_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_7SRC_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Server_1SRC_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_6SRC_Table_No_6?falseid_Integer1General_Job_Contexts
SRC_Server_4SRC_Server_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_9SRC_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Server_3SRC_Server_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_8SRC_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Server_9SRC_Server_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_SOR_SK_10SRC_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsInserted_10TGT_RowsInserted_10?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_8TGT_RowsUpdated_8?falseid_Integer0General_Job_Contexts
SRC_Database_10SRC_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_7TGT_RowsUpdated_7?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_9TGT_RowsUpdated_9?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_4TGT_RowsUpdated_4?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_3TGT_RowsUpdated_3?falseid_Integer0General_Job_Contexts
SRC_TableName_9SRC_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_6TGT_RowsUpdated_6?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_5TGT_RowsUpdated_5?falseid_Integer0General_Job_Contexts
SRC_TableName_7SRC_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_8SRC_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_5SRC_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_2TGT_RowsUpdated_2?falseid_Integer0General_Job_Contexts
SRC_TableName_6SRC_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_1TGT_RowsUpdated_1?falseid_Integer0General_Job_Contexts
SRC_TableName_3SRC_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_4SRC_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_10TGT_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_1SRC_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_2SRC_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_9SRC_Database_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_2SRC_Database_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_9TGT_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Database_1SRC_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_4SRC_Database_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_7TGT_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Database_3SRC_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_8TGT_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Database_6SRC_Database_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_5SRC_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_8SRC_Database_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_7SRC_Database_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_1TGT_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_Table_No_2TGT_Table_No_2?falseid_Integer1General_Job_Contexts
TGT_Table_No_5TGT_Table_No_5?falseid_Integer1General_Job_Contexts
TGT_Table_No_6TGT_Table_No_6?falseid_Integer1General_Job_Contexts
TGT_Table_No_3TGT_Table_No_3?falseid_Integer1General_Job_Contexts
TGT_Table_No_4TGT_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_7SRC_SOR_SK_7?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_8SRC_SOR_SK_8?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_9SRC_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_2SRC_TableRowCount_2?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_1SRC_TableRowCount_1?falseid_Integer0General_Job_Contexts
TGT_Table_No_10TGT_Table_No_10?falseid_Integer1General_Job_Contexts
LoopInterationsLoopInterations?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_3SRC_SOR_SK_3?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_4SRC_TableRowCount_4?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_4SRC_SOR_SK_4?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_3SRC_TableRowCount_3?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_5SRC_SOR_SK_5?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_6SRC_TableRowCount_6?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_6SRC_SOR_SK_6?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_5SRC_TableRowCount_5?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_1SRC_SOR_SK_1?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_2SRC_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_TableRowCount_After_9TGT_TableRowCount_After_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_5TGT_TableRowCount_After_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_6TGT_TableRowCount_After_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_7TGT_TableRowCount_After_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_8TGT_TableRowCount_After_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_1TGT_TableRowCount_After_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_2TGT_TableRowCount_After_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_3TGT_TableRowCount_After_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_4TGT_TableRowCount_After_4?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_8SRC_TableRowCount_8?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_7SRC_TableRowCount_7?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_9SRC_TableRowCount_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_1TGT_RowsTotal_1?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_4TGT_RowsTotal_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_7TGT_RowsDeleted_7?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_5TGT_RowsTotal_5?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_8TGT_RowsDeleted_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_2TGT_RowsTotal_2?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_5TGT_RowsDeleted_5?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_3TGT_RowsTotal_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_6TGT_RowsDeleted_6?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_8TGT_RowsTotal_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_9TGT_RowsTotal_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_6TGT_RowsTotal_6?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_9TGT_RowsDeleted_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_10TGT_TableRowCount_After_10?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_7TGT_RowsTotal_7?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_3TGT_RowsDeleted_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_4TGT_RowsDeleted_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_1TGT_RowsDeleted_1?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_2TGT_RowsDeleted_2?falseid_Integer0General_Job_Contexts
TGT_Server_2TGT_Server_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_3TGT_Server_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_4TGT_Server_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_5TGT_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_8SRC_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_7SRC_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_9SRC_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_1TGT_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_4SRC_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_3SRC_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_6SRC_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_5SRC_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_6TGT_Server_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_7TGT_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_2SRC_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_8TGT_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_1SRC_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_9TGT_Server_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableRowCount_Before_10TGT_TableRowCount_Before_10?falseid_Integer0General_Job_Contexts
SRC_Schema_7SRC_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_8SRC_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsDeleted_10TGT_RowsDeleted_10?falseid_Integer0General_Job_Contexts
SRC_Schema_9SRC_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Server_10SRC_Server_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_3SRC_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_4SRC_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_5SRC_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_6SRC_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_1SRC_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_2SRC_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_1TGT_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_2TGT_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_3TGT_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_4TGT_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_10SRC_Query_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_5TGT_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_6TGT_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_7TGT_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_8TGT_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_9TGT_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts


ContextTST

NamePromptNeed Prompt?TypeValueSource
DI_CNTL_SchemaDI_CNTL_Schema?falseid_StringdboDI_CNTL_Context
DI_CNTL_LoginDI_CNTL_Login?falseid_StringPS_TO_DMDI_CNTL_Context
DI_CNTL_ServerDI_CNTL_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduDI_CNTL_Context
DI_CNTL_DatabaseDI_CNTL_Database?falseid_StringUMS_DI_CNTL_TSTDI_CNTL_Context
DI_CNTL_PasswordDI_CNTL_Password?falseid_Password**********DI_CNTL_Context
DI_CNTL_PortDI_CNTL_Port?falseid_String1433DI_CNTL_Context
DI_CNTL_AdditionalParamsDI_CNTL_AdditionalParams?falseid_StringDI_CNTL_Context
FNContext_ServerFNContext_Server?falseid_Stringfntst.db.its.maine.eduFNContext
FNContext_ServiceNameFNContext_ServiceName?falseid_StringFNTSTFNContext
FNContext_SchemaFNContext_Schema?falseid_StringSYSADMFNContext
FNContext_PortFNContext_Port?falseid_String1521FNContext
FNContext_PasswordFNContext_Password?falseid_Password**********FNContext
FNContext_AdditionalParamsFNContext_AdditionalParams?falseid_StringFNContext
FNContext_LoginFNContext_Login?falseid_StringDARTSFNContext
SSS_Context_AdditionalParamsSSS_Context_AdditionalParams?falseid_StringSS_Staging_Context
SSS_Context_PasswordSSS_Context_Password?falseid_Password**********SS_Staging_Context
SSS_Context_DatabaseSSS_Context_Database?falseid_StringUMS_STAGING_TSTSS_Staging_Context
SSS_Context_LoginSSS_Context_Login?falseid_StringPS_TO_DMSS_Staging_Context
SSS_Context_PortSSS_Context_Port?falseid_String1433SS_Staging_Context
SSS_Context_SchemaSSS_Context_Schema?falseid_StringdboSS_Staging_Context
SSS_Context_ServerSSS_Context_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduSS_Staging_Context
tsendMailUsernametsendMailUsername?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailPasswordtsendMailPassword?falseid_Password****tsendMail_Context
tsendMailCctsendMailCc?falseid_StringnulltsendMail_Context
tsendMailSMTPPorttsendMailSMTPPort?falseid_String465tsendMail_Context
tsendMailSubject_FailuretsendMailSubject_Failure?falseid_String"*** ERROR *** Talend Job " +((String)globalMap.get("vErrorJob")) +" (" +((String)globalMap.get("vErrorJobPID")) +") *** Failed ***"tsendMail_Context
tsendMailToFailuretsendMailToFailure?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu; asgeir.whitney@maine.edu; gary.blake@maine.edutsendMail_Context
tsendMailMessage_FailuretsendMailMessage_Failure?falseid_StringtsendMail_Context
tsendMailSMTPHosttsendMailSMTPHost?falseid_Stringsmarthost.maine.edutsendMail_Context
tsendMailToSuccesstsendMailToSuccess?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu; asgeir.whitney@maine.edu; gary.blake@maine.edutsendMail_Context
tsendMailSubjecttsendMailSubject?falseid_StringtsendMail_Context
tsendMailMessagetsendMailMessage?falseid_StringtsendMail_Context
tsendMailSubject_SuccesstsendMailSubject_Success?falseid_StringtsendMail_Context
tsendMailFromtsendMailFrom?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailBcctsendMailBcc?falseid_StringnulltsendMail_Context
tsendMailMessage_SuccesstsendMailMessage_Success?falseid_StringtsendMail_Context
FY_StartFY_Start?falseid_Integer2006FN_Specific_Contexts
FY_EndFY_End?falseid_Integer9999FN_Specific_Contexts
TGT_Schema_8TGT_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_9TGT_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_2TGT_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_3TGT_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_1TGT_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_6TGT_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_7TGT_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_4TGT_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_5TGT_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsTotal_10TGT_RowsTotal_10?falseid_Integer0General_Job_Contexts
TGT_SOR_SK_10TGT_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsUpdated_10TGT_RowsUpdated_10?falseid_Integer0General_Job_Contexts
TGT_TableName_9TGT_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_8TGT_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_5TGT_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_4TGT_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_7TGT_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_6TGT_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
ThreadTimeThreadTime?falseid_Integer3000General_Job_Contexts
TGT_TableRowCount_Before_1TGT_TableRowCount_Before_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_2TGT_TableRowCount_Before_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_3TGT_TableRowCount_Before_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_4TGT_TableRowCount_Before_4?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_5TGT_TableRowCount_Before_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_6TGT_TableRowCount_Before_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_7TGT_TableRowCount_Before_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_8TGT_TableRowCount_Before_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_9TGT_TableRowCount_Before_9?falseid_Integer0General_Job_Contexts
SRC_Table_DI_Purpose_10SRC_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_1TGT_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_3TGT_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_2TGT_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_10TGT_RowsRejected_10?falseid_Integer0General_Job_Contexts
SRC_Schema_10SRC_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_3SRC_Query_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_2SRC_Query_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_1TGT_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_5SRC_Query_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_4SRC_Query_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_7SRC_Query_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_4TGT_Database_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_6SRC_Query_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_5TGT_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_9SRC_Query_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_2TGT_Database_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_8SRC_Query_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_3TGT_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_8TGT_Database_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_9TGT_Database_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_6TGT_Database_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_7TGT_Database_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_10SRC_Table_No_10?falseid_Integer1General_Job_Contexts
TGT_Table_DI_Purpose_10TGT_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
LoopCounterLoopCounter?falseid_Integer0General_Job_Contexts
SRC_Query_1SRC_Query_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_8TGT_RowsInserted_8?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_9TGT_RowsInserted_9?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_6TGT_RowsInserted_6?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_7TGT_RowsInserted_7?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_4TGT_RowsInserted_4?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_5TGT_RowsInserted_5?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_2TGT_RowsInserted_2?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_3TGT_RowsInserted_3?falseid_Integer0General_Job_Contexts
SRC_TableName_10SRC_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_10TGT_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_1TGT_RowsInserted_1?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_2TGT_RowsRejected_2?falseid_Integer0General_Job_Contexts
TGT_Server_10TGT_Server_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_3TGT_RowsRejected_3?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_4TGT_RowsRejected_4?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_5TGT_RowsRejected_5?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_6TGT_RowsRejected_6?falseid_Integer0General_Job_Contexts
TGT_Database_10TGT_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_7TGT_RowsRejected_7?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_8TGT_RowsRejected_8?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_9TGT_RowsRejected_9?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_10SRC_TableRowCount_10?falseid_Integer0General_Job_Contexts
SRC_Table_No_1SRC_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_RowsRejected_1TGT_RowsRejected_1?falseid_Integer0General_Job_Contexts
ContinueLoopContinueLoop?falseid_BooleanfalseGeneral_Job_Contexts
TGT_SOR_SK_2TGT_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_3TGT_SOR_SK_3?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_1TGT_SOR_SK_1?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_6TGT_SOR_SK_6?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_7TGT_SOR_SK_7?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_4TGT_SOR_SK_4?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_5TGT_SOR_SK_5?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_8TGT_SOR_SK_8?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_9TGT_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_Server_6SRC_Server_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_3SRC_Table_No_3?falseid_Integer1General_Job_Contexts
SRC_Server_5SRC_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_2SRC_Table_No_2?falseid_Integer1General_Job_Contexts
SRC_Server_8SRC_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_5SRC_Table_No_5?falseid_Integer1General_Job_Contexts
SRC_Server_7SRC_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_4SRC_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_Server_2SRC_Server_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_7SRC_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Server_1SRC_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_6SRC_Table_No_6?falseid_Integer1General_Job_Contexts
SRC_Server_4SRC_Server_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_9SRC_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Server_3SRC_Server_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_8SRC_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Server_9SRC_Server_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_SOR_SK_10SRC_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsInserted_10TGT_RowsInserted_10?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_8TGT_RowsUpdated_8?falseid_Integer0General_Job_Contexts
SRC_Database_10SRC_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_7TGT_RowsUpdated_7?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_9TGT_RowsUpdated_9?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_4TGT_RowsUpdated_4?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_3TGT_RowsUpdated_3?falseid_Integer0General_Job_Contexts
SRC_TableName_9SRC_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_6TGT_RowsUpdated_6?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_5TGT_RowsUpdated_5?falseid_Integer0General_Job_Contexts
SRC_TableName_7SRC_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_8SRC_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_5SRC_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_2TGT_RowsUpdated_2?falseid_Integer0General_Job_Contexts
SRC_TableName_6SRC_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_1TGT_RowsUpdated_1?falseid_Integer0General_Job_Contexts
SRC_TableName_3SRC_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_4SRC_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_10TGT_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_1SRC_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_2SRC_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_9SRC_Database_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_2SRC_Database_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_9TGT_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Database_1SRC_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_4SRC_Database_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_7TGT_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Database_3SRC_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_8TGT_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Database_6SRC_Database_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_5SRC_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_8SRC_Database_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_7SRC_Database_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_1TGT_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_Table_No_2TGT_Table_No_2?falseid_Integer1General_Job_Contexts
TGT_Table_No_5TGT_Table_No_5?falseid_Integer1General_Job_Contexts
TGT_Table_No_6TGT_Table_No_6?falseid_Integer1General_Job_Contexts
TGT_Table_No_3TGT_Table_No_3?falseid_Integer1General_Job_Contexts
TGT_Table_No_4TGT_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_7SRC_SOR_SK_7?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_8SRC_SOR_SK_8?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_9SRC_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_2SRC_TableRowCount_2?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_1SRC_TableRowCount_1?falseid_Integer0General_Job_Contexts
TGT_Table_No_10TGT_Table_No_10?falseid_Integer1General_Job_Contexts
LoopInterationsLoopInterations?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_3SRC_SOR_SK_3?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_4SRC_TableRowCount_4?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_4SRC_SOR_SK_4?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_3SRC_TableRowCount_3?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_5SRC_SOR_SK_5?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_6SRC_TableRowCount_6?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_6SRC_SOR_SK_6?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_5SRC_TableRowCount_5?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_1SRC_SOR_SK_1?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_2SRC_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_TableRowCount_After_9TGT_TableRowCount_After_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_5TGT_TableRowCount_After_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_6TGT_TableRowCount_After_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_7TGT_TableRowCount_After_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_8TGT_TableRowCount_After_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_1TGT_TableRowCount_After_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_2TGT_TableRowCount_After_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_3TGT_TableRowCount_After_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_4TGT_TableRowCount_After_4?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_8SRC_TableRowCount_8?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_7SRC_TableRowCount_7?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_9SRC_TableRowCount_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_1TGT_RowsTotal_1?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_4TGT_RowsTotal_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_7TGT_RowsDeleted_7?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_5TGT_RowsTotal_5?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_8TGT_RowsDeleted_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_2TGT_RowsTotal_2?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_5TGT_RowsDeleted_5?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_3TGT_RowsTotal_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_6TGT_RowsDeleted_6?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_8TGT_RowsTotal_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_9TGT_RowsTotal_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_6TGT_RowsTotal_6?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_9TGT_RowsDeleted_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_10TGT_TableRowCount_After_10?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_7TGT_RowsTotal_7?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_3TGT_RowsDeleted_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_4TGT_RowsDeleted_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_1TGT_RowsDeleted_1?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_2TGT_RowsDeleted_2?falseid_Integer0General_Job_Contexts
TGT_Server_2TGT_Server_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_3TGT_Server_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_4TGT_Server_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_5TGT_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_8SRC_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_7SRC_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_9SRC_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_1TGT_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_4SRC_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_3SRC_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_6SRC_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_5SRC_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_6TGT_Server_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_7TGT_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_2SRC_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_8TGT_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_1SRC_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_9TGT_Server_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableRowCount_Before_10TGT_TableRowCount_Before_10?falseid_Integer0General_Job_Contexts
SRC_Schema_7SRC_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_8SRC_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsDeleted_10TGT_RowsDeleted_10?falseid_Integer0General_Job_Contexts
SRC_Schema_9SRC_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Server_10SRC_Server_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_3SRC_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_4SRC_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_5SRC_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_6SRC_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_1SRC_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_2SRC_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_1TGT_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_2TGT_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_3TGT_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_4TGT_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_10SRC_Query_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_5TGT_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_6TGT_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_7TGT_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_8TGT_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_9TGT_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts




Component List

Component NameComponent Type
tDBConnection_1tMSSqlConnection
tDBConnection_2tOracleConnection
tDBConnection_3tMSSqlConnection
tDie_1tDie
tDie_2tDie
tDie_3tDie
tJavaFlex_1tJavaFlex
tJavaFlex_2tJavaFlex
tJavaFlex_3tJavaFlex
tJava_1tJava
tJava_10tJava
tJava_2tJava
tJava_3tJava
tJava_4tJava
tJava_5tJava
tJava_6tJava
tJava_7tJava
tJava_8tJava
tJava_9tJava
tLogCatcher_1tLogCatcher
tLoop_1tLoop
tLoop_2tLoop
tLoop_3tLoop
tMap_1tMap
tSendMail_5tSendMail
tSetGlobalVar_1tSetGlobalVar

Components Description

Component   tMSSqlConnection

      UNIQUE NAMEtDBConnection_1INPUT(S)tJavaFlex_2
LABELSS_Staging_ConnectionOUTPUT(S)tJava_7

Component Parameters:
PropertiesValues
DatabasetMSSqlConnection
Unique NametDBConnection_1
Component NametMSSqlConnection
Version0.102 (ALPHA)
FamilyDatabases/DB Specifics/MS_SQL_Server|ELT/Connections
Startfalse
Startabletrue
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tMSSqlConnection
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Property Typerepository: DB (MSSQL):SS_Staging_Connection
JDBC ProviderMSSQL_PROP
Hostcontext.SSS_Context_Server
Database DriverMSSQL
Portcontext.SSS_Context_Port
Schemacontext.SSS_Context_Schema
Databasecontext.SSS_Context_Database
Usernamecontext.SSS_Context_Login
Passwordcontext.SSS_Context_Password
Encoding"ISO-8859-15"
Additional JDBC Parameterscontext.SSS_Context_AdditionalParams
Use or register a shared DB Connectionfalse
Shared DB Connection Name
Specify a data source aliasfalse
Data source alias""
Auto Commitfalse
Share identity insert in multi tablefalse
Label formatSS_Staging_Connection
Hint format<b>_SS_Staging_Connection_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentTests the MS SQL Server Staging connection.
Use an existing validation rulefalse
Validation Rule Type


Original Function Parameters:
Component   tOracleConnection

      UNIQUE NAMEtDBConnection_2INPUT(S)tJavaFlex_1
LABELFN_ConnectionOUTPUT(S)tJava_2

Component Parameters:
PropertiesValues
DatabasetOracleConnection
Unique NametDBConnection_2
Component NametOracleConnection
Version0.102 (ALPHA)
FamilyDatabases/DB Specifics/Oracle|ELT/Connections
Startfalse
Startabletrue
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tOracleConnection
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Property Typerepository: DB (ORACLE_SERVICE_NAME):FN_Connection
Connection TypeORACLE_SERVICE_NAME
DB VersionORACLE_11
URLcontext.FNContext_Server
Use tns filefalse
TNS File""
Select a DB Connection in Tns File
Hostcontext.FNContext_Server
Database DriverORACLE_SERVICE_NAME
Portcontext.FNContext_Port
Databasecontext.FNContext_ServiceName
Local Service Namecontext.FNContext_ServiceName
Schemacontext.FNContext_Schema
Usernamecontext.FNContext_Login
Passwordcontext.FNContext_Password
Use SSLfalse
TrustStore file""
TrustStore password**
Need Client authenticationfalse
KeyStore file""
KeyStore password**
Disable CBC protectiontrue
Encoding"ISO-8859-15"
Additional JDBC Parameterscontext.FNContext_AdditionalParams
Use or register a shared DB Connectionfalse
Shared DB Connection Name
Specify a data source aliasfalse
Data source alias""
URL"jdbc:oracle:thin:USER/MDP@server"
Auto Committrue
Label formatFN_Connection
Hint format<b>_FN_Connection_</b><br>__COMMENT__
Connection formatrow
Show Informationtrue
CommentTests the FN_Connection.
Use an existing validation rulefalse
Validation Rule Type


Original Function Parameters:
Component   tMSSqlConnection

      UNIQUE NAMEtDBConnection_3INPUT(S)tJavaFlex_3
LABELDI_CNTLOUTPUT(S)tJava_8

Component Parameters:
PropertiesValues
DatabasetMSSqlConnection
Unique NametDBConnection_3
Component NametMSSqlConnection
Version0.102 (ALPHA)
FamilyDatabases/DB Specifics/MS_SQL_Server|ELT/Connections
Startfalse
Startabletrue
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tMSSqlConnection
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Property Typerepository: DB (MSSQL):DI_CNTL
JDBC ProviderMSSQL_PROP
Hostcontext.DI_CNTL_Server
Database DriverMSSQL
Portcontext.DI_CNTL_Port
Schemacontext.DI_CNTL_Schema
Databasecontext.DI_CNTL_Database
Usernamecontext.DI_CNTL_Login
Passwordcontext.DI_CNTL_Password
Encoding"ISO-8859-15"
Additional JDBC Parameterscontext.DI_CNTL_AdditionalParams
Use or register a shared DB Connectionfalse
Shared DB Connection Name
Specify a data source aliasfalse
Data source alias""
Auto Commitfalse
Share identity insert in multi tablefalse
Label formatDI_CNTL
Hint format<b>_DI_CNTL_</b><br>__COMMENT__
Connection formatrow
Show Informationtrue
CommentChecks the connection to the DI_CNTL database.
Use an existing validation rulefalse
Validation Rule Type


Original Function Parameters:
Component   tDie

      UNIQUE NAMEtDie_1INPUT(S)tJava_1
LABELtDie1OUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametDie_1
Component NametDie
Version0.102 (ALPHA)
FamilyLogs_Errors
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tDie
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Die message"Unable to connect to the FN database"
Error code0001
Priority5
Exit the JVM immediatelyfalse
SchemaBuilt-In
Label formattDie1
Hint format<b>_tDie1_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentTerminates the job with the specified error code.
Use an existing validation rulefalse
Validation Rule Type

Schema for tDie_1 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tDie

      UNIQUE NAMEtDie_2INPUT(S)tJava_5
LABELtDie2OUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametDie_2
Component NametDie
Version0.102 (ALPHA)
FamilyLogs_Errors
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tDie
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Die message"Unable to connect to the SS_Staging database"
Error code0002
Priority5
Exit the JVM immediatelyfalse
SchemaBuilt-In
Label formattDie2
Hint format<b>_tDie2_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentTerminates the job with the specified error code.
Use an existing validation rulefalse
Validation Rule Type

Schema for tDie_2 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tDie

      UNIQUE NAMEtDie_3INPUT(S)tJava_9
LABELtDie3OUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametDie_3
Component NametDie
Version0.102 (ALPHA)
FamilyLogs_Errors
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tDie
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Die message"Unable to connect to the DI_CNTL database"
Error code0003
Priority5
Exit the JVM immediatelyfalse
SchemaBuilt-In
Label formattDie3
Hint format<b>_tDie3_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentTerminates the job with the specified error code.
Use an existing validation rulefalse
Validation Rule Type

Schema for tDie_3 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJavaFlex

      UNIQUE NAMEtJavaFlex_1INPUT(S)tLoop_1
LABELCheck_the_statusOUTPUT(S)tDBConnection_2

Component Parameters:
PropertiesValues
Unique NametJavaFlex_1
Component NametJavaFlex
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJavaFlex
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Data Auto Propagatetrue
Start code// start part of your Java code try {
Main code// here is the main part of the component, a piece of code executed in the row loop if ( ((Integer)globalMap.get("tLoop_1_CURRENT_ITERATION")) < context.LoopInterations ) { System.out.println( "-> Keep Looping: "+ ((Integer)globalMap.get("tLoop_1_CURRENT_ITERATION")) ); Thread.sleep(context.ThreadTime); } else { System.out.println( "-> Last Loop Attempt : "+ ((Integer)globalMap.get("tLoop_1_CURRENT_ITERATION")) ); context.ContinueLoop = false; }
End code// end of the component, outside/closing the loop }catch(Exception e) { if (((Integer)globalMap.get("tLoop_1_CURRENT_ITERATION")) > context.LoopInterations) { context.ContinueLoop = false; System.out.println("-> Catch: "+ ((Integer)globalMap.get("tLoop_1_CURRENT_ITERATION")) ); } else { System.out.println("==> Trying dbConnection"); } }
TOS2.0false
TOS3.2false
TOS4.0true
Import//import java.util.List;
Label formatCheck_the_status
Hint format<b>_Check_the_status_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentChecks the status of the dbConnect process for success or failure and continues the process as appropriate.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJavaFlex_1 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJavaFlex

      UNIQUE NAMEtJavaFlex_2INPUT(S)tLoop_2
LABELCheck_the_statusOUTPUT(S)tDBConnection_1

Component Parameters:
PropertiesValues
Unique NametJavaFlex_2
Component NametJavaFlex
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJavaFlex
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Data Auto Propagatetrue
Start code// start part of your Java code try {
Main code// here is the main part of the component, a piece of code executed in the row loop if ( ((Integer)globalMap.get("tLoop_2_CURRENT_ITERATION")) < context.LoopInterations ) { System.out.println( "-> Keep Looping: "+ ((Integer)globalMap.get("tLoop_2_CURRENT_ITERATION")) ); Thread.sleep(context.ThreadTime); } else { System.out.println( "-> Last Loop Attempt : "+ ((Integer)globalMap.get("tLoop_2_CURRENT_ITERATION")) ); context.ContinueLoop = false; }
End code// end of the component, outside/closing the loop }catch(Exception e) { if (((Integer)globalMap.get("tLoop_2_CURRENT_ITERATION")) > context.LoopInterations) { context.ContinueLoop = false; System.out.println("-> Catch: "+ ((Integer)globalMap.get("tLoop_2_CURRENT_ITERATION")) ); } else { System.out.println("==> Trying dbConnection"); } }
TOS2.0false
TOS3.2false
TOS4.0true
Import//import java.util.List;
Label formatCheck_the_status
Hint format<b>_Check_the_status_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentChecks the status of the dbConnect process for success or failure and continues the process as appropriate.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJavaFlex_2 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJavaFlex

      UNIQUE NAMEtJavaFlex_3INPUT(S)tLoop_3
LABELCheck_the_statusOUTPUT(S)tDBConnection_3

Component Parameters:
PropertiesValues
Unique NametJavaFlex_3
Component NametJavaFlex
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJavaFlex
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Data Auto Propagatetrue
Start code// start part of your Java code try {
Main code// here is the main part of the component, a piece of code executed in the row loop if ( ((Integer)globalMap.get("tLoop_3_CURRENT_ITERATION")) < context.LoopInterations ) { System.out.println( "-> Keep Looping: "+ ((Integer)globalMap.get("tLoop_3_CURRENT_ITERATION")) ); Thread.sleep(context.ThreadTime); } else { System.out.println( "-> Last Loop Attempt : "+ ((Integer)globalMap.get("tLoop_3_CURRENT_ITERATION")) ); context.ContinueLoop = false; }
End code// end of the component, outside/closing the loop }catch(Exception e) { if (((Integer)globalMap.get("tLoop_3_CURRENT_ITERATION")) > context.LoopInterations) { context.ContinueLoop = false; System.out.println("-> Catch: "+ ((Integer)globalMap.get("tLoop_3_CURRENT_ITERATION")) ); } else { System.out.println("==> Trying dbConnection"); } }
TOS2.0false
TOS3.2false
TOS4.0true
Import//import java.util.List;
Label formatCheck_the_status
Hint format<b>_Check_the_status_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentChecks the status of the dbConnect process for success or failure and continues the process as appropriate.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJavaFlex_3 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_1INPUT(S)tLoop_1
LABELend_loopOUTPUT(S)tJava_3,  tDie_1

Component Parameters:
PropertiesValues
Unique NametJava_1
Component NametJava
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJava
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
CodeSystem.out.println("==> Ending loop dbConnection FN Attempts. \n");
Import//import java.util.List;
SchemaBuilt-In
Label formatend_loop
Hint format<b>_Not_so_good_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentEnd of loop logic. Good continue to next step, bad go to tDie.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJava_1 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_10INPUT(S)tJava_9
LABELCompletedOUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametJava_10
Component NametJava
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJava
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
CodeSystem.out.println("==> Ending loop dbConnection Attempts for all DB Connections!!!!!!!!!!. \n ");
Import//import java.util.List;
SchemaBuilt-In
Label formatCompleted
Hint format<b>_Completed_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentPrints completed succesfully message to the system console.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJava_10 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_2INPUT(S)tDBConnection_2
LABELReset_ContinueLoopOUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametJava_2
Component NametJava
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJava
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Codecontext.ContinueLoop = false; System.out.println("==> dbConnection to N Success.");
Import//import java.util.List;
SchemaBuilt-In
Label formatReset_ContinueLoop
Hint format<b>_Reset_ContinueLoop_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentResets the context if connection is successful.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJava_2 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_3INPUT(S)tJava_1
LABELLoop_InitializationOUTPUT(S)tLoop_2

Component Parameters:
PropertiesValues
Unique NametJava_3
Component NametJava
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJava
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Code// Reset variables for next db connection context.LoopCounter = 1; context.ContinueLoop = true; System.out.println("==> dbConnection loop for Staging DB");
Import//import java.util.List;
SchemaBuilt-In
Label formatLoop_Initialization
Hint format<b>_Loop_Initialization_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentInitializes loop contexts.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJava_3 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_4INPUT(S)none
LABELLoop_InitializationOUTPUT(S)tLoop_1

Component Parameters:
PropertiesValues
Unique NametJava_4
Component NametJava
Version0.101 (ALPHA)
FamilyCustom_Code
Starttrue
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJava
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Codecontext.LoopInterations = 10; context.LoopCounter = 1; context.ContinueLoop = true; System.out.println("==> dbConnection loop for FN");
Import//import java.util.List;
SchemaBuilt-In
Label formatLoop_Initialization
Hint format<b>_Loop_Initialization_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentInitializes loop contexts.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJava_4 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_5INPUT(S)tLoop_2
LABELend_loopOUTPUT(S)tJava_6,  tDie_2

Component Parameters:
PropertiesValues
Unique NametJava_5
Component NametJava
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJava
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
CodeSystem.out.println("==> Ending loop dbConnection Attempts for SS_Staging.");
Import//import java.util.List;
SchemaBuilt-In
Label formatend_loop
Hint format<b>_Not_so_good_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentEnd of loop logic. Good continue to next step, bad go to tDie.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJava_5 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_6INPUT(S)tJava_5
LABELLoop_InitializationOUTPUT(S)tLoop_3

Component Parameters:
PropertiesValues
Unique NametJava_6
Component NametJava
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJava
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Code// Reset variables for next db connection context.LoopCounter = 1; context.ContinueLoop = true; System.out.println("==> dbConnection loop for DI_CNTL ");
Import//import java.util.List;
SchemaBuilt-In
Label formatLoop_Initialization
Hint format<b>_Loop_Initialization_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentInitializes loop contexts.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJava_6 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_7INPUT(S)tDBConnection_1
LABELReset_ContinueLoopOUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametJava_7
Component NametJava
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJava
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Codecontext.ContinueLoop = false; System.out.println("==> dbConnection Success for SS_Staging. \n ");
Import//import java.util.List;
SchemaBuilt-In
Label formatReset_ContinueLoop
Hint format<b>_Reset_ContinueLoop_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentResets the context if connection is successful.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJava_7 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_8INPUT(S)tDBConnection_3
LABELReset_ContinueLoopOUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametJava_8
Component NametJava
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJava
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Codecontext.ContinueLoop = false; System.out.println("==> dbConnection Success for DI_CNTL. \n ");
Import//import java.util.List;
SchemaBuilt-In
Label formatReset_ContinueLoop
Hint format<b>_Reset_ContinueLoop_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentResets the context if connection is successful.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJava_8 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_9INPUT(S)tLoop_3
LABELEnd_loopOUTPUT(S)tDie_3,  tJava_10

Component Parameters:
PropertiesValues
Unique NametJava_9
Component NametJava
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJava
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
CodeSystem.out.println("==> Ending loop dbConnection Attempts for DI_CNTL.");
Import//import java.util.List;
SchemaBuilt-In
Label formatEnd_loop
Hint format<b>_End_loop_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentEnd of loop logic. Good continue to next step, bad go to tDie.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJava_9 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tLogCatcher

      UNIQUE NAMEtLogCatcher_1INPUT(S)none
LABEL__UNIQUE_NAME__OUTPUT(S)tMap_1

Component Parameters:
PropertiesValues
Unique NametLogCatcher_1
Component NametLogCatcher
Version0.101 (ALPHA)
FamilyLogs_Errors
Starttrue
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWfalse
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tLogCatcher
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Catch Java Exceptiontrue
Catch tDietrue
Catch tWarntrue
Catch tJobFailuretrue
Label format__UNIQUE_NAME__
Hint format<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentReads the tLogCatcher tables and passes the information to the tMap.
Use an existing validation rulefalse
Validation Rule Type

Schema for tLogCatcher_1 :
ColumnKeyTypeLengthPrecisionNullableComment
momentfalsejava.util.Datetrue
pidfalseString20true
root_pidfalseString20true
father_pidfalseString20true
projectfalseString50true
jobfalseString255true
contextfalseString50true
priorityfalseInteger3true
typefalseString255true
originfalseString255true
messagefalseString255true
codefalseInteger3true

Original Function Parameters:
Component   tLoop

      UNIQUE NAMEtLoop_1INPUT(S)tJava_4
LABELLoopity_LoopOUTPUT(S)tJavaFlex_1,  tJava_1

Component Parameters:
PropertiesValues
Unique NametLoop_1
Component NametLoop
Version0.102 (ALPHA)
FamilyOrchestration
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tLoop
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Forfalse
Whiletrue
From1
Tocontext.loop_count
Step1
Values are increasingtrue
Declaration
Conditioncontext.ContinueLoop
Iteration
Label formatLoopity_Loop
Hint format<b>_Loopity_Loop_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentActual loop.
Use an existing validation rulefalse
Validation Rule Type


Original Function Parameters:
Component   tLoop

      UNIQUE NAMEtLoop_2INPUT(S)tJava_3
LABELLoopity_LoopOUTPUT(S)tJavaFlex_2,  tJava_5

Component Parameters:
PropertiesValues
Unique NametLoop_2
Component NametLoop
Version0.102 (ALPHA)
FamilyOrchestration
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tLoop
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Forfalse
Whiletrue
From1
Tocontext.loop_count
Step1
Values are increasingtrue
Declaration
Conditioncontext.ContinueLoop
Iteration
Label formatLoopity_Loop
Hint format<b>_Loopity_Loop_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentActual loop.
Use an existing validation rulefalse
Validation Rule Type


Original Function Parameters:
Component   tLoop

      UNIQUE NAMEtLoop_3INPUT(S)tJava_6
LABELLoopity_LoopOUTPUT(S)tJavaFlex_3,  tJava_9

Component Parameters:
PropertiesValues
Unique NametLoop_3
Component NametLoop
Version0.102 (ALPHA)
FamilyOrchestration
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tLoop
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Forfalse
Whiletrue
From1
Tocontext.loop_count
Step1
Values are increasingtrue
Declaration
Conditioncontext.ContinueLoop
Iteration
Label formatLoopity_Loop
Hint format<b>_Loopity_Loop_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentActual loop.
Use an existing validation rulefalse
Validation Rule Type


Original Function Parameters:
Component   tSendMail

      UNIQUE NAMEtSendMail_5INPUT(S)tSetGlobalVar_1
LABELsend_LogCatcher_notifyOUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametSendMail_5
Component NametSendMail
Version0.101 (ALPHA)
FamilyInternet
Startfalse
Startabletrue
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tSendMail
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Tocontext.tsendMailToFailure
Fromcontext.tsendMailFrom
Show sender's name?true
Sendernamecontext.tsendMailUsername
Cc
Bcc
Subject"*** ERROR *** Talend Job " + ((String)globalMap.get("vErrorJob")) + " (" +((String)globalMap.get("vErrorJobPID")) + ") *** Failed ***"
Message"Error Project: "+((String)globalMap.get("vErrorProject")) + "\n" + "\nJob: " + ((String)globalMap.get("vErrorJob")) + " ( " + ((String)globalMap.get("vErrorJobPID")) + " ) " + "\n" + "\nError Root Job PID: " + ((String)globalMap.get("vErrorRootPID")) + "\n" + "\nError message: "+((String)globalMap.get("vErrorMessage"))
Die if the attachment file doesn't exist.false
Attachments[]
Other headers[]
SMTP hostcontext.tsendMailSMTPHost
SMTP portcontext.tsendMailSMTPPort
SSL Supporttrue
STARTTLS Supportfalse
ImportanceNormal
Need authentication?false
Usernamecontext.tsendMailUsername
Password**************
Die on errortrue
MIME subtype from the 'text' MIME typeplain
charset used for encoding message"UTF-8"
Set localhostfalse
Localhost"localhost"
SchemaBuilt-In
Label formatsend_LogCatcher_notify
Hint format<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentFormats and sends the appropriate error message.
Use an existing validation rulefalse
Validation Rule Type

Schema for out_GlobalVar :
ColumnKeyTypeLengthPrecisionNullableComment
pidfalseString20true
root_pidfalseString20true
jobfalseString255true
projectfalseString50true
originfalseString255true
messagefalseString255true
codefalseInteger3true

Original Function Parameters:
Component   tSetGlobalVar

      UNIQUE NAMEtSetGlobalVar_1INPUT(S)tMap_1
LABELset_GlobalVar_LogOUTPUT(S)tSendMail_5

Component Parameters:
PropertiesValues
Unique NametSetGlobalVar_1
Component NametSetGlobalVar
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTfalse
END_OF_FLOWfalse
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tSetGlobalVar
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Variables[{KEY="vErrorJobPID", VALUE=out_glovar.pid}, {KEY="vErrorRootPID", VALUE=out_glovar.root_pid}, {KEY="vErrorJob", VALUE=out_glovar.job}, {KEY="vErrorProject", VALUE=out_glovar.project}, {KEY="vErrorOrigin", VALUE=out_glovar.origin}, {KEY="vErrorMessage", VALUE=out_glovar.message }, {KEY="vErrorCode", VALUE=out_glovar.code}]
SchemaBuilt-In
Label formatset_GlobalVar_Log
Hint format<b>_set_GlobalVar_Log_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentPopulates and stores global variables.
Use an existing validation rulefalse
Validation Rule Type

Schema for out_GlobalVar :
ColumnKeyTypeLengthPrecisionNullableComment
pidfalseString20true
root_pidfalseString20true
jobfalseString255true
projectfalseString50true
originfalseString255true
messagefalseString255true
codefalseInteger3true

Original Function Parameters:
Component   tMap

      UNIQUE NAMEtMap_1INPUT(S)tLogCatcher_1
LABEL__UNIQUE_NAME__OUTPUT(S)tSetGlobalVar_1



Component Parameters:
PropertiesValues
tStatCatcher Statistics
false
Mapping links display as:
AUTO
Temp data directory path:
Max buffer size (nb of rows):
2000000
Ignore trailing zeros for BigDecimal
false
Show Information
false
Comment
Passes the data to the set GlobalVar Log.
Use an existing validation rule
false

Mapper table for tMap_1
				(
				input
				):
			
Mapper table Properties(
								logc
								):
							
PropertiesValues
Namelogc
Matching-modeUNIQUE_MATCH
isMinimizedfalse
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								logc
								):
							
NameTypeExpressionisNullable
momentjava.util.Datetrue
pidStringtrue
root_pidStringtrue
father_pidStringtrue
projectStringtrue
jobStringtrue
contextStringtrue
priorityIntegertrue
typeStringtrue
originStringtrue
messageStringtrue
codeIntegertrue

Constraint Table Entries(
								logc
								):
							
NameTypeExpressionisNullable

Mapper table for tMap_1
				(
				output
				):
			
Mapper table Properties(
								out_log
								):
							
PropertiesValues
Nameout_log
Matching-mode
isMinimizedfalse
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								out_log
								):
							
NameTypeExpressionisNullable
momentjava.util.Datelogc.momenttrue
pidStringlogc.pidtrue
root_pidStringlogc.root_pidtrue
father_pidStringlogc.father_pidtrue
projectStringlogc.projecttrue
jobStringlogc.jobtrue
contextStringlogc.contexttrue
priorityIntegerlogc.prioritytrue
typeStringlogc.typetrue
originStringlogc.origintrue
messageStringlogc.messagetrue
codeIntegerlogc.codetrue

Constraint Table Entries(
								out_log
								):
							
NameTypeExpressionisNullable

Mapper table Properties(
								out_glovar
								):
							
PropertiesValues
Nameout_glovar
Matching-mode
isMinimizedfalse
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								out_glovar
								):
							
NameTypeExpressionisNullable
pidStringlogc.pidtrue
root_pidStringlogc.root_pidtrue
jobStringlogc.jobtrue
projectStringlogc.projecttrue
originStringlogc.origintrue
messageStringlogc.messagetrue
codeIntegerlogc.codetrue

Constraint Table Entries(
								out_glovar
								):
							
NameTypeExpressionisNullable

Mapper table for tMap_1
				(
				var
				):
			
Mapper table Properties(
								Var
								):
							
PropertiesValues
NameVar
Matching-mode
isMinimizedtrue
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								Var
								):
							
NameTypeExpressionisNullable

Constraint Table Entries(
								Var
								):
							
NameTypeExpressionisNullable