Create a source connection

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

Follow these steps to set up the source connection.

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