Uipath Marketplace

サインイン

MarketplaceStudioソリューションXebia - Select Query Using OLED

はじめてのオートメーションをわずか数分で作成できます。Studio Web を試す

Xebia - Select Query Using OLED

Xebia - Select Query Using OLED

作成者: Xebia

StarStarStarStar

1

ソリューション

ダウンロード数

<100

[戻る] ボタン
[戻る] ボタン
[次へ] ボタン
[次へ] ボタン

要約

要約

When we are working on huge data sources in .xlsx format, then Select Queries becomes inefficient on DataTables

概要

概要

Xebia proposed Robotic Process Automation (RPA) as a solution to automate the process and suggested UiPath RPA tool.

Xebia RPA Team extended/created the existing functionality of UiPath by creating this reusable workflow.

This activity requires the following user inputs:

Pre-conditions:

i. OLEDB driver should be installed on the machine.

ii. UiPath Database package should be installed in UiPath Studio.

Steps:

1. System reads the Config File and reads all the mandatory parameters like Sheet Name, Header_Present, File Path and Range and Query.

2. The BOT will read the data source file using OLEDB connector.

3. With the help of config File BOT we can determine whether the Header will be there or not.

4. A connection string will be established and based on that database the connection is configured.

5. In “Execute Query” the user can write query and the result will be saved in a DataTable.

Output – The DataTable generated from the Query using OLEDB Connection.

機能

機能

The workflow can be referred and copied as per requirement 1. Converting the Excel to Database, allowing developers to use SQL queries 2. Helping developers to connect to Database 3. Allow the user understand how the Workflow is to be implemented for connecting the DB from UiPath

その他の情報

その他の情報

依存関係

i. OLEDB Driver should be installed in the system. ii. UiPath Database package should be installed in the Studio. The users need to provide the following information on Config Files and they can directly establish connection with Excel sheet with the help of OLEDB. i. File Path ii. SheetName iii. Header Required or not iv. SQL

コード言語

Visual Basic

公開者

Xebia

公開者ページを表示

信頼できるソース

ライセンス契約とプライバシー条項

MIT

プライバシー条項

技術情報

バージョン

1.0.1

更新日

2020年12月9日

対応製品

Studio: 19.4.2 - 22.10

認定

ゴールド 認定済み

アプリケーション

Microsoft Excel

サポート

メール アドレス: vbhardwaj@xebia.com

Mon-Fri 8AM to 6PM IST; Response time: 2 business day; Resolution time: 10 days

リソース

類似のコンポーネント