Thank you for your reply Shiv Kumar. But I did it using OData as suggested by Anubhav. But only issue is that it is taking more than 1 hour for passing and inserting 4 lakhs records there in MYSQL. Appreciate any suggestions for reducing time of insertion.