High Level Steps for On-premises Data Sources

To deploy an on-premises E-Business Suite or PeopleSoft data source, Implementors perform these setup steps.

How to load data from an E-Business Suite or PeopleSoft On-premises data source

  1. Register Source PSFT or EBS PL with Load Tech as External Data, and Configure Storage Service Container.

  2. Pick subject areas (FGs) and build Load Plans (Regular and Domains-only).

  3. Download ORDER.SQL, ORDER_DDL.SQL and ORDER_PE.SQL files for each Load Plan.

  4. Follow ORDER.SQL against the Domains-only Load Plan and prepare the data exports in CSV format for the Domains-only Load Plan.

  5. Upload data files (for Domains-only Load Plan) to the Storage Service Container.

  6. Run the Domain-only Load Plan.

  7. Configure domains.

  8. Clean up files from the Storage Service Container.

  9. Follow ORDER.SQL against the regular Load Plan and prepare the data exports in CSV format for the regular Load Plan.

  10. Upload data files (for the regular Load Plan) to the Storage Service Container.

  11. Run the regular Load Plan.

  12. Repeat steps 8 through 11 for the incremental ETL.

  13. If you have deletes in the OLTP for a table, then follow ORDER_PE.SQL for that table and prepare data exports in PECSV format and upload in SSC and run along with the usual Incremental run.