---
url: >-
  /statelake/administering-statelake/designer/data-connections/db-database-connections/advanced-tab-db-database-connections.md
---

# Advanced Tab - DB (Database) Connections

The Advanced options for the DB Connection.

## Fields

| Field Name | Description |
|---|---|
| Max Transactions per update of ID fields | Used only when the **Use Custom ID Field** is selected on the related **DB Definition**. This setting controls the maximum number of ID’s included in the “IN” clause. 0 (zero) means there is no limit. Some database servers will impose a limit on an “IN” clause. |
| Read Isolation Level |   |
| Disable SQL Transactions | The default behaviour is to use **SQL Transaction**s to enable rollback. Tick this box to disable **SQL Transaction** rollback in the event of failed **Actions**. |
| Write Isolation Level |   |
| Don’t include this connection on the DB Pooling | Tick if this **DB Connection** is not to be included in the DB Pooling. When ticked, the DB Connection is not re-used and will be released after the **Action** execution. You will want to use this option for **ODBC** connections. |
| Other Parameters (Add/Delete) | Add or delete additional settings to send through to the database server. |
| Schemas | Specify a different active **Schema**, and alias for the **Schema**, from the default dbo. prefix for the database referenced by this connection. |
| Unicode Repertoire |   |