Skip to content

Query Methods Overview

This page provides an overview of the query methods available with kdb Insights Enterprise.

  • Web Interface: Use the Web Interface to create and build databases for the purpose of querying and visualizing data into dashboards.

  • kdb Visual Code Extension: Use the kdb Visual Studio Code Extension to run API queries, qSQL queries, SQL queries, and User-Defined Analytics (UDAs).

  • Scratchpad Query APIs: A set of APIs for programmatic interaction with the database, in the Scratchpad.

  • Query APIs: A set of APIs for interaction with a database using REST or directly with the Service Gateway using q interprocess communication (QIPC).

    • REST and QIPC

    • SQL Query: Use SQL to access a unified view of data. Query data across all tiers within a package simultaneously.

  • kdb Insights Query Clients:

    • KXI Python: Use KXI Python to run API queries, qSQL queries, SQL queries, and User-Defined Analytics (UDAs).

    • Java Interface Query API: Use the Java-based Query API to extract data from kdb Insights Enterprise over IPC.

    • KXI Command Line Interface: Use SQL to extract data from kdb Insights Enterprise.

    • Power Query Connector - Microsoft Power BI users can remotely connect, explore, query data, preview tables, and harness the power and performance of kdb Insights Enterprise analytics before importing datasets into Power BI for visualization.