- Release notes
- Before you begin
- Getting started
- Integrations
- Working with process apps
- Working with dashboards and charts
- Working with process graphs
- Working with Discover process models and Import BPMN models
- Showing or hiding the menu
- Context information
- Export
- Filters
- Sending automation ideas to UiPath® Automation Hub
- Tags
- Due dates
- Compare
- Conformance checking
- Root cause analysis
- Simulating automation potential
- Starting a Task Mining project from Process Mining
- Triggering an automation from a process app
- Viewing Process data
- Creating apps
- Loading data
- Customizing process apps
- Publishing process apps
- App templates
- Overview of generic menus and dashboards
- Menu Overview
- Menu Analysis
- Event log input fields
- Custom process input fields
- Configuring CData Sync for Event log or Custom process
- Additional resources
Configuring CData Sync for Event log or Custom process
Next to the Upload data option to load data for an Event log or a Custom process app, you can also use CData Sync to load data from files.
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, pay attention to the steps described below.
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 - Create a Source Connection.
Once the job is correctly setup, create a Custom Query paste the following queries (each query needs to maintain the semicolon at the end). Make sure you save all changes. See Loading Data Using CData Sync- Create a Job.
For Event log use the following query:
REPLICATE [Event_log_raw] SELECT * FROM [Event_log]
REPLICATE [Event_log_raw] SELECT * FROM [Event_log]
For Custom process use the following query:
REPLICATE [Event_log_raw] SELECT * FROM [Event_log];
REPLICATE [Cases_raw] SELECT * FROM [Cases];
REPLICATE [Due_dates_raw] SELECT * FROM [Due_dates];
REPLICATE [Tags_raw] SELECT * FROM [Tags]
REPLICATE [Event_log_raw] SELECT * FROM [Event_log];
REPLICATE [Cases_raw] SELECT * FROM [Cases];
REPLICATE [Due_dates_raw] SELECT * FROM [Due_dates];
REPLICATE [Tags_raw] SELECT * FROM [Tags]