Why It Matters
Duplicating business logic across platforms creates governance risk and maintenance overhead
Teams that can use their preferred tools are more productive and more likely to act on data
Reusing existing Qlik security rules eliminates a significant IT administration burden
One source of truth across all tools means consistent answers to consistent questions
The Problem: Qlik Is Your Source of Truth, But Not Everyone Stays in Qlik
You have invested significant effort building clean, efficient, and governed data models in Qlik Sense. The associative data model, business rules, and scripting logic all live there. But your Sales team wants Power BI. Finance wants Excel. HR wants Tableau. And IT keeps getting requests to replicate that same logic in each of those platforms separately.
Every time you duplicate your Qlik logic elsewhere, you create a second version of the truth, and with it the risk of inconsistency, maintenance overhead, and loss of governance. The inProcess ODBC Driver solves this without forcing anyone to change their tool.
What the inProcess ODBC Driver Does
The inProcess ODBC Driver for Qlik Sense is a standalone connector that gives any ODBC-compatible tool direct access to your Qlik production data models. Teams work in the platform of their choice. The data they access is the same governed, staged data already in Qlik, served through Qlik’s own engine, with Qlik’s own security rules enforced.
Key capabilities include:
• Works with any ODBC-compatible analytics tool
• Access staged Qlik production data models without going through the Qlik Hub
• Preserves the single source of control and Qlik’s associative data model
• Can be combined with inProcess Data Factory for a complete data management solution
Compatible With the Tools Your Teams Already Use
If it can connect to an ODBC source, it can connect to your Qlik data models. The inProcess ODBC Driver is compatible with Microsoft Excel for spreadsheet analysis and reporting, Power BI for business intelligence and dashboards, Tableau for data visualization, SAS for statistical analysis, and SSRS for SQL-based reporting. Any tool in your organization’s analytics stack that supports an ODBC connection gains immediate access to your governed Qlik data.
This means your teams stop waiting for IT to replicate data models across platforms and start working with current, governed data in the tools they already know. Adoption increases because the barrier to access is removed. Governance is maintained because the data still flows from a single, controlled source.
Security: Already Handled
The inProcess ODBC Driver uses Qlik itself to service data requests. That means the same security rules already configured in the Qlik Management Console apply automatically to any developer or analyst accessing data through the driver. No parallel security setup. No new access control framework. Administration fits seamlessly into your existing Qlik workflow.
For IT and data governance teams, this is significant. Extending Qlik data access to new tools typically raises questions about entitlement management and access drift. The ODBC driver eliminates those concerns by design, ensuring that data access policies remain centralized in the QMC regardless of how many tools or users are connecting.
Why IPC Global Built This
Over more than a decade of Qlik implementations, IPC Global consistently saw the same challenge: clients using Qlik as their data warehouse wanted to extend that value to users on other platforms without losing the business logic and governance they had built. Replicating Qlik’s scripting and associative model in Power BI or Tableau is costly and introduces drift over time.
The inProcess ODBC Driver is the direct answer to that challenge. It brings the power of the Qlik data model to every analytics user in the organization, regardless of which tool they prefer. If you want to extend your Qlik investment to every analytics user, our team can show you how the inProcess ODBC Driver integrates with your existing Qlik environment in minutes.
Who This Is Built For
The inProcess ODBC Driver is designed for Qlik administrators, data architects, and IT leaders who are responsible for maintaining a governed analytics environment while meeting demand from teams that prefer working in other tools. It is equally valuable for business analysts, finance teams, and operational users who need access to governed Qlik data in Excel, Power BI, Tableau, or SAS without waiting for IT to build and maintain separate integrations.
If You Only Do Three Things
Stop replicating Qlik business logic in other tools and use the ODBC driver to share one version of the truth
Let teams use their preferred analytics tools without sacrificing data governance
Leverage your existing Qlik security rules with no new access control setup required
Extract Data from Your Qlik Models with the inProcess ODBC Driver
Qlik is your single source of truth, but your teams want to work in Excel, Power BI, Tableau, and SAS. The inProcess ODBC Driver lets them. Same data, same business logic, any tool.
June 15, 2020
4 min read
Qlik
Related Insights
Qlik
4 min read
Extract Data from Your Qlik Models with the inProcess ODBC Driver
Qlik is your single source of truth, but your teams want to work in Excel, Power BI, Tableau, and SAS. The inProcess ODBC Driver lets them. Same data, same business logic, any tool.