# Loading data via an ODBC connection

> Configuration steps for loading SAP Connector data via an ODBC connection in the SAP Purchase-to-Pay and SAP Order-to-Cash Connectors for AppOne in Process Mining standalone.

:::note
The information in this guide applies to the **SAP Purchase-to-Pay Connector for AppOne** and **SAP Order-to-Cash Connector for AppOne**.
:::

## Introduction

When you want to use the SAP Connector with data loaded via an ODBC connection you must configure this in the SAP Connector.

## Configure the SAP Connector for loading data via an ODBC connection

In order to load data correctly you must specify the following settings in the SAP Connector.

 <colgroup>
  <col/>
  <col/>
 </colgroup>
 
  
     SAP Setting  
     Description  
  
 
 
  
     ODBC Username  
     The username of the ODBC account.  
  
  
     ODBC Password  
     Either enter: 
      
         the password identifier from the credential store that contains the password of the ODBC account, 
      
 or 
      
         the password of the ODBC account in plain text. 
      
 See  Using a Credential store for password storage  .  
  
 

Follow these steps to set the enter the settings for the SAP Connection in the SAP Connector.

| Step | Action |
| --- | --- |
| 1 | Make sure the input type is set to use an ODBC connection. See [Loading data](https://docs.uipath.com/process-mining/standalone/2021.10/user-guide/sap-loading-data#loading-data-in-the-sap-connector-for-appone). |
| 2 | Open the SAP Connector in your development environment. |
| 3 | Go to the **Data** tab and select the **Connector_settings** table. |
| 4 | Edit the expressions in the **ODBC Settings** folder to enter the correct values.  See the illustration below. |

![docs image](https://dev-assets.cms.uipath.com/assets/images/process-mining/process-mining-docs-image-53411-290f506c-b6a8ab4e.webp)

:::note
The provided settings are used by the `ODBC Connection string` expression.
:::

### Using a Credential store for password storage

A Credential store allows you to use passwords without showing the actual password. For the ODBC connection from the SAP Connector to the SAP database it is also possible to use a Credential store to store the actual password of the SAP account in a secured way.

:::note
By default, a password identifier from the Credential store is configured in the SAP Connector. If you do not use a Credential store you must adapt the `SAP Connection string` expression accordingly. See the illustration below.
:::

![docs image](https://dev-assets.cms.uipath.com/assets/images/process-mining/process-mining-docs-image-53303-1c3d4669-399bc34d.webp)