Oracle SQL Developer connection

Help Activities
, ,
1

Hi Team,

I need to connect to oracle SQL Developer through UiPath.

Could someone please help

Regards
Anusha

2

@anusha2

Please get the required details from DBA and then use them in the required connection string…You can find the connection strings here

Or you can drag the the connection activity and use the connection wizard and fill the details

cheers

3

Hi Anil

Thankyou for your reply with connection string iam unable to connect

Regards
Anusha

4

@anusha2

What issue are you facing?

Did you get all the details like dbname…username password port etc

Did you tey with the wizard or else? It looks almost same as the connection winzard in your sql developer

Cheers

5

Hi

To connect to oracle sql developer do i need to install any driver

Regards
Anusha

6

@anusha2

Yes you need odbc or oledb drivers…

Cheers

7

Ok

I have ODBC but not oledb

8

@anusha2

Mostly you connection string would be from this

you can try with configure as well…select odbc → then provide the details

cheers

9

Hi Anil,

the video you shared was related to sql server.

But i need to connect to oracle sql developer.

Please help me out on this.

Regards
Anusha

10

111
111991×313 24.2 KB

I am getting this error

11

Hello @anusha2
Try this. Initially try to setup the ODBC server

12

@anusha2

The video is a reference on how to navigate the connection wizard.

As per error the drivers are not properly installed

Please follow the video given by @Gokul_Jayakumar

Let us know if there are any issues…

cheers

13

Thankyou,

Will try this out

14

Thankyou

Will try that

15

Hi Gokul,

I only have sql developer in my virtual machine.

Oracle is installed on client server which is not installed on my system.

I need to connect to Sql developer through UiPath

image
image1366×768 65.7 KB

In this video they were selecting Oracle database which is not there in my system.

Please guide

16

@anusha2

Are you able to connect to required oracle db using sql developer?

even from UiPath you will connect to DB not to sql developer…

So first try getting connection details and connect from sql developer and you can use same in UiPath as well

cheers

17

Hi ,

Iam able to connect successfully to my databse using sql developer

But with UiPath , unable to connect .

18

@anusha2

please try installing the drivers and then try…and once if you can please show the connection string you are using or the connections you got after saving wizard

For Detailed Steps

cheers

19

HI Anil,

Please find connection string

Driver={Microsoft ODBC for Oracle};Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=199.199.199.199)(PORT=1523))(CONNECT_DATA=(SID=dbName)));Uid=myUsername;Pwd=myPassword;

20

@anusha2
Did you try to connect using the Connection String in Connect to database activity?
image