Connect Qlik Sense or QlikView to Delta Forge through the generic ODBC connector.
Data load editor > Create new connection > ODBC## Setup 1. Install the Delta Forge ODBC Driver. On Qlik Sense Enterprise, install on the host running the Qlik Engine service; on Qlik Cloud, install through a configured Data Gateway. 2. In **Data load editor** -> **Data connections**, click **Create new connection** and pick **ODBC**. 3. Choose **DeltaForge ODBC Driver** from the driver list, fill in `Server`, `Uid`, `Pwd`. 4. Save with a connection name; reference it in the load script as `LIB CONNECT TO '<name>'`. ## Load script Qlik scripts in either **SQL** mode (passes through to the driver) or **load** mode (Qlik does the parsing). For Delta Forge work, use **SQL** mode and let the engine handle filtering and aggregation; pulling raw rows for Qlik to crunch defeats the purpose of a columnar engine. ## QVD caching The `STORE ... INTO [lib://...]` form materialises a result into a Qlik Data file. Subsequent reloads can read from the QVD without round-tripping to Delta Forge. This is the canonical pattern for incremental loads: ``` // Step 1: load only new rows from the engine fact_orders_delta: SQL SELECT * FROM analytics.marts.fact_orders WHERE order_date > $(vLastLoadDate); // Step 2: append to the cached QVD LOAD * FROM [lib://qvd/fact_orders.qvd] (qvd); STORE fact_orders_delta INTO [lib://qvd/fact_orders.qvd] (qvd); ``` ## Generic mode Qlik's generic ODBC connector handles standard types correctly; the driver returns lengths, scales, and nullability honestly so Qlik infers the field metadata without manual override. If a particular field is mis-typed in Qlik (rare), use `CAST(col AS BIGINT)` in the SQL to force the desired type. ## Service account Qlik Sense runs queries as the service account. If the password is stored in the user keychain, the service cannot read it. Either set `Pwd=` on the connection in Qlik (which encrypts it in Qlik's connection store) or store the credential under the service account.
// Qlik load script
LIB CONNECT TO 'DeltaForge ODBC';
fact_orders:
SQL
SELECT *
FROM analytics.marts.fact_orders
WHERE order_date >= MakeDate(2026, 1, 1);
STORE fact_orders INTO [lib://qvd/fact_orders.qvd] (qvd);