How to create a working ODBC Firebird connection using Qlik Data Gateway

[Andrea_Bertazzo]

Currently (March 2025) the ODBC connector package does not have a Qlik internal connector for Firebird. It is necessary to create a connection with a generic ODBC connection, following the steps in ODBC (via Direct Access gateway).

In this article, we provide suggestions on how to set the connection to import data and preview tables correctly.

1. It is possible to download an ODBC driver to create a DSN connection from Download Firebird-ODBC version 3.0 (github)
2. To make the connection work, share the C:/ and the Program File folders of the machine where the database is installed. Sharing only the drive itself (C:/) is insufficient. 
3. An example of the driver configuration:
   
   
   
   
4. In the Qlik Data Connection, add a connection string in this format:
   
   

   SYSTEM={Server IP};UID={dbAccount};PWD={db Pasword};DBNAME={Connection to file}.FDB;

   Example:
   
   

5. Select Custom SQL syntax, choose "  as Delimiters and fill SELECT statement template for Data Preview with:

   SELECT ${COLUMN_LIST} FROM ${TABLE_NAME}

   Example:
   
   
   
   

Environment

• Qlik Data Gateway