Configuring Database Connections

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;​​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