---
title: "Defining a Data Source"
description: "To import data from various sources into the current Lucanet database, a data source must first be created."
source_url: https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/defining-data-source
language: en
last_updated: 2023-08-16
---
# Defining the Data Source for the Import

## Overview

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.

{% stepper %}
{% stepper-step %}
Open the **Importing data into reporting entities** 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:

Dialog 'Create Data Source'
{% /stepper-step %}
{% stepper-step %}
Choose the desired data source type from the **Origin of the data** drop-down list (see [Available Data Source Types](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/defining-data-source/.md#types)).
{% /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 %}
The detail view of the data source is displayed. Configure the data source according to the selected type:

- [MS Excel file (.xls, .xlsx) (#1000)](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/defining-data-source/data-source-excel.md)
- [Provision via script (#2075)](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/defining-data-source/data-source-script.md)
- [Lucanet.Financial Warehouse (#2068)](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/defining-data-source/data-source-lnfwh.md)
{% /stepper-step %}
{% /stepper %}

## Available Data Source Types

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 |