Xebia - Select Query Using OLED

Supported by Publisher

Silver Certified

Workflow Template

1 reviews

Summary

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

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.

Benefits

Published: 2021-01-11T11:37:02+00:00 | Updated: 2021-01-11T11:37:02+00:00

Xebia

Trusted Source

License

MIT

Code Language

Visual Basic

Xebia - SQL Query Builder…

Custom Activity

SQL Query Builder for "OR" or "AND" Statement which can be used in select query in Database or DataTable …

225

Bronze Certified

Supported by Publisher

Xebia - DataTable to HTML Table Conversion…

Custom Activity

This activity is capable of exporting DataTables into HTML format…

6 reviews

398

Silver Certified

Supported by Publisher

FPT Software - Build Query For Filter DataTable…

Snippet

This snippet helps to build the query to filter DataTable variable by Linq…

Bronze Certified

Supported by Publisher

Power Search Activity…

Custom Activity

This activity checks if values are present in a DataTable. It returns a Boolean and multiple dictionaries. A boolean variable is True when all values are present and if not, the following dictionaries are created: Present Values, Missing Values, Rest Values.…