Subscribe

UiPath Process Mining

The UiPath Process Mining Guide

Retrieving the SQL Server database parameters

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 in Process Mining (Automation Suite).

  2. Create a new process app, or Upload data if you want to upload data for a published process app, and select Upload data using an 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.
    (Click on image to copy the parameter to the clipboard.)

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. See Setting up a SQL Server account for data upload using CData Sync.

Retrieving the API url

To load data using CData Sync you need to API url. Follow this step to retrieve the API url.

  1. Copy the url of the Upload data using extractor page.
StepAction
1Copy the url of the 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 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

Updated about a month ago

Retrieving the SQL Server database parameters


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.