# 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/2023.10/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/2023.10/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.The **Edit connection** dialog pops up.
3. Fill in the fields according to the data from your SAP system:
   1. **Name** - name the integration between Test Manager and SAP.
   2. **Description** - describe the integration between Test Manager and SAP.
4. Select **UploadFromCSV** from **Data Source**.
5. Find the CSV file downloaded from SAP [here](https://docs.uipath.com/test-manager/automation-suite/2023.10/user-guide/connection-with-csv-file#1-download-csv-file-from-sap) . Add it to **Add CSV here**.

![docs image](https://dev-assets.cms.uipath.com/assets/images/test-manager/test-manager-docs-image-138203-9503b1c5-590d6d92.webp)