Skip to main content

Sample connection strings and syntax

This topic provides sample connection strings and syntax for common drivers. Note that although the examples include sensitive information in the connection strings, due to a known issue with sensitive information being exposed as plain text, such information (for example, passwords, tokens, and so on) should not be included in the connection string. Instead, it should be specified in the Encrypted Properties fields, as in the following example:

Information noteIn future, this content will be available in Qlik Community only.
Connection string and syntax examples
Name Version Connection String Database required Schema required

Delimiter Start

Delimiter End Syntax Example
MariaDB 3.01.17 SERVER=<SERVER>; PORT=3306; DATABASE=<DBNAME>;uid=<username>;pwd=<password>;   No ` `

SELECT ${COLUMN_LIST}
FROM ${TABLE_NAME} ${FILTER} LIMIT 50

LIB CONNECT TO 'Vera''s GODBC:Maria_db_ODBC_(via_Direct_Access_gateway)';

LOAD id, 

numericcol,  numericPrecisionOverflowcol,  numericScaleOverflowcol,  numericp34s0col,  numericp34s20col;

[datatype_numeric_table]:[datatype_numeric_table]:

SELECT id,

numericcol, numericPrecisionOverflowcol, numericScaleOverflowcol, numericp34s0col, numericp34s20col

FROM `datatype_numeric_table`;

DB2 11.05.8000.317 Server=<servername>;Port=50000;DATABASE=<DBNAME>;uid=<username>;pwd=<password>;   Yes " "

SELECT ${COLUMN_LIST}
FROM ${TABLE_NAME} ${FILTER} LIMIT 50

 
Pivotal Greenplum 7.10.06.455 Server=<servername>;Port=5432;DATABASE=<DBNAME>;uid=<username>;pwd=<password>;   Yes " "

SELECT ${COLUMN_LIST}
FROM ${TABLE_NAME} ${FILTER} LIMIT 50

LIB CONNECT TO 'Vera''s GODBC:Green_ODBC_(via_Direct_Access_gateway)';

LOAD a, 
b;

[bool]:
[bool]:

SELECT a,
b

FROM "datatypes_automation".bool;

Sybase ASE 22.00.8389 Server=<servername>;Port=5000;DATABASE=<DBNAME>;uid=<username>;pwd=<password>;    

[

] SELECT TOP ${COLUMN_LIST}
FROM ${TABLE_NAME} ${FILTER} LIMIT 50

LIB CONNECT TO 'Enterprise Connectors:Sybase_ODBC_(via_Direct_Access_gateway)';

LOAD A,  
B,  
C;

[test_table]: 
[test_table]: 
SELECT A, 
B, 

FROM [test_table];

SAP HANA 2.15.22.29501 uid=<username>;pwd=<password>;SERVERNODE=<server>:30015;   Yes " "

SELECT TOP ${COLUMN_LIST}
FROM ${TABLE_NAME} ${FILTER} LIMIT 50

LIB CONNECT TO 'Vera''s GODBC:Saphana_ODBC_(via_Direct_Access_gateway)';

LOAD ID, 
DATECOL, 
TIMECOL,  SECONDDATECOL,  TIMESTAMPCOL;

[Piggie_Table_4_DateTime]:[Piggie_Table_4_DateTime]:

SELECT ID,
DATECOL,
TIMECOL,
SECONDDATECOL, TIMESTAMPCOL

FROM "Z_QLIK_RnD"."Piggie_Table_4_DateTime";

MSSQL 17 (Custom)   Server=<servername>;Port=1433;DATABASE=<DBNAME>;uid=<username>;pwd=<password>; Yes Yes " "

SELECT TOP ${COLUMN_LIST} FROM ${TABLE_NAME} ${FILTER}

LIB CONNECT TO 'Vera''s GODBC:MSSQLODBC_(via_Direct_Access_gateway)';

LOAD id, 
bitcol, 
textcol, 
ntextcol;

[datatype_text]:
[datatype_text]:

SELECT id,
bitcol,
textcol,
ntextcol

FROM Northwind.dbo."datatype_text";

Vertica (Custom)   Server=<servername>;Port=5433;DATABASE=<DBNAME>;uid=<username>;pwd=<password>; No Yes " "

SELECT ${COLUMN_LIST} FROM ${TABLE_NAME} ${FILTER} LIMIT 50

LIB CONNECT TO 'vertica_ODBC_(via_Direct_Access_gateway)';

LOAD A, 
B, 
C, 
D, 
WHATT;

[new_table]:
[new_table]:

SELECT A,
B,
C,
D,
WHATT

FROM vmart."public"."new_table";

IBM Netezza (Custom)   DSN Yes Yes " " SELECT ${COLUMN_LIST} FROM ${TABLE_NAME} ${FILTER} LIMIT 50

LIB CONNECT TO 'Vera''s GODBC:Neteza_ODBC_(via_Direct_Access_gateway)';

LOAD A, 
B;

[TEST]:
[TEST]:

SELECT A,
B

FROM TEST.TEST;

PostgreSQL (Custom)   Server=<servername>;Port=5432;DATABASE=<DBNAME>;uid=<username>;pwd=<password>;schema=<schemaname>; Depends on the database configuration. Depends on the database configuration. " "

SELECT ${COLUMN_LIST} FROM ${TABLE_NAME} ${FILTER} LIMIT 50

LIB CONNECT TO 'Vera''s GODBC:1postgreODBC_(via_Direct_Access_gateway)';

LOAD id, 
boolcol;

[datatypes_bool]:
[datatypes_bool]:

SELECT id,
boolcol

FROM "public"."datatypes_bool";

MySQL   Server=<servername>;Port=3306;DATABASE=<DBNAME>;uid=<username>;pwd=<password>; Depends on the database configuration. Not supported. ` `

SELECT ${COLUMN_LIST} FROM ${TABLE_NAME} ${FILTER} LIMIT 50

LIB CONNECT TO 'mysql_ODBC_(via_Direct_Access_gateway)';

LOAD id, 
charcol, 
charExtcol, 
ncharcol, 
ncharUnicol, 
varcharcol, 
varcharExtcol, 
nvarcharcol, 
nvarcharUnicol;

[datatype_char_table]:
[datatype_char_table]:

SELECT id,
charcol,
charExtcol,
ncharcol,
ncharUnicol,
varcharcol,
varcharExtcol,
nvarcharcol, nvarcharUnicol

FROM `datatype_char_table`;

Oracle (Custom)  

DSN

connection string: pwd=ecPrivate123;

  Yes " " SELECT * FROM ${TABLE_NAME} ${FILTER} LIMIT 50  
IBM Informix (Custom)  

DSN

connection string: Delimident=Y;

  Yes " "

SELECT ${COLUMN_LIST} FROM ${TABLE_NAME} ${FILTER} LIMIT 50

 
IBM DB2 for iSeries   System=<servername>;Port=3306;DBQ=<DBQ>;uid=<username>;pwd=<password>;   Yes " "

SELECT ${COLUMN_LIST} FROM ${TABLE_NAME} ${FILTER} LIMIT 50

 LIB CONNECT TO 'Enterprise Connectors:DBi_ODBC_(via_Direct_Access_gateway)';

LOAD A,  
B;

[TEST]: 
[TEST]:

SELECT A, 

FROM
DAN.TEST;

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!