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)