Module Overview

The Qlik REST Connector is designed to bridge Odoo's robust database and Qlik's powerful business intelligence platforms. Instead of setting up complex SQL exports or expensive external sync tools, this module allows Odoo administrators to configure direct API endpoints for any internal Odoo model. Data is generated dynamically in standard JSON format, ready to be consumed by Qlik Sense, QlikView, or any other BI tool supporting REST connections.

Business Benefits

Module Screenshots

Qlik Sense / QlikView Connection Workflow

Step 1: Get the REST Endpoint URL

Copy the secure REST URL generated inside Odoo's Qlik Table configuration view.

Step 2: Configure the Qlik REST Connector

In Qlik Sense or QlikView, create a new REST Connection and apply the following parameters:

Step 3: Query Script and Loop Pagination

To avoid timeouts on large datasets, you can handle offset pagination in Qlik's Data Load Script. Paste the following script template inside Qlik's script editor:

// Initialize variables
LET vOffset = 0;
LET vStep = 1000; // Records per page
LET vContinue = 1;

DO WHILE vContinue = 1
    // Load current page
    TempTable:
    SQL SELECT * FROM JSON (wrap on) "root"
    WITH CONNECTION (
        URL "https://<your-domain>/qlik/api/v1/data/<your-token>?limit=$(vStep)&offset=$(vOffset)"
    );

    // Stop loop if fewer records than page size are fetched
    IF NoOfRows('TempTable') < vStep THEN
        LET vContinue = 0;
    END IF

    // Concatenate page to main table
    IF vOffset = 0 THEN
        MainTable: LOAD * RESIDENT TempTable;
    ELSE
        CONCATENATE (MainTable) LOAD * RESIDENT TempTable;
    END IF

    DROP TABLE TempTable;
    LET vOffset = vOffset + vStep;
LOOP

Configuration in Odoo

1. Navigate to Qlik Connector Menu

   Open the Odoo backend and go to the Qlik Connector > Qlik Tables menu.
2. Configure Table Parameters

   Select the target Model, choose specific fields, and construct optional Domain filters.
3. Copy the REST URL

   Save the configuration. The module generates a cryptographically secure token and REST endpoint URL.

Technical Details

Installation Guide

1. Copy the module folder qlik_connector_aura into your custom addons directory.
2. Update your Odoo configuration file to reference the correct addons path.
3. Activate Developer Mode in your Odoo database, go to Apps > Update Apps List.
4. Search for Odoo Qlik Connector and click Install.

Frequently Asked Questions

Changelog