# Create a source connection

> :::note
Refer to the **Configuring CData Sync** section in the documentation of your app template for specific settings for setting up the source connection.
:::
:::note
Check the CData Sync documentation for any specific settings or requirements for your source system.
:::

:::note
Refer to the **Configuring CData Sync** section in the documentation of your app template for specific settings for setting up the source connection.
:::
:::note
Check the CData Sync documentation for any specific settings or requirements for your source system.
:::

Follow these steps to set up the source connection.

 <colgroup>
  <col/>
  <col/>
 </colgroup>
 
  
    Step 
    Action 
  
 
 
  
    1 
    In the CData Sync Admin console, create a new Source connection for your source system. Note: If your source system is not in the list you can disable the Only installed option to display all available source systems. 
  
  
    2 
    Enter a descriptive name for the source connection in the Connection Name field . 
  
  
    3 
    Enter the required properties to set up a connection with your source system. 
  
  
    4 
    Create and Test the connection. 
  
 

## Setting up a source connection for .csv or .tsv files

If you want to set up a source connection to load data from `.csv` or `.tsv` files make sure to:

* Select **CSV** as the source system to which you want to create a connection from the list.
* Set the **URI** to the path where the `.csv` or `.tsv` files are stored.
* Set the correct **ConnectionType**. Use **Local** when the files are stored on the same server as CData Sync.
* Set **FMT** to the appropriate value used in the data files.

Define the following settings in the **Advanced** tab in the **New Connection** panel to make sure the data is properly loaded into **Process Mining**.

| **Section** | **Parameter** | **Value** |
| --- | --- | --- |
| Schema | Type Detection Scheme | `None` |
| Data Formatting | Push Empty Values As Null | `True` |
| Miscellaneous | Exclude File Extensions | `True` |
| Miscellaneous | Include Files | Add `,TSV` to the setting if you want to upload `.tsv` files |