Querying Your Data

    Querying Enterprise Analytics 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. Enterprise Analytics eliminates these ETL complexities by unifying operational and analytical data stores into a single platform. This enables Zero ETL, reducing costs and complexity, and improving time to insight.

    Long Running Queries

    All versions of Enterprise Analytics 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 Request API is introduced in Enterprise Analytics Server 2.2. For more information, see Enterprise Analytics REST API.

    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 Analytics Server does not stay open for the long duration of query processing, and is only needed for result set streaming.

    cluster.startQuery()QueryHandleQueryStatusQueryResultHandle

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

    Next Steps

    Dive right in with our practical examples.