はじめに

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.

Excel files

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

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

テキスト ファイル

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

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

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.

The table below contains example connection strings for ODBC connections.

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

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

📘

注:

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.

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 のデータソースに使用できるパラメーターの概要は以下のとおりです。

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

📘

注:

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.