Technical Specifications & Compatibility
Technical Module Name
Supported Odoo Versions
v19.0
License
v1.0.0
Deployment Support
Odoo OnlineOdoo.shOn Premise
Lines of Code
256 lines (Python / XML / JS)
Overview & Description
v1.0.0 Qlik REST Connector Integrate Odoo seamlessly with Qlik Sense and QlikView. Expose any Odoo data model as a secure, high-performance REST API endpoint without any third-party middleware. Developed by Aura Odoo Tech Odoo 19.0 Ready Enterprise & Community Secure Token Auth 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. Dynamic Model Export Select any standard Odoo model (e.g., Sales Orders, Invoices, Partners, Stock Moves) and instantly expose its fields to Qlik. Granular Field Selection Improve query performance by choosing exactly which fields to include in the JSON output, skipping heavy or binary fields. Flexible Domain Filtering Configure specific search conditions directly on the table configuration to pull only relevant business records. Token-Based Security Each endpoint is protected by a cryptographically secure token. Unauthorized URL requests are automatically rejected. Built-in Pagination Supports limit and offset parameters natively to query large datasets in manageable pages, preventing timeouts. Performance Logging Track the call count and timestamp of the last data pull directly from the endpoint configuration dashboard. Business Benefits Zero Middleware Overhead Eliminate intermediate CSV file exports, ETL tools, or custom database connectors. Secure, direct HTTPS data transfer. Real-time Analytics Ready Qlik pulls data directly from Odoo via secure endpoints, allowing your BI dashboards to reflect the latest operations. Optimized Performance Expose only the fields and rows needed. Reduce CPU and RAM overhead compared to dumping complete database schemas. Highly Secure & Isolated Public authentication with high-entropy token URLs ensures only designated parties can load your backend model records. Module Screenshots Qlik Table Configuration Dashboard Secure REST URL Copy-Clipboard Dialog 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: Configuration Field Value / Setting URL Paste the REST URL copied from Odoo (e.g., https://<your-domain>/qlik/api/v1/data/<token>) Method GET Authentication Schema Anonymous Managed via Token URL HTTP Protocol Auto or HTTP/1.1 Request/Response Encoding utf-8 Key Generation Strategy Sequence or None XML DTD Support None Certificate Validation Enabled (Checked) Pagination Type None (For large datasets, see the script logic below) 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 Navigate to Qlik Connector Menu Open the Odoo backend and go to the Qlik Connector > Qlik Tables menu. Configure Table Parameters Select the target Model, choose specific fields, and construct optional Domain filters. Copy the REST URL Save the configuration. The module generates a cryptographically secure token and REST endpoint URL. Technical Details Technical Parameter Details Odoo Model qlik.connector.table HTTP Route Path /qlik/api/v1/data/<string:token> HTTP Method Allowed GET Default Page Size Limit 1,000 records (configurable up to 10,000) Output Formats Dynamic flat JSON array (many2one fields resolved automatically to ID/Name fields) Header Output Includes X-Total-Count header for full table size metadata Compatibility Odoo v19.0 Fully compatible with python virtual environments (pyenv) Supported Editions Odoo Community Edition Odoo Enterprise Edition Odoo.sh or Self-Hosted deployments Installation Guide Copy the module folder qlik_connector_aura into your custom addons directory. Update your Odoo configuration file to reference the correct addons path. Activate Developer Mode in your Odoo database, go to Apps > Update Apps List. Search for Odoo Qlik Connector and click Install. Frequently Asked Questions Yes. Each endpoint is authenticated by a highly secure 24-character hex token in the URL. If the token is modified or inactive, the server immediately denies access with a 401 Unauthorized response. Many2one relationships are automatically flattened into two separate JSON properties in the response: the raw ID value and a companion string with the display name (e.g. customer_id and customer_id_name), making it easy to map in Qlik. Yes. For databases exceeding 10,000 records, you must implement the offset-based paging logic inside the Qlik load script. This divides queries into pages, avoiding memory issues and timeout failures. Changelog v1.0.0 (Release) Initial release of the Qlik REST Connector module. Implemented secure model configurations, column mappings, pagination support, and seamless token regeneration action. Professional Support Facing issues with configuration, custom fields, or pagination script mapping in Qlik? We are here to help! Visit Our Website Email Support Copyright © Aura Odoo Tech. All rights reserved.
Key Capabilities & Features
- Navigate to Qlik Connector Menu Open the Odoo backend and go to the Qlik Connector > Qlik Tables menu.
- Configure Table Parameters Select the target Model, choose specific fields, and construct optional Domain filters.
- Copy the REST URL Save the configuration. The module generates a cryptographically secure token and REST endpoint URL.
- Odoo v19.0
- Fully compatible with python virtual environments (pyenv)
- Odoo Community Edition
- Odoo Enterprise Edition
- Odoo.sh or Self-Hosted deployments
- Copy the module folder qlik_connector_aura into your custom addons directory.
- Update your Odoo configuration file to reference the correct addons path.
- Activate Developer Mode in your Odoo database, go to Apps > Update Apps List.
- Search for Odoo Qlik Connector and click Install.
- The author can leave a single reply to each comment.
- This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
- If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
Screenshots & Previews
1 image availableExpand Preview
The AuraOdoo Quality Guarantee
100% Tested
Verified with Odoo 17, 18, and 19 test pipelines for stability and no conflicts.
Clean Architecture
Built according to official Odoo guidelines and PEP 8 standards with zero bloat.
Dedicated Support
Free installation assistance and quick bug turnaround from our team.