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

[Anonymous]

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?

[Hakan_Ronningberg]

Hi,

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

Regards,

Hakan

[Anonymous]

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