Create a project and add HTTP listener to call the API

Drag and Drop bulk insert connector

Create a DB connection

Add the insert query as below

Set input parameter as

Now add a transformation

Here metadata for the output will be pre-populated and can see it accept the Array of the input object, here we are mapping data for two countries.

Run the application using – http://localhost:8081/insert

And now we can see the data added in Target table –

 

Sample application – http://www.acesoa.com/wp-content/uploads/2019/01/oracle-db-bulk-insert.zip

Leave a Comment