/
KFS Talend ETL Jobs Inventory Status

KFS Talend ETL Jobs Inventory Status

Introduction

This document lists out the current as of 5/19/2022, Talend ETL jobs being utilized.  This inventory will help with future planning regarding migration of jobs to Informatica, decommissioning of job no longer needed, and jobs which we plan to continue using as they are.


Job NameFolderStatusDatabase ConnectionsJava VersionNotes
DEFTUpdatesToACHACHIn UseMSSQL, OracleOracle 8Used only for student population. Utilizes encryption/decryption keys.
DEFTReconRejectStatusACHIn UseOracleOracle 8Used only for student population
UCPathUpdatesToACHACHIn UseOracleOracle 8Used to populate UCPath ACH employee data into KFS. Utilizes encryption/decryption keys.
FSConvertToKFSGLIn UseOracleOracle 8GL Blackbox job to create GL Collector files.  Now only used by the ARC system.
SBSConvertToPDPPDPIn UseMSSQLOracle 8Used by the SBS team to generate XML Payment file
CorpCardUSBC1ConversionUSBC1In UseOracleOracle 8Convert USBank file to XML KFS Corporate Card file
CTSUSBC1ConversionUSBC1In UseNoneOracle 8Convert USBank file to XML KFS Agency Card file
ProcurementCardUSBC1ConversionUSBC1In UseOracleOracle 8Convert USBank file to XML KFS Procurement Card file