cancel
Showing results for 
Search instead for 
Did you mean: 

Getting Data from Oracle Database

sonuiiml
Level 5

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
------------------------------
1 BEST ANSWER

Helpful Answers

@Susamay Halder,

I believe I figured out the issue. In BP v6.0 there was no support for environment variables defined as Password data types. The Oracle MDA integration has an environment variable of Password type. I've manually updated the attached .bprelease to set that data type to Text, and I was able to import the file into an instance of BP v6.

Just change the file extension from ".txt" to ".bprelease".

Cheers,


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

View answer in original post

28 REPLIES 28

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

Thanks Chris. 

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

28120.pngAny thoughts?


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

What version of Blue Prism are you running?

Cheers,
Eric

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

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

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

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

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

@Charles

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

28134.png
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
------------------------------

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

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