SQL Developper automation

RPA Discussions
1

hello everyone ,

has anyone worked to automate the excution of queries in SQL Developper Tool ?

i refer to queries such as : SELECT * FROM table WHERE date ;

then changing the “date” on this query once launching the robot ?

PS : Please do not hesitate to share videos or steps that could help me to develop this Use case

thank you in advance for your feedback :blush:

2

Hi @Ben-Ziane_Hajar

Welcome to community

Have look on the thread

Regards
Gokul

3

Thank you very match @Gokul001 Gokulfor your reactivity and for your appreciated feedback :slight_smile:

4

Hi @Ben-Ziane_Hajar

Any Further query related to this topic?

Regards
Gokul

5

in fact , i’m still waiting for an answer regarding automating the execution of queries on SQL developer throughUIPATH ?

unfortunatly , the video and links provided are related to manual execution on SQL developer directly .

6

Asking about the activities to automate the sql query

Regards
Gokul

7

HI @Ben-Ziane_Hajar

If yes, Go to → Manage Package → Install (UiPath.Database.Activities)

image
image1129×672 35.3 KB

image

Look into the document

Execute Query

Execute Non Query

Regards
Gokul

8

Thank you , it is very helpful … However , how can I connect UiPath to SQL Developper ? any idea ?

another question is that I can nnot see the SELECT activity among queries activities on UiPath … how can I have this activity to launch a SELECT * FROM query ?

thank you in advance for your time …

9

Use Execute Query activity → Select * from TableName

Regards
Gokul

10

Thank you so much

11

Hi Ben-Ziane Hajar ,

you can look below link for Sql connection with UiPath and run select command and extract the data from database.

you can use below syntax for dynamic value pass to the select query.

  1. SET @SQL = ‘SELECT ContactName FROM Customers WHERE CustomerId = ‘’’ + @CustId + ‘’‘’

  2. @SQl : is variable to store the query.

  3. ContactName : is table name

  4. CustomerId : is a column where we are passing dynamic value.

I hope , this help for you to resolve/grow your knowledge in Sql Part. :slightly_smiling_face: