# CSV file connection

> If you want to generate the heatmap, using CSV files downloaded from SAP, follow the procedures below:

If you want to generate the heatmap, using CSV files downloaded from SAP, follow the procedures below:

* [1. Download CSV file from SAP](https://docs.uipath.com/test-manager/automation-suite/2.2510/user-guide/connection-with-csv-file#1-download-csv-file-from-sap)
* [2. Create the SAP connection](https://docs.uipath.com/test-manager/automation-suite/2.2510/user-guide/connection-with-csv-file#2-create-the-sap-connection)

## 1. Download CSV file from SAP

Here's how to download the CSV file from SAP, that you can later upload in Test Manager and generate a heatmap based on it.

1. Go to SAP and execute transaction `sa38`.

   You land on the **ABAP: Program Execution** page, where `Z_UIPATH_CUST_HEATMAP_DOWNLOAD` is typed in **Program**.
2. Run the program `Z_UIPATH_CUST_HEATMAP_DOWNLOAD`.
3. Select the proper tab to generate and download a CSV file from one day, one week, or one month.

   ![docs image](https://dev-assets.cms.uipath.com/assets/images/test-manager/test-manager-docs-image-254832-5a03ac4c-1ad7adc4.webp)

4. Go to the bottom right of SAP, and then click **Execute**.
5. The CSV file is downloaded on your machine in the following directory: `C:\Temp\`.

   :::tip
   In the **Parameters** tab you can configure your own weighting for the heatmap ratios, and change the path where the CSV file is downloaded.
   :::

   ![docs image](https://dev-assets.cms.uipath.com/assets/images/test-manager/test-manager-docs-image-254837-a0866176-83eac149.webp)

## 2. Create the SAP connection

To create an integration between your Test Manager project and your SAP system by uploading CSV files with SAP data:

1. Open your project in Test Manager, go to **Project Settings**, then to the **Integration** tab.
2. Select **SAP** from the **New Connection** dropdown list. The **Edit connection** dialog pops up.
3. Fill in the fields according to the data from your SAP system:
   * **Name** - Name the integration between Test Manager and SAP.
   8 **Description** - Describe the integration between Test Manager and SAP.
4. From **Data Source** select **Upload From CSV**.
5. Find the CSV file downloaded from SAP [here](https://docs.uipath.com/test-manager/automation-suite/2.2510/user-guide/connection-with-csv-file#1-download-csv-file-from-sap).  Add it to **Add CSV here**.

![Create new connection uploading a CSV file](https://dev-assets.cms.uipath.com/assets/images/test-manager/test-manager-create-new-connection-uploading-a-csv-file-552236-b3a31ac1-02e624ea.webp)
