Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

Querying Your Data

    Querying Operational Insights from the Node.js SDK, with SQL++.

    SQL++ is a declarative query language for JSON data.

    Real-Time Data Analysis

    Traditionally, analyzing JSON data in NoSQL databases requires complex transformations (like flattening) to prepare it for analytics, causing delays and hindering real-time insights. Operational Insights eliminates these ETL complexities by unifying operational and analytical data stores into a single platform. This enables Zero ETL, reducing costs, complexity, and improving time to insight.

    Long Running Queries

    All versions of Operational Insights support long running client-side requests. This process keeps a connection live between client and server for long running queries. For such long running queries, a better mechanism is for the client to trigger an asynchronous query without holding a connection to the server open for the duration of the query execution. This Server Asynchronous API was introduced in Operational Insights Server 2.2. For more information, see Service APIs.

    After the query request is submitted, clients can monitor the status of the request and on successful execution of query, opt to stream the results of the query. This way the connection between SDK client and Operational Insights Server does not stay open for the long duration of query processing, and is only needed for result set streaming.

    cluster.startQuery() → QueryHandle → QueryStatus → QueryResultHandle

    This information flow can be seen in the sample code in the SQL++ queries section.

    Next Steps

    Dive right in with our practical examples.