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