What's new in Customer Journeys?

Connect and learn more! ×
Insert / Update records in ATP database using CSV File with 1-2 million records from VBCS — Cloud Customer Connect
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

Insert / Update records in ATP database using CSV File with 1-2 million records from VBCS

Received Response
31
Views
6
Comments

Summary:


Content (please ensure you mask any confidential information):

We have scenario as per below :

1) Customer will provide the datafile by using upload button in VBCS.

2) VBCS should read the file that customer uploaded and insert/update all the records in database.

   Is there a way to invoke the SQL loader on ATP DB from VBCS and move the file to ATP DB server ? I have read we can insert multiple record in single insert/update statement using SQL loader but need to know if will help for such a large volume.

3) Also, Is there a way to perform the validation from master table before inserting/updating the records using SQL loader on ATP DB?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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