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 update database with the database adapter?

Received Response
edited Jul 24, 2019 4:58PM in Integration 2 comments


need to update rows based on a value found in one of the fields


Hello Gurus,

I'm processing data from a database using the DB adapter. I'm able to get data from the database.

after processing that data, i want to use the primary key from that row of data to update a field value.


the workflow is:

Get data from DB
     for each row
          process data
          update a field in db to know its been processed.
     end loop
end orchestration

 I tried the the update option in the connection configuration, but I can only map data, I'm guessing this will perform an update on the entire field vs updating the field where the primary key is found.

Howdy, Stranger!

Log In

To view full details, sign in.


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