# CSV file connection

> Generate a Heatmap in Test Manager using CSV files downloaded from SAP, including file download and connection setup steps.

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.

   ![ABAP Program Execution page for Z_UIPATH_CUST_HEATMAP_DOWNLOAD in SAP](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 select **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.
   :::

   ![Parameters tab for configuring Heatmap ratios](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)

## Result

The SAP connection is created and the uploaded CSV data is used to generate the **Heatmap** in your Test Manager project.