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