kdb+

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

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

Creating a kdb+ connection

When the plugin is installed, Agent Management 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 (Agent Management 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 Agent Management cannot write datasets back to kdb+ through this connection.