Connect PHP for Bulk dataloads
We are in the process of migrating data from Legacy applications to Oracle Service Cloud. The Legacy Data needs to be migrated to both Standard Objects and a few Custom Objects in Service Cloud.
For some transactional entities, the volume of data is to the tune of 1 Million - 2 Million. And it is necessary to migate historical data to the new Service Cloud solution for reporting purposes.
Also all references need to be built during data upload. Example: An Incident needs to be linked to the correct Organization and Contact.
Currently we are using Connect PHP to import CSV data in bulk. But of late we see the throughput is very small. The PHP scripts have embedded ROQLs to fetch the IDs of the references (like Organization Id of the Organization to be linked to the Incident etc.)