---
title: "Initial Data Import from xP&A to CFP"
description: "Once the planning data is modeled in xP&A, you can then transfer this data into Consolidation & Financial Planning. \n\nCFP uses an import script (Lucanet xP&A #3700-xP&A.SQL.FOS) to read in xP&A exports."
source_url: https://support.lucanet.com/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/importing-data-from-xpa-to-cfp
language: en
last_updated: 2026-05-28
---
# Importing xP&A Data into Consolidation & Financial Planning for the First Time

## Overview

Once the planning data is modeled in xP&A, you can then transfer this data into Consolidation & Financial Planning.

CFP uses an import script (**Lucanet xP&A #3700-xP&A.SQL.FOS**) to read in xP&A exports.

The following sub-steps are necessary for importing data from xP&A to CFP:

{% stepper %}
{% stepper-step %}
[Create an export of the desired data in xP&A](https://support.lucanet.com/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/importing-data-from-xpa-to-cfp/creating-data-export-in-xPA-for-CFP.md) for each model you would like to import into CFP.
{% /stepper-step %}
{% stepper-step %}
[Create and configure the script Lucanet xP&A #3700-xP&A.SQL.FOS](https://support.lucanet.com/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/importing-data-from-xpa-to-cfp/creating-and-configuring-the-script-used-for-xPA-import.md). CFP uses this import script to read in the xP&A exports. Configuration is done in the script's settings before you execute an import.
{% /stepper-step %}
{% stepper-step %}
[Create and configure the data source](https://support.lucanet.com/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/importing-data-from-xpa-to-cfp/creating-and-cconfiguring-the-data-source-for_xPA-import.md) used for the import into CFP. In the data source configuration, you link the script and define certain parameters to be used for the import.
{% /stepper-step %}
{% stepper-step %}
[Create the assignment table](https://support.lucanet.com/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/importing-data-from-xpa-to-cfp/creating-an-assignment-table-for-import-of-xPA-data.md) used for the import into CFP.

This assigment table is the basis for assigning all elements imported from xP&A (e.g. accounts, cost centers, transaction currency, etc.) to elements in CFP.
{% /stepper-step %}
{% stepper-step %}
[Create and execute the data import](https://support.lucanet.com/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/importing-data-from-xpa-to-cfp/creating-and-executing-the-data-import-into-CFP.md) into CFP and assign the imported elements to the elements in CFP

The data import uses the data source that is linked to the xP&A script and the assigment table you defined for this purpose.

{% /stepper-step %}
{% /stepper %}
## Prerequisites

Before you configure the import into CFP, the following prerequisites must be met:

| Prerequisite | Description |
|---------|---------|
| **CFP version** | If you work with Consolidation & Financial Planning in Lucanet.Financial Client, the Lucanet version must be Lucanet 25 or higher. |
| **Script file** | The script **Lucanet xP&A #3700-xP&A.SQL.FOS** is available (e.g. via the partner portal or your Lucanet consultant). |
| **Java library** | The Java library athena-jdbc-3.4.0-with-dependencies.jar is added to the library of the CFP database (typically done by our Cloud Services or SRE team). |
| **Database connection (optional)** | For drill-down support and to avoid re-running the xP&A export on each import, a connection to an SQL database can be used as temporary storage. The connection information for Lucanet.Financial Warehouse can be used for this purpose. |