To import data from various sources into the current Lucanet database, a data source must first be created. Depending on the origin of the data, different data source types are available.
1
Open the Importing data into reporting entities 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:
Dialog 'Create Data Source'
4
Choose the desired data source type from the Origin of the data drop-down list (see Available Data Source Types).
5
Specify the name of the data source in the Element name field.
6
Click Save or press Enter to create the data source.
7
The detail view of the data source is displayed. Configure the data source according to the selected type:
Data sources for Lucanet can be created in the Data Sources root folder. Depending on the origin of the data, different data source types are available. The configuration options vary depending on the selected type.
The following data source types are available:
Data source
Description
MS Excel file (.xls, .xlsx) (#1000)
Used for importing data from Excel files (e.g. Excel reporting packages)
Provision via script (#2075)
Used to import data via a script
Lucanet.Financial Warehouse (#2068)
Used to import data from Lucanet.Financial Warehouse
