You can enable Batch API Interoperability from Hub console. You can enable it on ORS within the Hub Console from within the Databases tool after selecting an ORS data source.
It configures the MDM back end process to enable both API calls to be made and managed, taking into account the fact that batch jobs may also be running.
Please refer below KB for more details,
Thanks Rajan for your response. The input for our process is JSON record. The BES REST call insert a single JSON record into more than 10 tables in MDM database based on the Business Entity configuration in provisioning tool.
By the time the input record gets inserted into DB, if any of the Child Match & Merge is running, then I think the match & merge might go incorrect as child table match & merge would be performed by including parent table foreign key. As the child table job is running, there are chances that the newly inserted record to get picked by the job and could be considered as a unique record.
Is there a way to hold BES REST data insertion until the time the hub console job is running. As the data insertion is real time process, we may not sure when we get input data from external systems. Can you please clarify me.
Did you consider invoking match/merge also real time followed by insert/update ?
If you've ESB layer, this can be orchestrated in ESB layer.
The record insertion will happen on real time. But the match/merge process carried out in hub console not on real time process. can you explain little more about ESB and where we can use it in the process.
ESB is Enterpries Service Bus ( example Tibco Business Works) which can recive request from source system and direct it to MDM BES end point. In that layer this can be orchestated like calling create/update first followed by a get to retrive any adiitional information needed then call Match/Merge request.
In our requirement, we are getting JSON input from Mirth tool to BES End Point and then the record will be inserted into MDM database. The Match&Merge job will run on regular interval(say for every one hour) and it will pick the new records and does the match&merge to create golden record.
So my question is, if any new record comes in when the Match&Merge job being executed(say for child table), will it create any issue. Please clarify me.