...
This document lists out the current as of 95/2919/20202022, 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 Name | Folder | Status | Database Connections | Java Version | Notes |
|---|---|---|---|---|---|
| DEFTUpdatesToACH | ACH | In Use | MSSQL, Oracle | Oracle 8 | Used only for student population. Utilizes encryption/decryption keys. |
| DEFTReconRejectStatus | ACH | In Use | Oracle | Oracle 8 | Used only for student population |
| UCPathUpdatesToACH | ACH | In Use | Oracle | Oracle 8 | Use Used to populate UCPath ACH employee data into KFS. Utilizes encryption/decryption keys. |
| FSConvertToKFS | GL | In Use | Oracle | Oracle 8 | GL Blackbox job to create GL Collector files. Now only used by the ARC system. |
| SBSConvertToPDP | PDP | In Use | MSSQL | Oracle 8 | Used by the SBS team to generate XML Payment file |
| CorpCardUSBC1Conversion | USBC1 | In Use | Oracle | Oracle 8 | Convert USBank file to XML KFS Corporate Card file |
| CTSUSBC1Conversion | USBC1 | In Use | None | Oracle 8 | Convert USBank file to XML KFS Agency Card file |
| ProcurementCardUSBC1Conversion | USBC1 | In Use | Oracle | Oracle 8 | Convert USBank file to XML KFS Procurement Card file |