The input tables are the tables from the SAP database which are used as the input tables for the SAP Connector. These tables are loaded either directly from the SAP database using the SAP or ODBC connection string type or with
.csv files uploaded to the UiPath Process Mining server using the Files connection string type.
There are two types of input tables:
For most of the input tables, only a subset of the available fields is used as datasource attributes in Process Mining.
When loading data directly from the SAP database, a query is used to load only the fields that are used in Process Mining. When loading data via
.csv files, you must make sure that all fields that are used in Process Mining are available in the
When loading data via
.csvfiles, it is strongly recommended that you only extract the fields that are required in Process Mining. Loading data that is not used in Process Mining will slow down the data load.
For some of the input tables, only a subset of the available records is used for Process Mining.
When loading data directly from the SAP database, a filter is applied to load only the records that are used in Process Mining. When loading data via
.csv files, it is advised to apply the filtering on the input tables, to limit the size of the input
.csv files. If this filtering is not applied at the moment of the data extraction, the required filtering will be applied in the connector in the first joins where the input tables are used.
If this filtering is not applied at the moment of the data extraction, the required filtering will be applied in the SAP Connector in the first joins where the input tables are used.
By default, input trimming is enabled for all attributes in all document tables and master data tables to avoid arbitrarily or unintended different events. This means that any leading or trailing blank spaces will be removed when the data is loaded. If needed you can disable the input trimming for individual datasource attributes.
Follow these steps to disable the input trimming for a datasource attribute.
Open the SAP Connector in your development environment.
Go to the Data tab and locate the 1. Input section.
Click on the input table that contains the attribute for which you want to disable the input trimming.
In the table items list on the right, double click on the appropriate datasource attribute.
In the Edit Datasource Attribute dialog disable the Trim input check box in the Parse format panel.
See illustration below for an example.
Updated 11 days ago