kdb+

DSS can read tables from kdb+ through an experimental SQL dialect.

This capability is provided by the kdb+ plugin, which you need to install. Please see Installing plugins.

Creating a kdb+ connection

When the plugin is installed, DSS exposes a dedicated KDB+ connection type in SQL Databases.

Use this connection type as the recommended setup.

In this form, you can either:

  • Fill the Host and Port fields (DSS builds the JDBC URL as jdbc:q:HOST:PORT), or

  • Enable custom JDBC URL and set it manually.

After creating the connection, you can create SQL datasets on kdb+ tables.

Querying kdb+

You can query kdb+ datasets with SQL. You can also write q code by prefixing the query with q).

Limitations

The kdb+ connection is read-only. You can read tables and query results from kdb+, but DSS cannot write datasets back to kdb+ through this connection.