---
title: "Defining a Data Source"
source_url: https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-lnfwh/defining-data-source-lnfwh
language: en
last_updated: 2023-08-16
---
# Defining a Data Source

## Overview

In the **data source**, it is indirectly determined from which source system data are to be applied by specifying scripts. This is also where all transformation rules to be applied to the source data and the data for the Lucanet databases (temporary database for imports and Lucanet.Financial Warehouse) are specified.

## Creating a Data Source

To create a data source for importing data into Lucanet.Financial Warehouse:

{% stepper %}
{% stepper-step %}
Open the **Importing data into Lucanet.Financial Warehouse** workspace in the **Import and Journals** folder.
{% /stepper-step %}
{% stepper-step %}
Right-click **Data sources** and choose **Create | Data source** from the context menu in the tree view of the workspace.

Creating a new data source

{% /stepper-step %}
{% stepper-step %}
The **Create data source** dialog is displayed.
{% /stepper-step %}
{% stepper-step %}
Specify the name of the data source in the **Element name** field.
{% /stepper-step %}
{% stepper-step %}
Click **Save** or press **Enter** to create the data source.
{% /stepper-step %}
{% stepper-step %}
In the detail view of the new data source, click **Edit**.

Open the editing mode of a data source

{% /stepper-step %}
{% stepper-step %}
Then configure the data source (see **Configuring a Data Source**).

{% /stepper-step %}
{% /stepper %}
## Configuring a Data Source

### 'Configuration' Tab

The following options must be specified on the **Configuration** tab:

#### Add a script

**Script**: Scripts that are executed during the import to Lucanet.Financial Warehouse

All scripts from the **Scripts** workspace are available.

#### Application

Location where the script is to be executed.

{% warning-box %}
If you have set up and are using **SEA**, you must choose the created **application** (see [Creating SEA Applications on the CFO Solution Platform](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/basic-configuration-cfp/install-and-use-opsea.md#createApplication)) in the **Application** drop-down list.

**SEA** (Lucanet Script Execution Application) is a Lucanet application that is required when ERP/financial source systems are operated on-premises and data from these systems needs to be imported into the Lucanet CFO Solution Platform via script.
{% /warning-box %}

#### Add data transformation

Data transformations that are executed during the import to Lucanet.Financial Warehouse. All data transformations from the **Data transformation** folder are available (see [Creating Data Transformations](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-lnfwh/create-and-configure-data-transformation.md)).

### 'Database' Tab

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 options must be specified on the **Database** tab for both the temporary and persistent Lucanet.Financial Warehouse:

#### Database

The desired database system

#### Database parameters

Configuration of the required database parameters and the access data of the technical user ( **User** and **Password**)

The parameters to be specified depend on the chosen database.

{% info-box %}
In the section [Configuring Database Connections](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-lnfwh/defining-data-source-lnfwh/datenbankverbindungen-konfigurieren.md), you can find a table with the default parameters that must be specified, depending on the selected database.
{% /info-box %}

#### Test connection

Test whether a connection can be established with the configured database.

#### Create tables

Used to create all necessary tables in Lucanet.Financial Warehouse and in the temporary database for new imports.

If the tables already exist, they and their content are deleted by this action.

#### Save

Saves the current settings

### 'Uses' Tab

The elements that use the data source are displayed on the **Uses** tab.

You can open the respective element by clicking the link in the **Name** column.

'Uses' tab