SWOT DAM SQL Gateway: limits and exceptions
Last updated: 12 November 2026
The gateway fails safe in every case: it refuses or closes the session rather than let an unchecked statement through.
| Database | Limitation | What the application sees | What to do |
|---|---|---|---|
| Oracle | Native Network Encryption refused | Login refused | Use TCPS (TLS) |
| Oracle | Listener REDIRECT refused | Connection refused | Point the gateway at the serving instance or SCAN address |
| Oracle | A blocked result-size limit closes the session | Disconnect | Use ALERT instead of BLOCK |
| Oracle | Result-size limits count bytes, not rows | Limits by volume | Express Oracle limits in bytes |
| SQL Server | MARS: native engine refuses; Python engine supports it per listener (a request over about 16 KB closes the session) | Refused or disconnect | Python engine with MARS on, or MARS off |
| SQL Server | Windows-integrated logins not verified against a Windows domain | User looked up after login | Register the SPN and pilot |
| SQL Server | Extended Protection must be off | Login fails if on | Turn it off for gateway connections |
| SQL Server | TDS 8 strict encryption not supported | Login fails | Use Encrypt=Mandatory |
| SQL Server | .NET SqlClient, tedious and Go drivers not tested | Expected to work | Pilot first |
| SQL Server | Over 4,096 prepared handles per session | Oldest dropped; reuse refused | Reuse statements or reconnect |
| PostgreSQL | No client-certificate pass-through | Certificate login fails | Use SCRAM passwords |
| PostgreSQL | Channel binding with TLS on both legs | Default listener needs channel_binding=disable | Use the SCRAM terminate listener |
| PostgreSQL and MySQL | Statements prepared inside functions or procedures, run by name | Refused in protect mode | Prepare through the driver |
| MySQL | Pipelined commands run one at a time | Correct, no speed-up | None needed |
| MySQL | A blocked result-size limit closes the session | Error, then disconnect | Use ALERT |
| All | Export limits are per statement | Split exports recorded, not stopped | Combine with alerts |
| All | Risk scores refresh every few minutes | A newly flagged user can work for about 5 minutes | Shorten the refresh interval |
| All | Unusual SQL volume: over 200 new statement shapes per second are paced; statements over 1 MB are not analysed | Slower or unanalysed | Raise per-gateway limits |
| All | Long control-plane outage | Enforcement continues; audit events dropped once buffers fill, and counted | Size buffers; watch the counter |
| All | Not in scope: dynamic data masking in queries (test data masking scripts are available), killing connections from the gateway, cloud data warehouses | Separate roadmap |
Drivers or versions not listed on the product page: pilot first.