English
|
Japanese
Xebia - Select Query Using OLED
by Xebia
1
44
Xebia - Select Query Using OLED
by Xebia
1
Solution
44
Summary
Summary
Overview
Overview
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.
Features
Features
Additional Information
Additional Information
Dependencies
Code Language
Visual Basic
License
MIT
Technical
Version
1.0.1Updated
09 Dec 2020Works with
2019.4.2 Community Version
Certification
Gold Certified
Tags
datatable
excel
Application
Microsoft Excel
Support
Email: vbhardwaj@xebia.com
Mon-Fri 8AM to 6PM IST; Response time: 2 business day; Resolution time: 10 days
Resources
Similar Listings
English
English
日本語