How to connect to oracle db & pass the connection string using uipath

[vnsatyasunil]

Please help?

[Anil_G (Anil Gorthi)]

@vnsatyasunil

This looks like a fair explanation

How to setup a connection to Oracle Database with UiPath

I could create the connection successfully. The above error was due to an additional space in the connection string in tnsnames.ora file…:joy: Steps followed are: Download oracle instant client (basic and odbc driver) - 32 bit Extract content of both to one folder Add the path of instant client folder to System variables (Path and TNS_ADMIN) Install instant client by running odbc_install.exe in instant client folder Create the tnsnames.ora file inside the instant client folder. **If u h…

Create an RPA Flow that Connects to Oracle Data in UiPath Studio

Cheers

[Gokul001 (Gokul Balaji)]

Hi @vnsatyasunil

you can follow these steps:

1. Install the necessary dependencies:

• Make sure you have the Oracle Database client installed on the machine where UiPath is running. This client includes the necessary drivers to connect to the Oracle database.
• Install the UiPath.Database.Activities package in UiPath Studio. This package provides activities for interacting with databases, including Oracle.

2. Drag and drop the “Connect” activity from the UiPath.Database.Activities package onto the workflow canvas.

3. In the properties panel of the Connect activity, configure the following:

• ProviderName: Set this to “System.Data.OracleClient” or “Oracle.DataAccess.Client” depending on the Oracle client version you have installed.
• ConnectionString: Set the connection string for your Oracle database. The connection string should include information such as the server address, port number, database name, username, and password.

Here’s an example connection string:

"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server_address)(PORT=port_number))(CONNECT_DATA=(SERVICE_NAME=database_name)));User Id=username;Password=password;"

Replace the following placeholders:

• server_address with the IP address or hostname of the Oracle database server.
• port_number with the port number used for Oracle database connections (default is 1521).
• database_name with the name of the Oracle database.
• username with the username to connect to the database.
• password with the corresponding password.
• Click on test Connection.

Hope it will helps you

Regards
Gokul

[vnsatyasunil]

@Gokul001

"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server_address)(PORT=port_number))(CONNECT_DATA=(SERVICE_NAME=database_name)));User Id=username;Password=password;"

tried but tcp transport address connect failure error coming.How to fix that

[Gokul001 (Gokul Balaji)]

Can you share the screenshot of the error?

[vnsatyasunil]

[Gokul001 (Gokul Balaji)]

Have you provide all the details

After that click on the test connection and check it.

[vnsatyasunil]

If I select Oracle.ManagedDataAccess then I am getting error like this

If I click ok & select Oracle.ManagedDataAccess then screen is like this

[vnsatyasunil]

By downgrading database.activities to 1.6.1 it works.

[vnsatyasunil]

In run query step even though I pass query in double quotes again it is asking double quotes expected error. Some alias names are there in query will that cause error?If I remove alias names error is gone.Will that possible with alias names?
Please help?