Configuring Database Connections
Last updated on 2025-06-23
Overview
This section describes the parameters that must be specified for database connections to help importing data into Lucanet.Financial Warehouse.
This article contains the following sections:
Configuring Connection Information
You must configure one database connection for the temporary Lucanet.Financial Warehouse and one for the persistent Lucanet.Financial Warehouse when importing data into Lucanet.Financial Warehouse.
The following table shows the default parameters that must be specified depending on the chosen database:
Database
Parameter with description
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.
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