Process Mining
2022.10
false
Configuring CData Sync for TemplateOne - Automation Suite 2022.10
logo
Process Mining
Last updated Sep 21, 2023

Configuring CData Sync for TemplateOne

Introduction

Next to the Upload data option to load data for a TemplateOne process app, you can also use CData Sync to load data from files. This page describes how to use CData Sync to set up a source connection to load data from files into a Process Mining TemplateOne process app.

In general, when you want to use CData Sync to load data from files, you should follow the steps as described in Loading Data Using CData Sync to set up data loading using CData Sync.

Since specific settings are required when loading data from files into TemplateOne, pay attention to the steps described below.

TemplateOne Specific Steps When Configuring CData Sync

Step 2: Setting up the Source Connection

Select CSV as the source system to which you want to create a connection from the list, and make sure to define the settings as described in Loading Data Using CData Sync.

Step 4: Creating the Extraction Job - Step 7

On the Tables tab add a custom query that mirrors the output of the connector you are using.

For TemplateOne-SingleFile use the following query:

REPLICATE [Event_log_raw] SELECT * FROM [Event_log]REPLICATE [Event_log_raw] SELECT * FROM [Event_log]

For TemplateOne-MultiFiles use the following query:

REPLICATE [Event_log_raw] SELECT * FROM [Event_log];
REPLICATE [Cases_raw] SELECT * FROM [Cases];
REPLICATE [Tags_raw] SELECT * FROM [Tags]REPLICATE [Event_log_raw] SELECT * FROM [Event_log];
REPLICATE [Cases_raw] SELECT * FROM [Cases];
REPLICATE [Tags_raw] SELECT * FROM [Tags]
logo
Get The Help You Need
logo
Learning RPA - Automation Courses
logo
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2023 UiPath. All rights reserved.