<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How I used QlikSense Enterprise as an AI orchestration layer — ETL, API trigger, visualization and pseudo real-time alerting in Integration, Extension &amp; APIs</title>
    <link>https://community.qlik.com/t5/Integration-Extension-APIs/How-I-used-QlikSense-Enterprise-as-an-AI-orchestration-layer-ETL/m-p/2546392#M22826</link>
    <description>&lt;P class=""&gt;Hi QlikSense Community,&lt;/P&gt;&lt;P class=""&gt;I'd like to share an architecture where QlikSense Enterprise on Windows plays a central role across four layers of an AI pipeline — not just visualization, but also data preparation, API orchestration, and pseudo real-time alerting via NPrinting.&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;Context&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;The project runs on a manufacturing production line. The goal is to detect machine drift automatically, before it impacts quality. The AI model is a &lt;STRONG&gt;LSTM autoencoder&lt;/STRONG&gt; — it learns the normal behavior of the machine and flags anomalies when the reconstruction error exceeds a threshold. The model is deployed as a REST API on private infrastructure.&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;4 roles for QlikSense Enterprise&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;1. ETL — Data preparation&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;QlikSense loads raw inspection files from a network folder, applies transformations and aggregations through its scripting engine, and stores results as QVD files. A listener mechanism at each reload detects whether incoming data has already been processed. If nothing is new, the reload is intentionally stopped so the app does not refresh unnecessarily — keeping the pipeline efficient and avoiding redundant API calls.&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;2. API trigger — Inference orchestration&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;QlikSense calls the LSTM autoencoder API via a native REST connection. It sends a sliding window of the most recent measurement points as input to the model. The call sequence is carefully designed so that only one request triggers inference — subsequent calls read results from the API without re-running the model, preserving the integrity of the AI state.&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;3. Visualization — Drift dashboard&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;Results returned by the API are stored as QVD files and loaded into a visualization app. Charts show the reconstruction error per feature over time, with detected drift sections highlighted. Timestamps are displayed in local timezone.&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;4. Pseudo real-time alerting — NPrinting&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;When drift is detected, an alert is automatically distributed via NPrinting. The reload cycle acts as the pseudo real-time trigger — each time a new file arrives from the machine, the pipeline runs end to end, and if the model detects a drift, NPrinting generates and distributes the report to the relevant recipients immediately. No manual intervention required.&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;Historical replay&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;To backfill historical data, a dedicated script loops over a historical QVD with a sliding window, calls the API for each window, and accumulates results progressively. The request rate is controlled to stay within API limits.&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;Key takeaway&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;QlikSense Enterprise is much more than a BI tool. With REST connections, scripting logic, QVD persistence, and NPrinting distribution, it can act as a complete lightweight orchestration layer for an AI pipeline — without any additional middleware, and within an on-premise environment.&lt;/P&gt;&lt;P class=""&gt;Happy to answer questions or share more details on any of the four layers.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Mhena_0-1775658012246.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/187688iDD2E4384C97BC717/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Mhena_0-1775658012246.png" alt="Mhena_0-1775658012246.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Mhena_1-1775658023016.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/187689iB4C21BB41B52F233/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Mhena_1-1775658023016.png" alt="Mhena_1-1775658023016.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Mhena_2-1775658054954.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/187690i1DD6E0FE5C121EBA/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Mhena_2-1775658054954.png" alt="Mhena_2-1775658054954.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 08 Apr 2026 14:23:08 GMT</pubDate>
    <dc:creator>Mhena</dc:creator>
    <dc:date>2026-04-08T14:23:08Z</dc:date>
    <item>
      <title>How I used QlikSense Enterprise as an AI orchestration layer — ETL, API trigger, visualization and pseudo real-time alerting</title>
      <link>https://community.qlik.com/t5/Integration-Extension-APIs/How-I-used-QlikSense-Enterprise-as-an-AI-orchestration-layer-ETL/m-p/2546392#M22826</link>
      <description>&lt;P class=""&gt;Hi QlikSense Community,&lt;/P&gt;&lt;P class=""&gt;I'd like to share an architecture where QlikSense Enterprise on Windows plays a central role across four layers of an AI pipeline — not just visualization, but also data preparation, API orchestration, and pseudo real-time alerting via NPrinting.&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;Context&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;The project runs on a manufacturing production line. The goal is to detect machine drift automatically, before it impacts quality. The AI model is a &lt;STRONG&gt;LSTM autoencoder&lt;/STRONG&gt; — it learns the normal behavior of the machine and flags anomalies when the reconstruction error exceeds a threshold. The model is deployed as a REST API on private infrastructure.&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;4 roles for QlikSense Enterprise&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;1. ETL — Data preparation&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;QlikSense loads raw inspection files from a network folder, applies transformations and aggregations through its scripting engine, and stores results as QVD files. A listener mechanism at each reload detects whether incoming data has already been processed. If nothing is new, the reload is intentionally stopped so the app does not refresh unnecessarily — keeping the pipeline efficient and avoiding redundant API calls.&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;2. API trigger — Inference orchestration&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;QlikSense calls the LSTM autoencoder API via a native REST connection. It sends a sliding window of the most recent measurement points as input to the model. The call sequence is carefully designed so that only one request triggers inference — subsequent calls read results from the API without re-running the model, preserving the integrity of the AI state.&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;3. Visualization — Drift dashboard&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;Results returned by the API are stored as QVD files and loaded into a visualization app. Charts show the reconstruction error per feature over time, with detected drift sections highlighted. Timestamps are displayed in local timezone.&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;4. Pseudo real-time alerting — NPrinting&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;When drift is detected, an alert is automatically distributed via NPrinting. The reload cycle acts as the pseudo real-time trigger — each time a new file arrives from the machine, the pipeline runs end to end, and if the model detects a drift, NPrinting generates and distributes the report to the relevant recipients immediately. No manual intervention required.&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;Historical replay&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;To backfill historical data, a dedicated script loops over a historical QVD with a sliding window, calls the API for each window, and accumulates results progressively. The request rate is controlled to stay within API limits.&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;Key takeaway&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;QlikSense Enterprise is much more than a BI tool. With REST connections, scripting logic, QVD persistence, and NPrinting distribution, it can act as a complete lightweight orchestration layer for an AI pipeline — without any additional middleware, and within an on-premise environment.&lt;/P&gt;&lt;P class=""&gt;Happy to answer questions or share more details on any of the four layers.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Mhena_0-1775658012246.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/187688iDD2E4384C97BC717/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Mhena_0-1775658012246.png" alt="Mhena_0-1775658012246.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Mhena_1-1775658023016.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/187689iB4C21BB41B52F233/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Mhena_1-1775658023016.png" alt="Mhena_1-1775658023016.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Mhena_2-1775658054954.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/187690i1DD6E0FE5C121EBA/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Mhena_2-1775658054954.png" alt="Mhena_2-1775658054954.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 08 Apr 2026 14:23:08 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Integration-Extension-APIs/How-I-used-QlikSense-Enterprise-as-an-AI-orchestration-layer-ETL/m-p/2546392#M22826</guid>
      <dc:creator>Mhena</dc:creator>
      <dc:date>2026-04-08T14:23:08Z</dc:date>
    </item>
  </channel>
</rss>

