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:
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} |
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} |
||
Pivotal Greenplum | 7.10.06.455 | Server=<servername>;Port=5432;DATABASE=<DBNAME>;uid=<username>;pwd=<password>; | Yes | " | " |
SELECT ${COLUMN_LIST} |
LIB CONNECT TO 'Vera''s GODBC:Green_ODBC_(via_Direct_Access_gateway)'; LOAD a, [bool]: SELECT a, 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, [test_table]: FROM [test_table]; |
||
SAP HANA | 2.15.22.29501 | uid=<username>;pwd=<password>;SERVERNODE=<server>:30015; | Yes | " | " |
SELECT TOP ${COLUMN_LIST} |
LIB CONNECT TO 'Vera''s GODBC:Saphana_ODBC_(via_Direct_Access_gateway)'; LOAD ID, [Piggie_Table_4_DateTime]:[Piggie_Table_4_DateTime]: SELECT ID, 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, [datatype_text]: SELECT id, 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, [new_table]: SELECT A, 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, [TEST]: SELECT A, 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, [datatypes_bool]: SELECT id, 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, [datatype_char_table]: SELECT id, 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, [TEST]: SELECT A, FROM |