Create a source connection

Note: Refer to the Configuring CData Sync page for 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.

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 click on + Add More to display a list of all available source CData Sync Connectors. Select the connector for your source system and click on Download & Install.
2	Enter a descriptive name for the source connection in the 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 Connection Settings panel to make sure the data is properly loaded into Process Mining.

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