# SQL\*Plus Like tools

**URL:** <https://forum.uipath.com/t/sql-plus-like-tools/741805>\
**Category:** Data Service\
**Tags:** question, data-fabric, activities\
**Created:** [May 17, 2024, 7:30pm UTC](https://forum.uipath.com/t/sql-plus-like-tools/741805 "2024-05-17T19:30:29Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![hgaber105](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/hgaber105/32/439495_2.png) [@hgaber105](https://forum.uipath.com/u/hgaber105)\
**Post date:** [May 17, 2024, 7:30pm UTC](https://forum.uipath.com/t/sql-plus-like-tools/741805/1 "2024-05-17T19:30:29Z")

</div>

Hi,

Are there any tool I can use to access the Data Service Entities like SQL\*Plus? I need to run some complex queries on the data, and get some statistics on the data, update table, delete rows, … etc  
I need it for maintenance purposes only.

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![aravindbalineni123](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@aravindbalineni123](https://forum.uipath.com/u/aravindbalineni123)\
**Post date:** [May 18, 2024, 4:23am UTC](https://forum.uipath.com/t/sql-plus-like-tools/741805/2 "2024-05-18T04:23:04Z")

</div>

Hi,

Actually there is no existing tool for this. but you can use API for UiPath Data Services.

> **[Data Service - API Access](https://docs.uipath.com/data-service/automation-cloud-public-sector/latest/user-guide/api-access)**
>
> The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...

Or you can build an interface using UiPath Apps. as Apps can connect to data service.

---

<div class="post-metadata">

**Author:** ![hgaber105](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/hgaber105/32/439495_2.png) [@hgaber105](https://forum.uipath.com/u/hgaber105)\
**Post date:** [May 19, 2024, 8:18pm UTC](https://forum.uipath.com/t/sql-plus-like-tools/741805/3 "2024-05-19T20:18:53Z")

</div>

So how can I use these APIs? Can I link it to external Application? My understanding it provides access to “Power Automate application” which is RPA by Microsoft.

---

<div class="post-metadata">

**Author:** ![aravindbalineni123](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@aravindbalineni123](https://forum.uipath.com/u/aravindbalineni123)\
**Post date:** [May 20, 2024, 8:55am UTC](https://forum.uipath.com/t/sql-plus-like-tools/741805/4 "2024-05-20T08:55:58Z")

</div>

Can you tell me your problem statement so that I provide you with a solution

---

<div class="post-metadata">

**Author:** ![hgaber105](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/hgaber105/32/439495_2.png) [@hgaber105](https://forum.uipath.com/u/hgaber105)\
**Post date:** [May 20, 2024, 9:34am UTC](https://forum.uipath.com/t/sql-plus-like-tools/741805/5 "2024-05-20T09:34:13Z")

</div>

I need to run complex queries on the different Entities and update/insert/delete.  
Sometimes I need to prepare test data and I need to get statistics to ensure I’m cover specific cases.

For example I need to run  
select field1, count(_)  
from Entity1  
group by field1  
having count(_) \> 15

Thanks in advance

---

<div class="post-metadata">

**Author:** ![aravindbalineni123](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@aravindbalineni123](https://forum.uipath.com/u/aravindbalineni123)\
**Post date:** [May 21, 2024, 3:44am UTC](https://forum.uipath.com/t/sql-plus-like-tools/741805/6 "2024-05-21T03:44:08Z")

</div>

Hi, I think you can create a UiPath Apps that takes queries as input and process them using process transactions.

This can be your interface

> **[Apps - Introduction](https://docs.uipath.com/apps/automation-cloud/latest/user-guide/introduction)**
>
> The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...

For this you need to create a process that will do all the crud operations and takes the input as the query that we are using.
