Large Size CDM Data Import Reference and General Guidance

Hi,

In this post, I will cover a data import reference I delivered a few years ago and also some general guidance I follow for Fusion Sales Data Import.

For this reference, here are the data object, data volume and the import durations

Based on my years of experiences of data import, to get the optimal import performance, here are the guidelines I follow,

• Prepare the data file with ETL tool with data from source systems and Oracle Cloud (for round-trip scenario)
• Establish the Import Timing baseline on production-sized pod
• Production Import should follow the same steps as the lower pod where you establish the baseline
• Use the most efficient tool to import data (e.g. EDLC, WS submission with UCM file IDs)
• Fine tune the Import Queue Size (e.g. 5-10 active importing jobs in the queue) to get the best throughout
• Disable the activities which will impact import duration (e.g. ESS job, Adaptive Search Periodic Refresh, OTBI/BIP scheduling, Object Trigger/Workflow, User Access, Inbound/Outbound Integrations)
• Purge the imported data and UCM files for the completed jobs in time

Hope this is helpful.

Adam Liu