# Configuring CData Sync for Event log or Custom process

> CData Sync configuration settings and steps for loading file-based data into an Event log or Custom process app on Automation Suite.

## Introduction

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](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/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 in the following sections.

## Event log or Custom process specific steps when configuring CData Sync

### 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 - Create a Source Connection](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/create-a-source-connection).

### Table replication

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**. Check out [Loading Data Using CData Sync- Create a Job](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/create-a-job).

For **Event log** use the following query:

```
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]
```