How to connect oracle cloud db through uipath?

Can i get clear procedure here?

want to execute query on my oracle cloud db.it is in sql developer.

Hi,
Follow the link to connect to database using UiPath.

Let us know if this helps.

Regards,
Pavan H

hi @ganesh_rajan

please check it once.

Do I need to install anything for this setup?

1 Like

you need to install one package(uipath.database.activities)

Have already downloaded that package.i’m asking about odbc connection

1 Like

Fine
–once installed with uipath.database.actiivities
–in execute query activity click on the configure connection option
image
–then click connection wizard
image
–then select the db (here we have sql)
image
–then enter the servername and use sql authentication or window authentication and mention the username and password (if sql authentication)
–then mention the database name and click on TEST CONNECTION which will give us a popup connection successful

–we can do the same in first CONNECT activity as well and include other activities of databse inside this

hopethis would help you
Kindly try this and let know for any queries or clarification
Cheers @ganesh_rajan

  1. In UiPath Studio, take a Database Connect activity.
  2. Click on Configure Connection.
  3. Click on Connection Wizard.
  4. Click on Microsoft ODBC Data Source and Click OK.
  5. Select the DSN you created before from the Use user or system data source name dropdown.
  6. Provide User name and Password below that.
  7. Click Test Connection. It should be successful.
  8. Select the Provider as System.Data.Odbc
  9. Create a connection object and use it wherever you want!!

image

I could not able to find system data source name.

buddy this is for sql server correct…But i’m trying to connect oracle cloud

ohh, sorry
did this help you buddy

Cheers @ganesh_rajan

image

if i click microsoft ODBC for oracle then entire window went to disappearing.i could not able to find next step.

32 bit or 64 bit?

64
@ganesh_rajan

1 Like

image

Got this error

1 Like

Hi @Palaniyappan

64 bit is not working on this …only 32 bit is working

1 Like

aaah yes @ganesh_rajan kindly try once with 32 bit buddy
Cheers @sschowdary @ganesh_rajan

try ince 32 bit… its working …

Cheers @Palaniyappan

Yes it’s working.But how i can configure this odbc?

can you guide me on this?

1 Like

Kindly have a view on this
https://www.microfocus.com/documentation/enterprise-analyzer/ea40/EA/GUID-1D791A6B-4B9F-457D-B617-A441E0362082.html

Cheers @ganesh_rajan