- Release notes
- Getting started
- Installation
- Configuration
- Integrations
- Authentication
- Working with Apps and Discovery Accelerators
- AppOne menus and dashboards
- AppOne setup
- TemplateOne 1.0.0 menus and dashboards
- TemplateOne 1.0.0 setup
- TemplateOne menus and fashboards
- TemplateOne 2021.4.0 setup
- Purchase to Pay Discovery Accelerator menus and dashboards
- Purchase to Pay Discovery Accelerator Setup
- Order to Cash Discovery Accelerator menus and dashboards
- Order to Cash Discovery Accelerator Setup
- Basic Connector for AppOne
- SAP Connectors
- Introduction to SAP Connector
- SAP input
- Checking the data in the SAP Connector
- Adding process specific tags to the SAP Connector for AppOne
- Adding process specific Due dates to the SAP Connector for AppOne
- Adding automation estimates to the SAP Connector for AppOne
- Adding attributes to the SAP Connector for AppOne
- Adding activities to the SAP Connector for AppOne
- Adding entities to the SAP Connector for AppOne
- SAP Order to Cash Connector for AppOne
- SAP Purchase to Pay Connector for AppOne
- SAP Connector for Purchase to Pay Discovery Accelerator
- SAP Connector for Order-to-Cash Discovery Accelerator
- Superadmin
- Dashboards and charts
- Tables and table items
- Application integrity
- How to ....
- Working with SQL connectors
- Introduction to SQL connectors
- Setting up a SQL connector
- CData Sync extractions
- Running a SQL connector
- Editing transformations
- Releasing a SQL Connector
- Scheduling data extraction
- Structure of transformations
- Using SQL connectors for released apps
- Generating a cache with scripts
- Setting up a local test environment
- Separate development and production environments
- Useful resources
Connection string tables
UiPath Process Mining uses connection strings to load data. Input tables are therefore also called Connection string tables. Connection string tables can be recognized by the Connection string icon.
Input tables can be connected to multiple types of data sources by using connection strings. Uploading a file automatically creates a connection string table.
Follow these steps to view the connection string.
Step |
Action |
---|---|
1 |
Go to the Data tab of your developer environment. |
2 |
Double-click on the table for which you want to view the connection string. The Edit Connection String Table dialog is opened showing the connection string. See the illustration below for an example. |
This string denotes that a file is loaded, where it is located, and how this file is parsed. This string is automatically generated when using the Upload a file… option.
Below is a description of the parameters of the connection string.
Parameter |
Description |
---|---|
driver |
Defines what type of data connection is created. In this case, `{mvfile |
mv-enable |
Enables you to disable a connection string. By default, this setting is set to
True . A connection string can be disabled by settings mv-enable to False. If not set, it will default to True .
|
filename |
Denotes the relative path to the location of the file. The root of this path is defined by the table scope of this table. The type of file is taken from the extension of the file. Note: instead of a relative path you can use a url, which enables you to load a file from a webserver via HTTPS. Since the `{mvfile
|
hasheader |
If True, the values in the first line of the file will be used as the names of the attributes. If False, all lines of the file will be parsed as values of the attributes, and the attributes will be automatically named (A1, A2, …). |
delim |
Contains the character that separates the fields in a line. For example tab, semicolon, comma, or space. This can either be the character itself, or the ASCII code of this character. To avoid confusion with characters also used in a connection string itself, the ASCII code (for example, 59) is used. |
quote |
Contains the character that encloses fields within the file. Usually, this is not necessary, and none can be used. Note: When fields can contain the
delim character, all fields within this column should be quoted using a character that is not used in the data fields.
|
encoding |
The encoding of the file defines how characters are parsed. Usually, this is UTF-8. |
Follow these steps to create a new table using a connection string.
Step |
Action |
---|---|
1 |
Right click in the Data tab and select New able - Connection string.... A connection string table
New_table is created in the Data tab.
|
2 |
Double-click on
New_table to open the Edit Connection String Table dialog.
|
3 |
Enter the connection string in the Connection String field. |
4 |
(Optionally) Enter a query the Query field. |