Excel to CI Performance and Faster Alternatives for Mass Uploads
Hello,
We understand there are several ways to upload/update data in PeopleSoft, for example:
i. Direct SQL insert/update (Bypasses component validation, not recommend)
ii. Excel to CI (Too slow)
iii. Call CI by Application Engine (eg. File Layout + Application Engine)
Our requirement is to keep PeopleSoft data validation/business logic, but find a faster approach than Excel to CI. We may need to upload/update data for both Finance/FSCM and HCM areas.
Therefore, I have two questions on it:
- Besides direct SQL, Excel to CI, and Application Engine calling CI, are there other recommended approaches for faster mass data upload while still keeping PeopleSoft validation/business logic?
0