SQL*Plus Like tools

Help Data Service
,
1

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.

2

Hi,

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

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

1 Like
3

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.

4

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

5

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

6

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

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.

1 Like