Atul Kumar2
Giga Guru

Hi Sudharsan, I would be going by following the below steps. 1. Create one time scheduled job. 2. Create outbond web service which will pull the data from the sharepoint. 3. call outbond web service end point from the script. 3. Create transform map. 4. Validate all the data are in right place(knowlede base) and write a transform map script for default value like category etc if required within transform map script(on before). 5. Initiate webservice call from the sharepoint for one record if all good then. 6. Run one time scheduled job and wait. Hope this helps. Regards, Atul Kumar