Qlik

Demonstration on how to connect between AnyLog and Qlik BI REST service

Qlik is a data integration, analytics, and artificial intelligence platform. Using their REST connector plugin, users are able to pull data from AnyLog/EdgeLake and use it to generate insight on their data.

Requirements

  1. An active AnyLog network
  2. A subscription with Qlik

Preparing the Environment

  1. From Home goto Create
  2. In Create we want to use the Analytics App
  3. Data is coming from Files & Other Data Sources <img src=”/assets/external-docs/imgs/qlik1.png” height=50% width=50% alt=”source options” />
  4. We use a standard REST <img src=”/assets/external-docs/imgs/qlik2.png” height=50% width=50% alt=”source options” />

For this demo we’ll be creating REST connections for increments and period function respectively. The main components of the REST interface delt with are the URL bar and cURL request headers.

| <img src=”/assets/external-docs/imgs/qlik3.png” height=50% width=50% /> | <img src=”/assets/external-docs/imgs/qlik4.png” height=50% width=50% /> | |:————————————————-:|:————————————————-:|

Increments Data

The increments function is used to segment time-series data into fixed, contiguous time intervals (e.g., every 5 minutes, every hour, every day).

  1. For the URL specify the REST IP and port of the node to send the request against <img src=”/assets/external-docs/imgs/qlik5.png” height=50% width=50% />

  2. In the headers section add the following params:
    • command: sql nov format=json and stat=false and include=(t2) and extend=(@table_name) "select increments(second, 1, timestamp), min(timestamp) as timestamp, min(value) as min_val, avg(value) as avg_val, max(value) as max_val from t1 WHERE timestamp >= NOW() - 15 minutes ORDER BY timestamp"
    • User-Agent: AnyLog/1.23
    • destination: network <img src=”/assets/external-docs/imgs/qlik6.png” height=50% width=50% />

  3. Validate the data and continue <img src=”/assets/external-docs/imgs/qlik7_increments.png” height=50% width=50% />

  4. Create a new Analytics <img src=”/assets/external-docs/imgs/qlik8.png” height=50% width=50% />

  5. Create a graph based on the given Dimensions <img src=”/assets/external-docs/imgs/qlik9_increments.png” height=50% width=50% />

Period Data

The period function finds the first occurrence of data before or at a specified date (and if a filter-criteria is specified, the occurrence needs to satisfy the filter-criteria) and considers the readings in a period of time which is measured by the type of the time interval (Minutes, Hours, Days, Weeks, Months or Years) and the number of units of the time interval (i.e. 3 days - whereas time-interval is day and unit is 3).

  1. For the URL specify the REST IP and port of the node to send the request against <img src=”/assets/external-docs/imgs/qlik5.png” height=50% width=50% />

  2. In the headers section add the following params:
    • command: sql nov format=json and stat=false and include=(t2) and extend=(@table_name) "select timestamp, value from t1 where period(minute, 1, now(), timestamp) order by timestamp"
    • User-Agent: AnyLog/1.23
    • destination: network <img src=”/assets/external-docs/imgs/qlik6.png” height=50% width=50% />

  3. Validate the data and continue <img src=”/assets/external-docs/imgs/qlik7_period.png” height=50% width=50% />

  4. Create a new Analytics <img src=”/assets/external-docs/imgs/qlik8.png” height=50% width=50% />

  5. Create a graph based on the given Dimensions <img src=”/assets/external-docs/imgs/qlik9_period.png” height=50% width=50% />