Installing and Updating Lucanet.Script Execution Application

Getting Started

Global Functions

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

User Interface of Lucanet Consolidation & Financial Planning

General Functions

Basic Configuration

Changing the Data Model Language of Consolidation & Financial Planning

Installing and Updating Lucanet.Script Execution Application

Configuring Attributes

Dashboards

Reporting & Analyzing

Import and Journals

Planning

Consolidation

Dimensions

Excel-Integration

Workspace Configuration

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

Lucanet.Script Execution Application ( SEA for short) is a Lucanet application that you need if you operate ERP/financial source systems on-premises and want to import data from these systems into the Lucanet CFO Solution Platform using an ETL script.

SEA must be installed as a system service in your local environment via Lucanet.Software Manager to enable communication with the source system. That means SEA must be installed in the same network as the source system or the source file. The application executes the required scripts locally to extract, transform, and load data from local ERP/financial systems. Subsequently, the data is securely transferred to Lucanet.Financial OLAP Server or Lucanet.Financial Warehouse in the AWS cloud.

Lucanet.Software Manager 11 is required for the installation and use of Lucanet SEA.

The installation and configuration of SEA is carried out in the following steps:

To create an SEA instance in the Lucanet CFO Solution Platform, proceed as follows:

If necessary, click Administration in the main menu.

Click Platform management | Certificates. The Certificates workspace is displayed as follows, for example:

Click Generate instance.

Enter the name of the instance in the displayed Generate instance dialog.

Click Generate. The instance is created and displayed in the overview.

Click the three-dot icon of the corresponding instance to open the context menu.

Click Download sender to save the sender certificate locally as a ZIP file.

Click Download receiver to save the receiver certificate locally as a ZIP file.

More Information about the Certificates workspace in the Lucanet CFO Solution Platform can be found under Generating and Downloading SEA Certificates.

To install Lucanet.Script Execution Application as a system service in Lucanet.Software Manager:

If necessary, update Lucanet.Software Manager to version 11.

Start Lucanet.Software Manager.

Click the Install application tab.

Retain the Retrieve application from Lucanet.Youniverse presetting and click Next.

Choose Lucanet.Script Execution Application and click Continue. Lucanet.Software Manager displays the Settings:

Installing SEA in Lucanet.Software Manager

If necessary, change the name in the Name input field.

Choose the latest version from the Version drop-down list.

From the drop-down list Download from, choose from which download server SEA should be installed. The following options are available:

Choose

Determine fastest connection automatically

if Lucanet.Software Manager shall determine the download server automatically.

Choose the desired download server from the drop-down list.

After Configuration file, upload the ZIP file for the Receiver certificate that you downloaded from the CFO Solution Platform in step 1.

Define how the service is to be started. Do one of the following:

Choose

Automatic

if the service is to be started automatically when starting the computer.

Choose

Manually

if the service is to be started manually.

Activate the Start service after installation check box if the service is to be started after installation.

Click Install.

The Lucanet.Script Execution Application is installed on your computer as a system service.

Click Finished when the message Installation completed is displayed.

Before an SEA instance can be used to execute ETL scripts, it must first be created as an application in the Consolidation & Financial Planning solution in the CFO Solution Platform. To do so, proceed as follows:

Click Consolidation & Financial Planning in the main menu to open the solution.

Navigate to the Imports and Journals | Scripts workspace.

Click Applications. The Create new application dialog is displayed as follows, for example:

Click Browse or use the drag-and-drop function in the Archive key file area to upload the ZIP file for the Sender certificate that you downloaded from the CFO Solution Platform in step 1.

Click Save. The SEA application is created and displayed in the Applications list.

If the ETL script used for data import from the source system into Lucanet.Financial OLAP Server or Lucanet.Financial Warehouse is to be executed via an SEA application, you must assign the SEA application to the script in the configuration of the data sources.