SAP Data Service (BODS) How to lock table (even from read during job run)

[aczeitner]

Hey Specs !

We area loading from BW to SQL server 14.0.3421.10 (staging tables) with BODS.

We have been asked to put lock on the target tables (staging tables) to forbid other sessions even from read because on some occasion the target system started to load their staging tables sooner to their propagation layer.

We are loading their staging layer in a very big job it runs 4 hours therefore what would be required is to lock the target table at the begginning of the job, and remove the lock at the end.

My question is there a standard way in BODS to lock the tables included in the job ?

If not is there a non standard way to lock tables if the target system is sql server (used with ODBC connector).

I've tried this method and it is actually working on sql server side, but i am not sure if this is the best approach from bods, especially because if you write a table in the standard way it commits in every 1000 records

locking - SQL Server : lock table to block other sessions trying to read the table - Stack Overflow

Thanks

[CobyKako · Accepted solution]

Hello,

Your question pertains to SAP Data Services, right?

Please use this channel: All Questions in SAP Data Services | SAP Community

Thanks,

Jacob

[aczeitner · Accepted solution]

Err Sorry I am somewhat unfamiliar with the page. Isn't this page the same page that we are right now ?
Sorry I am very confused what did i do wrong / where should I put my question because it seems to me the same page.

(where should I go and click on ask question).

Thanks for the help.

[CobyKako · Accepted solution]

SAP Data Services and SAP Big Data Services are two distinct products in our portfolio:

• SAP Data Services | SAP Help Portal
• SAP Big Data Services 2022 | SAP Help Portal

Each product has a separate community forum. Please use the appropriate forum when submitting your Data Services questions.

Hope this answers your concern.