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.

• Query APIs: Interact with the query interface using REST or directly with the Service Gateway using q interprocess communication (QIPC).

  • REST v QIPC

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

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

• 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.