Configuring Database Connections

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;​​verifyServer​Certificate=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.

Additional URL parameters: No additional URL parameters are necessary for the use with Lucanet

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!

Language:: Two letters that stand for the language of the SAP system; (see also SAP Language Code List – 2-letter vs. internal 1char code) 

Note: The specified language has no effect on the import data because the language for the data import can be configured only with a separate configuration parameter of the import script if the respective import script supports the import of different languages.

Client: Three numbers that represent the client to whom a connection is to be established

unicode: Activates the use of the Unicode character set; default: Yes

validateQuery: Activates basic checks for SAP queries; default: Yes

debugHandleContent: Activates the logging of the query results

Note: The log file on large systems will be enlarged considerably and may reduce the performance for the client by activating the debugHandleContent parameter; default: No

Additional URL parameters: No additional URL parameters are necessary for the use with Lucanet