- Release notes
- Before you begin
- Getting started
- Managing access
- Working with process apps
- Creating process apps
- Loading data
- Uploading data
- Retrieving the SQL Server database parameters
- Setting up a SQL Server account for data upload using an extractor
- Loading data using Theobald Xtract Universal
- Customizing process apps
- Data transformations
- TemplateOne app template
- Purchase to Pay app template
- Order to Cash app template
- Basic troubleshooting guide
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.
Server
Database
Schema
Role
Follow these steps to retrieve the SQL Server database setup credentials.
- Go to the Process Mining portal in Process Mining (Automation Suite).
- Creating a new process app, or Uploading data if you want to upload data for a published process app, and select Upload data using an extractor in the Data source step.
- Open a text editor, for example, Notepad.
-
Copy the SQL Server database parameters from the Upload data using extractor page and paste the parameters in the Notepad file.
(Click on to copy the parameter to the clipboard.)
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 an extractor.
To load data using an extractor, you need to API url. Follow this step to retrieve the API url.
-
Copy the url of the Upload data using an extractor page.
Step
Action
1
Copy the url of the Upload data using an extractor page.
https:/<server>/<org>/<tenant>/processMining_/apps/<appid>/extractor
https:/<server>/<org>/<tenant>/processMining_/api/v2/apps/<appid>/transform/unauthenticated
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