Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Is it possible to load data from SAP R/3 without lock the tables?

We want to load information from SAP R/3 thorugh SAP Connector.

Is it possible to load data from SAP R/3 without lock the tables?

How can we manage it?

3 Replies
Hakan_Ronningberg

Hi,

The SQL connector does not lock any tables when extracting from them. The SQL connector never updates tables.

Regards,

Hakan

Anonymous
Not applicable
Author

Hi Hakan, thanks for your answer.

So, you confirm us that the SAP R/3 transactions wont be affected in any way by the extracting of the tables through SAP Connector? (Orders, Billing, ...)

Hakan_Ronningberg

Hi,

When the SQL connector executes the SQL statement, there is no action performed to lock the table(s) involved. So it should not affect SAP R/3 transactions using the same table(s). If SAP R/3 transactions updates a table at the same time as the SQL connector is reading from it, the data extracted may of course be affected.

Regards,

Hakan