Documentation • Console / Connection overrides

Connection overrides

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