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:
Element
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.
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!
This content was generated using AI and reviewed by Lucanet subject matter experts before publication.