通知を受け取る

UiPath Process Mining

UiPath Process Mining ガイド

接続文字列の種類

はじめに

There are several types of connection strings that can be used. This guide describes the different connection string types.

ファイル

Files can be loaded into a table by setting a driver parameter of the connection string to {mvfile}.
driver={mvfile}
次の種類のファイルを読み込むことができます。

  • Excel Files .xls and .xlsx
  • Text Files .csv, .tsvand .txt

Additional parameters can be specified to load files.

Below is an overview of the generic parameters that are available or loading files.

ParameterDescription
filenameThis can either be a relative path to a file on the server, or an HTTP URL.
When the file is on the server, the file should be placed in the Development data or Server data tab, and the Table scope of the table must be set accordingly.
When you use an HTTP URL, you can specify the user and pass parameters for authentication.
extBy default the filename extension is used to determine the file type, but this can be overridden.
userThe username for the remote file when using an HTTP URL.
passThe password for the remote file when using an HTTP URL.

Excel files

Below is an overview of the additional parameters that can be used for loading Excel files.

ParameterDescription
sheetThe sheet or named range to import. For sheet names a dollar sign character should be appended at the end.
If not specified the first sheet is loaded.
firstcolumnThe first column to start from. The default setting is {autodetect}.
firstrowThe first row to start from. The default setting is {autodetect}.

The table below contains example connection strings for loading Excel files.

Connection stringLoads ...
'driver={mvfile}; filename=Data/Dataset.xlsx;'the first sheet of an Excel file
'driver={mvfile}; filename=Data/Dataset.xlsx; sheet=MySheet$;'the sheet named 'MySheet'

テキスト ファイル

Below is an overview of the additional parameters that can be used for loading Text files.

ParameterDescription
hasheaderWhether the first row of the file is a header row. The default setting is {true}.
delimThe delimiting character. The default setting is {tab}. For some special characters, for example semicolon, the ASCII value should be used.
quoteThe character used to quote values. The default setting is {autodetect}.
escapeThe character used to escape characters. The default setting is {none}, which only interprets two quote characters as one.
encodingThe encoding used in the file, e.g., UTF8, or LATIN1. The default setting is {UTF8}.

The table below contains example connection strings for loading text files.

Connection stringLoads a text file ...
'driver={mvfile}; filename=Textfile.txt; delim=,; quote=";'with comma (,) separators and " quotes
'driver={mvfile}; filename=Textfile.txt; delim=|; quote=";'with pipe (|) separators and " quotes
"driver={mvfile}; filename=Textfile.txt; delim=9; quote=';"with tab separators and ' quotes
'driver={mvfile}; filename=Textfile.txt; delim=59; quote=none;'with semicolon separators and no quotes
'driver={mvfile}; filename=Textfile.txt; delim=,; quote="; escape=\;'with comma (,) separators, " quotes and \ escape characters
'driver={mvfile}; filename=http://www.example.com/files/example.txt;'from a web server
'driver={mvfile}; filename=http://www.example.com/files/example.txt; User=Jane; mv-credential-Pass=example_com_credentials'from a web server with basic access authentication

ODBC

ODBC is used to connect to external data sources, usually databases. You can either do this using the operating system, such as the ODBC data sources manager within Microsoft Windows, or directly supply the connection string in the correct format.

It is possible that the ODBC driver needs a query to execute. The query that needs to be executed on the database can be supplied as a string in the Query field.
When testing an ODBC connection make sure that the Query field is filled in with a valid query.

🚧

注:

64 ビット バージョンを持つデータベースには、すべて ODBC 接続を使用してアクセスできます。必要な 64 ビット ODBC ドライバーを UiPath Process Mining サーバーにインストールし、サーバーがその特定のシステムにアクセスできる必要があります。

Below is an overview of the parameters that can be used for ODBC connections.

ParameterDescription
driverThe ODBC driver to use for this connection. Not needed when using the 'dsn' parameter.
dsnThe ODBC DSN to use for this connection. Not needed when using the 'driver' parameter.

Note: When setting up a DSN to use in the connection string, make sure it is a 64 bit System DSN.
userUsername to be used to connect to the external datasource.
passPassword to be used to connect to the external datasource.
other Any other parameters are passed as specified to the ODBC driver.

The table below contains example connection strings for ODBC connections.

Connection stringConnects ...
'Driver={SQL Server Native Client 11.0};Server=SERVERNAME;Database=MyDatabase;'to a SQL Server database
'Driver={Oracle in OraClient12Home1};Dbq=MyTSN;'to an Oracle database
'DSN=MyDSN; User=MyUser; Pass=MyPass;'using a configured DSN with a username and password

Both the Connection string and the Query field are expressions. For example, a connection string table to an imaginary database could be created.

以下の画像でご確認ください。

539

📘

注:

Data within the table can only be used when the table has been loaded. In this example, the Globals table is needed to use data from other tables.

ヒントとコツ

For connection string formats of other systems, consult the manufacturer of that system, or an online resource such as https://www.connectionstrings.com/.

If the user with access to the database is a Windows user, make sure that this Windows user:

  • is a service account and not an actual user.
  • has Read/Write access on the Process Mining installation folder.
  • is the user who runs the scripts (e.g. in the scheduled tasks) for data load.
  • is used to run the Application pool in IIS.

SAP HANA

You can use an ODBC connection to connect to SAP HANA.
Below is an example connection string for SAP HANA.

'Driver={HDBODBC};User=MyUser;Pass=MyPass;ServerNode=MyServer:30015;DatabaseName=TDB1'

📘

注:

Instead of connecting to an SAP database, it is recommended to use the SAP connection string type to connect to the SAP application server.

Generic scripts

You can use a connection string to run a script to load data from datasources.

🚧

注:

The script handler you want to run must be installed on the UiPath Process Mining server.

Files can be loaded into a table by setting the driver parameter of the connection string to {mvscript} and the script parameter to "generic":
driver={mvscript}; script=generic

📘

注:

You must specify the script parameters in the Query field using URL encoding.

Below is an overview of the parameters that can be specified in the Query field.

ParameterDescriptionMandatory/Optional
scriptTextThe text of the script.Mandatory
Note: only if scriptFile is not used.
scriptFileFilename from which to load the script. This can be a relative path to a file on the server.

When the file is on the server, the file should be placed in the Development data or Server data tab, and the Table scope of the table must be set accordingly.
Mandatory
Note: only if scriptText is not used.
inputDataA semicolon separated text with column headers that contains the input for the script.

Note: The csvtable function can be used to generate data in the correct format.
Mandatory
scriptTypeThe name of the handle to use as specified in the GenericScriptHandlers setting in the Server Settings.

Note: If scriptFile is specified, this will be automatically detected based on the file extension.
Optonal
argsCustomize the arguments to pass to the script.
This should be a JSON encoded list.

There are two special arguments; '<SCRIPT>', and '<INPUT>'. Occurrences of '<SCRIPT>' are replaced with the path to a script file, and occurrences of '<INPUT>' are replaced with the path to the input file. This enables you to customize the call to the script handler with additional arguments. The default is ["<SCRIPT>", "<INPUT>"].
Optional
debugPathAn absolute path to a folder.

If this parameter is specified, UiPath Process Mining will output the input file (as given to the external process), and the external process's output (as read from the external process standard output) in this folder for debugging purposes.
Optional

Below is an example of a simple query.

+'&scriptFile=' + urlencode("script.py")
+'&inputData='  + urlencode("a;b;c"+#10+"1;2;3"+#10+"4;5;6")

Below is an example of a more advanced query.

+'&scriptText=' + urlencode(/* your script as text */)
+'&scriptType=' + urlencode("HandlerName")
+'&inputData='  + urlencode(csvtable(
    "Case_ID", jsontolist(InputData_Case_ID)
    "Amount" , jsontolist(InputData_Amount)
))
+'&args='       + urlencode(listtojson(["<SCRIPT>", "--filename", "<INPUT>"]))

See also: Use Generic Script Datasources

SAP

SAP connection strings can be used to connect to an SAP application server, for example, such as SAP R3, SAP ERP, SAP ECC 5.0, SAP ECC 6.0, S/4HANA.

🚧

注:

The SAP NWRFC library must be installed on the UiPath Process Mining server to use a SAP datasource from the connection string.

SAP datasources can be loaded by setting the driver parameter of the connection string to {SAP}.
driver={SAP}

SAP のデータソースに使用できるパラメーターの概要は以下のとおりです。

ParameterDescriptionMandatory/Optional
HostThe hostname or IP address of the SAP application server.Mandatory
SystemNumberThe two-digit number between 00 and 99 that identifies the designated instance.Mandatory
FunctionModuleWhen setting up a native SAP extraction the SAP Z_XTRACT_IS_TABLE Function Module is required. If, for example, the Function Module is renamed in your SAP system, you can specify the correct name in the FunctionModule parameter in the SAP connection string.FunctionModule parameter.

Overrides the default Z_XTRACT_IS_TABLE function module that is used when querying this table.
Optional
UsernameThe username of the account that is being used to log in to the SAP instance.Mandatory
passThe password of the user above. Can be used in combination with the credential store, use mv-credential-pass in this case.Mandatory
clientThe client that is being used.Mandatory
LanguageThe language that is used when logging in.Mandatory

Below is an overview of the parameters that can be specified in the Query field.

ParameterDescriptionMandatory/Optional
tableThe SAP tablename from which the data must be loaded. For example EKPO.Mandatory
fieldsAn array of fields that will be retrieved from the SAP table specified in the table property.

Note: If the fields property is empty, all fields will be retrieved.
Mandatory
whereA where clause to retrieve a subset of a table.Optional
limitAn integer number that specifies a fixed number of records to be retrieved from the table.
Note: if limit is set to '0', there will be no limit.
Optional

📘

注:

Every field in SAP has a length. For performance reasons, make sure that the sum of all retrieved field lengths for a table does not exceed 512.

Below is an example of an SAP Connection string.

'Driver={SAP};Host=10.10.10.10;SystemNumber=00;Username=MyUser;pass=secretPassword;client=100;Language=EN'

Below are some example Queries.

QueryRetrieves...
'table=' + urlencode("EKPO")all fields of all records of table EKPO.
'table=' + urlencode("EKPO") + '&fields=' + urlencode(listtojson(["MANDT", "EBELN"]))the MANDT and EBELN field for all records of the EKPO table.
'table=' + urlencode("EKPO") + '&where=' + urlencode("EBELN = 4500000001")all fields from EKPO table where EBELN is equal to 4500000001.

3 か月前に更新

接続文字列の種類


改善の提案は、API リファレンスのページでは制限されています

改善を提案できるのは Markdown の本文コンテンツのみであり、API 仕様に行うことはできません。