Extracting data from PeopleSoft tables with the Direct Access stage

Functionality
The Direct Access plugin offers functionality to extract data directly from PeopleSoft tables, integrate with data from other sources, and other benefits.

Architecture
The IBM InfoSphere Information Server Pack for PeopleSoft Enterprise includes runtime and design time components

Installation prerequisites
In addition to the software requirements for the Direct Access plug-in, a database account with read access to the PeopleSoft data dictionary tables (base tables) is required for installing and using the Direct Access plug-in for PeopleSoft. For example, PSRECFIELD and PSDBFIELD.

Overview of building an extraction job
Several tasks are required to build an extraction job to extract data from tables and columns. For example, you must first create a Data Source Name (DSN) and then create and configure an IBM InfoSphere DataStage® job.