Understanding Data Import Using ETL

In PeopleSoft Planning and Budgeting, use the extract, transform, and load (ETL) tool to import data from the PeopleSoft Financial Management and HRMS databases. The ETL process establishes a matching table structure between the PeopleSoft Enterprise Performance Management (EPM) database and other PeopleSoft product line databases. The PeopleSoft system delivers the ETL jobs (maps) that you need to load budget-specific data into the Operational Warehouse Staging (OWS) tables and the Operational Warehouse Enriched (OWE) tables in the PeopleSoft EPM database.

In summary, you use ETL jobs to copy data from the source database into the EPM OWS tables and then to move data from OWS tables to the OWE tables, where Planning and Budgeting uses the data.

Consider reviewing the delivered ETL jobs and maps that you use to load data for PeopleSoft Planning and Budgeting (by product), compared to the source, OWS, and OWE tables that you require, which are listed in the topic Source, Staging and Target Tables for PeopleSoft Financial Management Data