Resources
Help & Support ↗ Lucanet Learning Space ↗
Documentation
Getting Started
Global Functions
Lucanet Lume
Administration
Data Hub
Consolidation & Financial Planning
User Interface of Lucanet Consolidation & Financial Planning
General Functions
Basic Configuration
Dashboards
Reporting & Analyzing
Import and Journals
Journals
Importing Data into Reporting Entities
Importing data into Lucanet.Financial Warehouse
All Steps at a Glance
Defining a Data Source
Configuring Database Connections
Creating and Configuring Data Transformations
Creating and Configuring Execution Settings
Executing the Data Import
Creating and Executing Scripts
Configuring Period Locks
Analyzing Databases
Planning
Consolidation
Dimensions
Excel-Integration
Workspace Configuration
Lease Accounting
Extended Planning & Analysis (xP&A)
ESG Reporting
Disclosure Management
XBRL Tagger
Tax Compliance & Reporting
Banking & Cash Management
Data Collection
Glossary

Configuring Database Connections

Overview

This section describes the parameters that must be specified for database connections to help importing data into Lucanet.Financial Warehouse.

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:

ElementDescription
AbasHost: 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 2Host: 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
InformixHost: 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 ServerHost: 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 SQLHost: 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
ODBCData 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
OracleHost: 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.
SAPHost: 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!

Testing a Database Connection in Lucanet Consolidation & Financial Planning

With the Test connection function, you can check whether Lucanet Consolidation & Financial Planning can establish a connection with the configured database. The Test connection button is available in the following places, both in view mode and in edit mode:

  • In the detail view of an element of type Connection
  • On the Database tab of a data source for importing data into Lucanet.Financial Warehouse
  • On the Lucanet.Financial Warehouse tab of a data source of type Lucanet.Financial Warehouse (#2068)

To test a database connection in Lucanet Consolidation & Financial Planning:

1

In the detail view of the connection or on the respective tab of the data source, click Test connection.

The Test connection dialog is displayed as follows, for example:

Shows the 'Test connection' dialog in Lucanet Consolidation & Financial Planning with the text 'Select where the connection test will be executed.', the mandatory 'Application' drop-down list with the value 'Execute on the server', and the 'Cancel' and 'Test connection' buttons.
'Test connection' dialog

If user name and password are required for the database, the dialog also contains fields for the credentials.

2

In the Application drop-down list, select where the connection test is to be executed:

  • Execute on the server (default): for databases that are reachable from Lucanet.Cloud, for example Lucanet.Financial Warehouse or a cloud ERP system
  • Name of a Lucanet.Script Execution Application (SEA): for databases in your local network, for example an on-premises ERP system. One entry is displayed per SEA that is created in your environment (see Installing and Updating Lucanet.Script Execution Application).
3

Click Test connection.

The result of the connection test is displayed. If you select Execute on the server for a database that can only be reached through an SEA, the connection test fails with a connection error.

This content was generated using AI and reviewed by Lucanet subject matter experts before publication.

Page IDKB4423105

Last updated on Oct 28, 2026

Table of Contents
OverviewConfiguring Connection InformationTesting a Database Connection in Lucanet Consolidation & Financial Planning
Related Articles

Company

Legal Notice

© Copyright 2026 - Lucanet AG