kdb+¶
Warning
Tier 2 support: Connection to kdb+ is Experimental and not fully supported
DSS has experimental support for reading tables from kdb+
Installing support¶
In order to enable support for kdb+, you must install the “kdb+” plugin. Please follow instructions from Installing plugins
Creating a kdb+ connection¶
Create a new “Other databases (JDBC)” connection
In driver class, use “kx.jdbc.jdbc”
In URL, use “jdbc:q:HOST:PORT”
In Dialect, use “kdb+”
You can now use kdb+ as a normal SQL database and create SQL datasets on it. Note that you can either write direct SQL or q code by prefixing your query by q)