Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
yocaqlikview
New Contributor II

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
Employee
Employee

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

Hi,

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

Regards,

Hakan

yocaqlikview
New Contributor II

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

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, ...)

Employee
Employee

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

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

Community Browser