process-mining
2023.4
false
Process Mining
Automation CloudAutomation Cloud Public SectorAutomation SuiteStandalone
Last updated Oct 17, 2024

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.

Follow these steps to set up the source connection.

Step

Action

1In 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.
2Enter a descriptive name for the source connection in the Connection Name field.
3Enter the required properties to set up a connection with your source system.
4Create 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.
SectionParameterValue
SchemaType Detection SchemeNone
Data FormattingPush Empty Values As NullTrue

Miscellaneous

Exclude File ExtensionsTrue
MiscellaneousInclude FilesAdd ,TSV to the setting if you want to upload .tsv files
  • Setting up a source connection for .csv or .tsv files

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.