Oracle SQL Developer connection to Blue Prism

[faheemsd]

Hi Team,

I would like to connect the Oracle SQL Developer to Blue Prism, I need your hep how can I connect? Can I use SQL VBO to connect Oracle SQL Developer to Blue Prism or Do you want me to use Data-OLEDB VBO to connect Oracle SQL Developer to Blue Prism?

I tried using Set connection action in SQL VBO but getting the error as

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Appreciate your help on this.

------------------------------
SYED FAHEEM
RPA Developer
DAR-ME
Asia/Kolkata
------------------------------

[BohyonHwang · Accepted solution]

Why don't you try to use Data - Oracle (MDA) VBO.
You will find it on Blue Prism Digital Exchange.
https://digitalexchange.blueprism.com/dx/entry/3439/solution/oracle-mda---utility

------------------------------
Bohyon Hwang
Director
블루프리즘
Seoul
+82262033950
------------------------------

[Neel1]

Hello @SYED FAHEEM - i have used ORACLE MDA VBO highlighted by @Bohyon Hwang on multiple occasion for connecting to Oracle DB. it has great feature.

Let me know in case you face any issue in this regard.​​

------------------------------
Neeraj Kumar
Technical Architect
------------------------------

[faheemsd]

Hello @Bohyon Hwang

Thank you very much for your response and this VBO giving the exact result what I'm expected.

Thanks a lot 🙂 
​

------------------------------
SYED FAHEEM
RPA Developer
DAR-ME
Asia/Kolkata
------------------------------

[faheemsd]

Hello @Neeraj Kumar

Thank you for info and this VBO made my work much easier to connect Oracle SQL.

I will let you know if I face any issues.

​

------------------------------
SYED FAHEEM
RPA Developer
DAR-ME
Asia/Kolkata
------------------------------

[BohyonHwang]

It's my pleasure!
Cheers

------------------------------
Bohyon Hwang
Director
블루프리즘
Seoul
+82262033950
------------------------------