Process Mining
2021.10
false
- 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
Process Mining
Last updated Sep 21, 2023
Scheduling Data Extraction
Introduction
This page describes how to schedule data extraction when running a SQL connector
Prerequisites
The development tools described in Setting up a local test environment should be installed before continuing.
The connector should be set up as described in Setting up a SQL connector.
Schedule a Task for the Extraction
To schedule the data extraction at regular intervals:
- Use Windows Task Scheduler to schedule a task that calls
run.ps1
located in thescripts/
directory of a connector. -
Set the desired scheduling parameters, to run the script at the desired moments.
Note: The user that is used to execute the scripts, must have permissions to access the connector folder and the Process Mining installation directory. Moreover, the user must be able to access the source system and the staging database.