Sign In
Create your first automation in just a few minutes.Try Studio Web →
Xebia - Select Query Using OLED
by YouTube
1
Template
<100
Summary
Summary
When we are working on huge data sources .xlsx format, then select Queries becomes inefficient on data tables
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 Re-usable workflow.
This activity takes the following user inputs:
Pre-condition:
i. OLEDB driver should be installed in 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 data table.
Output – The Data table generated from the Query using OLEDB Connection.
Features
Features
The user needs 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
Additional Information
Additional Information
Dependencies
i. OLEDB Driver should be installed in the system. ii. UiPath Database package should be installed in the Studio.
Code Language
Visual Basic
License & Privacy
MIT
Privacy Terms
Technical
Version
1.0.0Updated
February 18, 2020Works with
2019.4.2 Community Version
Certification
Silver Certified
Application
Support
UiPath Community Support
Resources
Similar Listings
