Q has limited support for ODBC. In general, ODBC is not recommended for large databases – for performance reasons – but may be acceptable for small databases, or for one-off data import and export.
- in Windows and Linux, kdb+ can use ODBC to access a non-kdb+ database
Interfaces: Q client for ODBC
- in Windows only, a non-kdb+ client can use ODBC to access a kdb+ database
Interfaces: Simba/Magnitude ODBC drivers
Interfaces: Q server for ODBC3
John Ludlow’s How to get kdb+ to talk to other databases
Charles Skelton’s Babel for kdb+ for a simpler alternative to ODBC