topic Re: Is it possible to load data from SAP R/3 without lock the tables? in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-data-from-SAP-R-3-without-lock-the-tables/m-p/1332820#M1230618 <HTML><HEAD></HEAD><BODY><P>Hi Hakan, thanks for your answer.</P><P>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, ...) </P></BODY></HTML> Tue, 18 Apr 2017 14:05:01 GMT Anonymous 2017-04-18T14:05:01Z Is it possible to load data from SAP R/3 without lock the tables? https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-data-from-SAP-R-3-without-lock-the-tables/m-p/1332818#M1230615 <HTML><HEAD></HEAD><BODY><P>We want to load information from SAP R/3 thorugh SAP Connector.</P><P></P><P>Is it possible to load data from SAP R/3 without lock the tables?</P><P></P><P>How can we manage it?</P></BODY></HTML> Mon, 26 Jan 2026 21:26:37 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-data-from-SAP-R-3-without-lock-the-tables/m-p/1332818#M1230615 Anonymous 2026-01-26T21:26:37Z Re: Is it possible to load data from SAP R/3 without lock the tables? https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-data-from-SAP-R-3-without-lock-the-tables/m-p/1332819#M1230616 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The SQL connector does not lock any tables when extracting from them. The SQL connector never updates tables.</P><P></P><P>Regards,</P><P>Hakan</P></BODY></HTML> Tue, 18 Apr 2017 11:37:45 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-data-from-SAP-R-3-without-lock-the-tables/m-p/1332819#M1230616 Hakan_Ronningberg 2017-04-18T11:37:45Z Re: Is it possible to load data from SAP R/3 without lock the tables? https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-data-from-SAP-R-3-without-lock-the-tables/m-p/1332820#M1230618 <HTML><HEAD></HEAD><BODY><P>Hi Hakan, thanks for your answer.</P><P>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, ...) </P></BODY></HTML> Tue, 18 Apr 2017 14:05:01 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-data-from-SAP-R-3-without-lock-the-tables/m-p/1332820#M1230618 Anonymous 2017-04-18T14:05:01Z Re: Is it possible to load data from SAP R/3 without lock the tables? https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-data-from-SAP-R-3-without-lock-the-tables/m-p/1332821#M1230621 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>When the SQL connector executes the SQL statement, there is no action performed to lock the table(s) involved. So it should not affect <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SAP R/3 transactions</SPAN> using the same table(s). If <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SAP R/3 transactions</SPAN> updates a table at the same time as the SQL connector is reading from it, the data extracted may of course be affected.</P><P></P><P>Regards,</P><P>Hakan</P></BODY></HTML> Wed, 19 Apr 2017 06:37:46 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-data-from-SAP-R-3-without-lock-the-tables/m-p/1332821#M1230621 Hakan_Ronningberg 2017-04-19T06:37:46Z