| Abas | Host: IP address or host name of the server
Port: Port of the server; default port: 6550
Database:: Name of the database
Additional URL parameters: No additional URL parameters are necessary for the use with Lucanet |
| AS 400/DB 2 | Host: IP address or host name of the server
Port: Port of the server; default port: 449
Database:: Name of the database
Additional URL parameters: No additional URL parameters are necessary for the use with Lucanet |
| H2 (File-Based) | Database file: Absolute path to the database file; Note: If the file is not present, it will be created as an empty H2 database file.
Additional URL parameters: No additional URL parameters are necessary for the use with Lucanet |
| H2 (In-Memory) | Database:: Name of the database
Additional URL parameters: No additional URL parameters are necessary for the use with Lucanet |
| Informix | Host: IP address or host name of the server
Port: Port of the server
Database:: Name of the database
Server: Name of the Informix server
Identifier in double quotes: Parameter to be defined if identifiers are parsed in double quotes
Additional URL parameters: No additional URL parameters are necessary for the use with Lucanet |
| MS SQL Server | Host: IP address or host name of the server
Port: Port of the server; default 1433 (see also: SQL Server: Frequently Used Ports↗)
Database:: Name of the database
Instance: Name of the instance; default: empty ( MSSQLSERVER is used)
Charset: Name of the character set used; default: empty (the character set of the database is used)
Additional URL parameters: If the SQL server is configured to accept only secure connections, you must add the following parameter: ssl=require |
| My SQL | Host: IP address or host name of the server
Port: Port of the server; default default port: 3306
Database: Name of the database
useUnicode: Activates the use of Unicode; default: Yes
characterEncoding: See default: empty
Additional URL parameters:
- Current MySQL versions often require a time zone setting: serverTimezone=UTC
- The following parameters can be used to resolve heap issues: defaultFetchSize=500;useCursorFetch=true
- If the SQL Server is set to accept only secure connections, you need to add the following parameters: useSSL=true;BrequireSSL=true;verifyServerCertificate=false |
| ODBC | Data source name: Name of the data source specified in the ODBC Data Source Administrator
Additional URL parameters: No additional URL parameters are necessary for the use with Lucanet |
| Oracle | Host: IP address or host name of the server
Port: Port of the server; default port: 1521
System ID (SID): SID of the server; usually three or four letters
Database:: Name of the database
Note: For some Oracle versions, the name must also be entered in the Schema field. |
| SAP | Host: IP address or host name of the server
Note: The use of route strings for SAProuter is also supported
Port: Port of the server; Does not normally have to be specified, because Lucanet chooses the port according to the instance number (33xx).
Instance number: Two numbers that represent the instance to which a connection is to be established.
Note: Do not use the three-digit SAP SID! |