Target SQL Integration

[Jose Garcia 4]

We have an integration that updates various SQL tables using Scribe Insight 7.9.5. The integration works well. It runs on demand and is tightly controlled and monitored by users, however as we have other apps that tap the same database, occasionally another user can get in and disrupt the integration process and flow. With that in mind, is there a way through Scribe to apply a table lock on the target tables. We'll want to activate the lock upon initiation of the integration and release upon conclusion.

Would appreciate any advice. Look forward to a response.

 

JG