Check gateway compatibility
Compatibility depends on backend, Datablau driver, client, and SQL dialect. Confirmed types include Oracle, Hive, MySQL, PostgreSQL, DB2, and Vertica; undocumented versions are not implied.
Build a validation matrix
| Dimension | Record |
|---|---|
| Backend | Type, deployment, charset, connection |
| Driver | Class, package, parameters |
| Client | Tool/BI product, runtime |
| SQL | Queries, paging, aggregates, functions, transactions, large fields |
| Policies | Column/table masking, rows, exceptions |
| Outcome | Connection, authentication, query, masking, audit |
Validate in order
- Connect as a least-privilege user.
- Query nonsensitive data for dialect/charset.
- Test one masking field against expected values.
- Add paging, aggregation, and large results.
- Correlate gateway and backend logs.
Versions, thresholds, and production readiness require actual test reports or product confirmation.