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 bulk upload data to Oracle database using OIC?

in Integration 2 comments

Hello,

We use OIC gen3 and have a Oracle database server on prem. The connection is via a connectivity agent. I am able to run SQL queries and get output on OIC, no issues with that.

My problem is trying to insert 100s of records into a table. Right now I am only able to do this via a For loop in OIC and calling an insert command. This is a huge performance drain, 300 records takes 10 mins. Not good.

I've been reading Oracle Database Adapter Capabilities which states "Support for updating or inserting multiple records in a single request."

Does anyone know how on earth can I bulk upload 100s of records in a single request? I am looking for every option but nothing so far. We live in times when bulk insert 000s of records takes seconds.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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