Enterprise Integrator: Setting Field on Source Documents

HCL Domino Domino Forum
,
1

I plan on copying documents I need to transfer/replicate with SQL into a central database. In some cases some documents need to update multiple SQL Tables. All single value information is located in one table a I have a couple others housing multi-value information.

This means I have 3 replication jobs. I would like to update a Status field to indicate what job should transfer/replicate information.

Example:
Job #1: Status = Ready, upon successful transfer, source doc Status updated to "Ready - Job 2"
Job #2: Status = Ready - Job 2, upon successful transfer, source doc Status updated to "Ready - Job 3"
Job #3: Status = Ready - Job 3, upon successful transfer, source doc Status updated to "Done"

Job #3 is the final job and sets the source document to done.

Is there a field on the Direct Transfer or Replication job that allows me to update the Source Document after successful insert/update/skip? If not, do I have to create a Script Activity to set a Status field?

Thanks in advance.

2

Hi Michael

If I'm understanding you correctly, you might be able to do what I do. I use LSX for push data from a Notes application into a Postgres database. When I do an insert or update, I get a status back on whether it was successful. You certainly should be able to use that status to flag that the next step in your process is ready to be performed or not.

Clem

3

Attempting to do this via the Replication or Direct Transfer activities.

4

At my last job, I used Notrix and it allowed you to set fields on the Source Document after it successfully transferred data to SQL. I set Status and Process Date fields. I was able to go back and see what was transferred that day.