Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to load large volume of CSV file to VBCS business object using OIC

edited Dec 5, 2018 11:35PM in Integration 7 comments

Summary

How to load large volume of CSV file to VBCS business object using OIC

Content

I am developing inbound interface in OIC. I am going to get large volume of CSV file on FTP server. data volume could be 20000 records per day.

We are using VBCS business object to hold CSV records.

Currently I am doing PoC to load those records in OIC. It is taking more than 4 hours to load data in business object.

I am picking up file from FTP server than writing file to stage area and then reading stage file in chunk and then looping one by one record and loading it to VBCS business object. We have to do it one by one as for few column we have to do validation as well. This is giving performance issue.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!