Getting Data from Oracle Database

[sonuiiml]

HI Team, 

I am trying to retrieve data from Oracle database through OLEDB object. I am able to access the required tables from Oracle SQL developer. I did tried giving the connection string in OLEDB object how ever it gives the error as OLEDB data provider cannot be located.  My question

1. Is it possible to get the connection string from Oracle SQL developer tool to be used in blueprism (currently I am able to access the data from Oracle SQL developer tool)?
2. Do I need to install Oracle Data access components separately?

Please let me know if you have any questions

------------------------------
Susamay Halder Consultant
Consultant
Bruce Power
+1(437)217-1086
------------------------------

[ewilson]

Hi @Susamay Halder,

​I believe for Oracle you will need to have their Data Access components installed. There's actually an Oracle integration available on the DX, and the documentation discusses the necessary requirements. You can find it here: https://digitalexchange.blueprism.com/dx/entry/9648/solution/blue-prism---oracle-mda---utility-2

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

[sonuiiml]

Thanks Chris. 

I tried importing the bprelease file however its gives the below error

Any thoughts?

------------------------------
Susamay Halder Consultant
Consultant
Bruce Power
+1(437)217-1086
------------------------------

[ewilson]

What version of Blue Prism are you running?

Cheers,
Eric

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

[sonuiiml]

I am using blue prism version 6. Is that impeding the extraction process?

------------------------------
Susamay Halder Consultant
Consultant
Bruce Power
+1(437)217-1086
------------------------------

[ewilson]

That could be the issue. I imagine this release was created in 6.8 or 6.9. The makeup of the bprelease file changed a bit in 6.6.

Let me work a little magic on the file shortly, and then update it on GitHub. I'll let you know as soon as it's ready.

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

[ewilson]

@Susamay Halder,

There's a new version of the .bprelease file available on the GitHub page. This should work for you.

Cheers,
​

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

[sonuiiml]

@Charles

I did tried with the new release file you have shared on github page but the error remains.

Do I need to put the dll files in blue prism automate folder and then give it a try?

------------------------------
Susamay Halder Consultant
Consultant
Bruce Power
+1(437)217-1086
------------------------------

[ewilson]

Try opening the .bprelease file with a text editor (ex. Notepad). Do you see HTML tags in the file or just XML?

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

[sonuiiml]

@ewilson

Hi Eric,

I did tried saving the file in notepad. Do you mind taking a look? it there in attachment.
Thanks ​

------------------------------
Susamay Halder Consultant
Consultant
Bruce Power
+1(437)217-1086
------------------------------