- 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
- 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
Introduction
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.
Extract
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.
Transform
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.
Database
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.
Tool |
Used for |
Recommended |
---|---|---|
Editor |
Editing the transformations and configurations. |
Visual Studio Code, which integrates with other tools needed for SQL connector development. |
Version control |
Tracking changes and collaborating on the connector development. |
Git. |