- Hardware and Software Requirements
- Server Installation
- Updating the License
- Deploying the UiPath Process Mining Profiler
- Deploying a Connector (.mvp)
- Updating UiPath Process Mining
- Updating a Customized Version of an App or Discovery Accelerator
- Installing a Training Environment
- Set up Single Sign-on Through Azure Active Directory
- Set up Single Sign-on Through Integrated Windows Authentication
- Adding Superadmin AD Groups
- Adding End-user AD Groups
- Two-Factor Authentication
- Introduction to AppOne
- Analyzing Data in AppOne
- Overview of Menus and Dashboards in AppOne
- Introduction to Purchase-to-Pay Discovery Accelerator
- Analyzing Data With Purchase-to-Pay Discovery Accelerator
- Overview of Menus and Dashboards
- Menu Compliance
- Deploying the Basic Connector
- Introduction to Basic Connector
- Input Tables of the Basic Connector
- Adding Tags
- Adding Automation Estimates
- Adding Due Dates
- Adding Reference Models
- Setting up Actionable Insights
- Setting Collapsible Charts
- Using the Output Dataset in AppOne
- Output Tables of the Basic Connector
- Introduction to SAP Connector
- SAP Input
- Checking the Data in the SAP Connector
- Adding Process Specific Tags to the SAP Connector for AppOne
- Adding Process Specific Due Dates to the SAP Connector for AppOne
- Adding Automation Estimates to the SAP Connector for AppOne
- Adding Attributes to the SAP Connector for AppOne
- Adding Activities to the SAP Connector for AppOne
- Adding Entities to the SAP Connector for AppOne
- HTML Panels
- Migrating Legacy Charts to New Charts
- Join Tables
- Global Tables
- Introduction to Table Items
- Display Format
- Rebrand and Restyle Apps and Discovery Accelerators
- Use Sharding in Your Applications
- Create an Anonymized Dataset
- Set up Automated Data Refreshes
- Use an Access Matrix to Enable Role-Based Access to Data
- Introduction to SQL Connectors
- Setting up a SQL Connector
- CData Sync Extractions
- Running a SQL Connector
- Editing Transformations
- Releasing a SQL Connector
- Scheduling Data Extraction
- Structure of Transformations
- Using SQL Connectors for Released Apps
- Generating a Cache With Scripts
- Setting up a Local Test Environment
- Separate Development and Production Environments
Introduction to SQL Connectors
A connector handles the process of extracting data from a source system and transforming the data to make it usable for UiPath Process Mining. In a SQL connector, Extract and Transform are separate steps, of which the results are stored in the same database. Process Mining loads data from that database as input for the dashboards. See the illustration below.
A released app contains the dashboards definitions and covers all the steps to display the data into the dashboards.
In the Extract step, the data is extracted from the source system and stored in a database, without making any changes to the data (only filtering is applied to limit data necessary for the connector). The preferred extraction tool is CData Sync. Depending on the connector and source system, other tools may be used.
Transformations are applied to the data stored in the database to make sure the data adheres to a data schema which can be loaded in Process Mining.
In the Transform step, dbt is used to manage and run all the transformations, which are defined as queries in the Structured Query Language (SQL). Dbt is required for a SQL connector.
A SQL connector requires a Microsoft SQL Server database.
Available SQL Connectors
Refer to the Discover section in the Product lifecycle page for an overview of all supported apps, discovery accelerators, and connectors available for Process Mining.
If there is no connector available for your process, you can use the template connector in the devkit-connector that contains the basic setup for a SQL connector.
SQL Connector Development
Next to Microsoft SQL Server and dbt, when you want to develop a SQL connector, a code editor is necessary.
Editing the transformations and configurations.
Visual Studio Code, which integrates with other tools needed for SQL connector development.
Tracking changes and collaborating on the connector development.