Configuring Database Connections

Getting Started

Global Functions

Administration

Extended Planning & Analysis (xP&A)

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

Planning

Consolidation

Dimensions

Excel-Integration

Workspace Configuration

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

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

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:

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

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

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

Database:: Name of the database

Additional URL parameters: No additional URL parameters are necessary for the use with Lucanet

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

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

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

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

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

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.

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!

Last updated on Aug 16, 2023

Configuring Database Connections

Overview

Configuring Connection Information

Overview

Configuring Connection Information

Abas

AS 400/DB 2

H2 (File-Based)

H2 (In-Memory)

Informix

MS SQL Server

My SQL

Additional URL parameters

ODBC

Oracle

SAP

Table of Contents

Company

Legal Notice

Table of Contents

Related Articles

Company

Legal Notice