# Retrieving the SQL Server database parameters

> To load data for a **Process Mining** process app you need the following setup parameters for the SQL Server database.

## Introduction

To load data for a **Process Mining** process app you need the following setup parameters for the SQL Server database.

* `Server`
* `Database`
* `Schema`
* `Role`

## Retrieving the SQL Server database parameters

Follow these steps to retrieve the SQL Server database setup credentials.

1. Go to the [Process Mining portal](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/process-mining-portal#process-mining-portal) in Process Mining.
2. Creata a new app, or upload data if you want to upload data for a published process app, and select **Upload data using extractor** in the **Data source** step.
3. Open a text editor, for example, Notepad.
4. Copy the SQL Server database parameters from the **Upload data using extractor page** and paste the parameters in the Notepad file. (Select ![Copy icon](https://dev-assets.cms.uipath.com/assets/images/process-mining/process-mining-copy-icon-copy_uri-92f32e32-bc9078a8.png) to copy the parameter to the clipboard.)

Check out [Create new app wizard](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/create-new-app-wizard#create-new-app-wizard "The following sections describe the requirements to successfully import a BPMN 2.0 model for use in Process Mining.").

### SQL Server authentication

When using SQL Server Authentication, the *username* and *password* of the SQL Server user that has access to the **Process Mining** process app also must be provided. Check out [Setting up a SQL Server account for data upload using an extractor](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/setting-up-a-sql-server-account-for-data-upload-using-cdata-sync#setting-up-a-sql-server-account-for-data-upload-using-an-extractor).

## Retrieving the API url

To load data using an extractor, you need to API url. Follow this step to retrieve the API url.

1. Copy the url of the [Upload data using extractor](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/create-new-app-wizard#upload-data-using-extractor) page.

   | Step | Action |
   | --- | --- |
   | 1 | Copy the url of the [Upload data using extractor](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/create-new-app-wizard#upload-data-using-extractor) page. |

The url is of the following format: `https:/<server>/<org>/<tenant>/processMining_/apps/<appid>/extractor`

Using this url the API url will be: `https:/<server>/<org>/<tenant>/processMining_/api/v2/apps/<appid>/transform/unauthenticated`

### Example

When the url of the of the [Upload data using extractor](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/create-new-app-wizard#upload-data-using-extractor) page is: `https:/uipath_server.com/default/defaulttenant/processMining_/apps/be6ad2d6-04b5-4dd8-aafb-bb0a1e3a7a45/extractor` the API url that should be used is `https:/uipath_server.com/default/defaulttenant/processMining_/api/v2/apps/be6ad2d6-04b5-4dd8-aafb-bb0a1e3a7a45/transform/unauthenticated`