topic RE: Oracle SQL Developer connection to Blue Prism in University Forum

Oracle SQL Developer connection to Blue Prism

faheemsd — Thu, 22 Dec 2022 19:20:00 GMT

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
------------------------------

RE: Oracle SQL Developer connection to Blue Prism

BohyonHwang — Sat, 24 Dec 2022 07:50:00 GMT

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
------------------------------

RE: Oracle SQL Developer connection to Blue Prism

Neel1 — Mon, 26 Dec 2022 07:29:00 GMT

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
------------------------------

RE: Oracle SQL Developer connection to Blue Prism

faheemsd — Mon, 09 Jan 2023 07:29:00 GMT

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
------------------------------

RE: Oracle SQL Developer connection to Blue Prism

faheemsd — Mon, 09 Jan 2023 07:33:00 GMT

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
------------------------------

RE: Oracle SQL Developer connection to Blue Prism

BohyonHwang — Mon, 09 Jan 2023 08:07:00 GMT

It's my pleasure!
Cheers

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