---
title: "Configuring Database Connections"
source_url: https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-lnfwh/defining-data-source-lnfwh/datenbankverbindungen-konfigurieren
language: en
last_updated: 2023-08-16
---
# 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:

#### 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](https://learn.microsoft.com/en-us/archive/technet-wiki/13106.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.

#### 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!