Connection overrides

Common parameters

• - engine - access/mysql/sqlserver/postgres...

 

List of supported engines (database types)

engine parameter	name of the database type
access	Access
cockroachdb	CockroachDB
csv	CSV
dbf	DBF (dBase,FoxPro)
excel	Excel
firebird	Firebird
greenplum	Greenplum
interbase	Interbase
localdb	LocalDB
mariadb	MariaDB
mysql	MySQL
nexusdb	NexusDB
nuodb	NuoDB
odbc	ODBC
pervasive	Pervasive PSQL
postgres	PostgreSQL
redshift	Amazon RedShift
siard	SIARD
sqlazure	Azure SQL Database
sqlce	SQL Server Compact (SQLCE)
sqlite	SQLite
sqlserver	SQL Server
verticaodbc	Vertica ODBC
vistadb	VistaDB
advantage	Sybase Advantage
filemaker	FileMaker
paradox	Paradox
quickbooks	QuickBooks

 

Relational database connection parameters

• - database - folder containing data files
• - server - name or IP address of the database server
• - port - server port used to connect
• - username - database user
• - password - user's password

ODBC connection parameters

• - odbcConnectMode - should we use saved ODBC connection or specify a connection string directly? (DSN/Connection string)
• - dsn - saved ODBC connection
• - odbcConnString - connection string
• - username - database user
• - password - user's password

Access

• - database - ACCDB or MDB database file
• - password - database password
• - access_sysdb - system database file
• - access_syslogin - system database username
• - access_syspassword - system database password

Azure SQL Database

• - server - full path to the database in the cloud (database-identifier.database.windows.net)
• - username - database user
• - password - user's password
• - database - name of Azure database
• - encrypted - true if connection should be encrypted
• - trust_server_certificate - true if we should trust server certificate

CSV

• - database - folder containing data files

DB2

• - standard relational connection parameters, listed on top of this page

DBF (Clipper, dBase, FoxBase, Visual FoxPro)

• - database - folder containing data files
• - charset - character set

Derby

• - database - folder containing data files

Excel

• - database - folder containing data files
• - first_row_columns - first row contains column names (true/false)
• - excel_version - XLSX or XLS (only for the target connection)

FileMaker

• - standard ODBC connection parameters, listed on top of this page

Firebird

• - standard relational connection parameters, listed on top of this page
• - sqlDialect - database dialect (1 or 3)
• - charset - character set used to encode data
• - client_library - full path to FBCLIENT.DLL
• - role - user role

Gupta

• - standard relational connection parameters, listed on top of this page

H2

• - database - full path to database file, without .mv.db extension
• - username - database user
• - password - user's password

HSQLDB

• - database - full path to database file, without extension
• - username - database user
• - password - user's password

Informix

• - standard ODBC connection parameters, listed on top of this page 

Ingres

• - standard relational connection parameters, listed on top of this page

Interbase

• - standard relational connection parameters, listed on top of this page
• - sqlDialect - database dialect (1 or 3)
• - charset - character set used to encode data
• - client_library - full path to GDS32.DLL or IBCLIENT64.DLL, depending on application architecture
• - role - user role

SQLExpress LocalDB

• - database - full path to .MDF database file
• - isWinAuth - true if Windows authentication is to be used, false if username/password combination
• - username - database user
• - password - user's password

MySQL & MariaDB

• - standard relational connection parameters, listed on top of this page

NexusDB

• - database - folder containing data files
• - username - database user
• - password - user's password

ODBC

• - standard ODBC connection parameters, listed on top of this page

Oracle

• - oracleDirect - true if connecting directly, false if connecting via Oracle Client (OCI)
• - sid_mode - service_name/sid
• - oracleConnectMode - authentication mode (Default/SysDba/SysOper)
• - database - folder containing data files
• - server - name or IP address of the database server
• - port - server port used to connect
• - username - database user
• - password - user's password

Oracle RDB

• - standard relational connection parameters, listed on top of this page

Paradox

• - database - folder containing data files
• - charset - character set

Pervasive

• - standard relational connection parameters, listed on top of this page

PostgreSQL

• - standard relational connection parameters, listed on top of this page

Progress

• - standard ODBC connection parameters, listed on top of this page

QuickBooks

• - standard ODBC connection parameters, listed on top of this page

SQL Compact (SQLCE)

• - database - full path to .SDF database file
• - password - user's password
• - max_db_size - maximum database file size in MB

SQL Server

• - server - name or IP address of the database server (if non-default instance is used, specify SERVERNAME\INSTANCENAME here)
• - isWinAuth - true if Windows authentication is to be used, false if username/password combination
• - username - database user
• - password - user's password
• - database - database name
• - netlib - network library to use (<default>, Named pipes, TCP/IP, Shared memory)
• - encrypted - true if connection should be encrypted
• - trust_server_certificate - true if we should trust server certificate

SQLite

• - database - full path to database file
• - password - user's password

Sybase Adaptive Server (ASE)

• - standard relational connection parameters, listed on top of this page 

Sybase Advantage

• - database - folder containing data files in direct mode, or full path to the ADD file in client mode
• - advantage_exclusive_lock - set to true if tables should be exclusively locked by our application
• - charset - character set used to encode data

Sybase SQL Anywhere (ASA)

• - server - name or IP address of the server computer
• - sybaseServerName - name of ASA database server
• - database - name of ASA database
• - username - database user
• - password - user's password
• - charset - character set used to encode data

Vertica

• - standard relational connection parameters, listed on top of this page 

VistaDB

• - database - full path to .vdb5 database file
• - password - encryption key