Finalize the processing of the integration
- Last UpdatedJul 13, 2023
- 1 minute read
This section describes how to “mark” that AVEVA™ Production Management has completed the processing of a record in an external database. This configuration depends on the design of how to know if the record is processed. Most times, you specify a parameter to the Update Command to explain which record has just been processed.
Scenarios
These two scenarios show how you can finalize the integration.
Scenario 1
The external table has an IsProcessed column that is required to update to True.
-
The Update Command would be
Update [Example4] Set IsProcessed = 1 where Id = @Id
where the @id is the id of the record just processed.
-
In this case, create one Update Database Parameter for Id.
Scenario 2
Another design is that you cannot change the external table to include an IsProcessed column, so you create a table to identify which records are processed. The table has only one column called Id, and if the table has a record for a specific Id, then it is processed.
-
The Update Command would be
Insert into Example4Processed (Id) Values (@Id)
where the @id is the id of the record just processed.
-
In this case, create one Update Database Parameter for Id.