Product Ideas

Share your suggestions and ideas. Vote on ideas you find valuable.

Set Isolation Level in Jet Analytics BC Connector

Currently, when pulling data in from BC to Jet Analytics, the isolation level on teh database defaults to read uncommitted.


As a result, its possible for uncommitted data that is either rolled back, or temporary is transferred to a data warehouse. in a large volume scenario with incremental loads, this can lead to bad data.


A suggestion to be able to set the isolation level to Read committed we can only transfer valid data.

  • Guest
  • Jun 10 2024
  • Attach files