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.

This article contains the following sections:

Creating a Data Source

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

  1. Open the Importing data into Lucanet.Financial Warehouse workspace in the Import and Journals folder.
  2. 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
  3. The Create data source dialog is displayed.
  4. Specify the name of the data source in the Element name field.
  5. Click Save or press Enter to create the data source.
  6. In the detail view of the new data source, click Edit.
    Open the editing mode of a data source
  7. Then configure the data source (see Configuring a Data Source).
Configuring a Data Source
Configuration Tab

The following options must be specified on the Configuration tab:


Option

Description


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.

If you have set up and are using SEA, you must choose the created application (see Creating SEA Applications on the CFO Solution Platform) 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.


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).


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:


Option

Description


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.

In the section Configuring Database Connections, you can find a table with the default parameters that must be specified, depending on the selected database.


Test connection

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


Save

Saves the current settings