process-mining
2022.10
false
Process Mining
Automation CloudAutomation Cloud Public SectorAutomation SuiteStandalone
Last updated Oct 17, 2024

Configuring CData Sync

Note: The information in this page is based on CData Sync 2022 - 22.0.8342.0. If you use an other version of CData Sync, field names or functions may be different.

Introduction

When DataBridgeAgent is used to extract data from the source system, the exported .tsv files are loaded into the Microsoft SQL Server database using CData Sync. This page describes how to use CData Sync to upload the data set generated by DataBridgeAgent to a process app in Process Mining Automation Suite.

In general, you should follow the steps as described in Loading Data using CData Syncto set up data loading using CData Sync.

However, some specific settings are required when using DataBridgeAgent.

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 - Loading data usign CData Sync - Setting up the Source Connection.

Creating the extraction job

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

See also:

  • Introduction
  • Setting up the source connection
  • Creating the extraction job

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.