Fermilab Computing Division

CS Document 5407-v1

Modernizing application integrations with a data integration hub

Document #:
CS-doc-5407-v1
Document type:
Presentation
Submitted by:
Scott W Nolan
Updated by:
Scott W Nolan
Document Created:
21 Aug 2014, 09:59
Contents Revised:
21 Aug 2014, 09:59
Metadata Revised:
21 Aug 2014, 09:59
Viewable by:
  • Public document
Modifiable by:

Quick Links:
Latest Version

Abstract:
Fermilab is implementing the Workday Human Capital Management system to replace its current PeopleSoft HRMS installation. Along with implementing Workday it was also decided that new integrations between Workday and the Legacy systems should move away from point-to-point integrations and toward an application integration architecture that uses a “hub” approach.

The application integration architecture includes many components such as a file storage system, file transfer system, and other supporting tools. However, the engine of Fermilab’s application integration architecture is a data integration hub that is based on the usage of an extract, transform, and load (ETL) tool to process and translate data so that it is usable by the various data sources (producers) and targets (consumers) Key capabilities of the data integration hub include providing:

• The ability to securely transfer data in different formats between systems

• The ability to merge and unmerge data for use by different systems

• The ability to transform data into different formats (XML, CSV) and structures

• The ability to map and un-map data transferred between systems

• Job orchestration and monitoring

• A central location and toolset to develop and maintain integrations

• A platform and system agnostic solution

This presentation will provide an overview of the features of a data integration hub and the benefits that have been or are planned to be achieved.

Files in Document:
Keywords:
NLIT Integration
DocDB Home ]  [ Search ] [ Authors ] [ Events ] [ Topics ]

DocDB Version 8.8.9, contact Document Database Administrators