- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-01-21 06:51 PM
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
------------------------------
Answered! Go to Answer.
Helpful Answers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-01-21 08:27 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-01-21 07:17 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-01-21 08:39 PM
Thanks Chris.
I tried importing the bprelease file however its gives the below error
------------------------------
Susamay Halder Consultant
Consultant
Bruce Power
+1(437)217-1086
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-01-21 08:48 PM
Cheers,
Eric
------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-01-21 08:55 PM
------------------------------
Susamay Halder Consultant
Consultant
Bruce Power
+1(437)217-1086
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-01-21 09:08 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-01-21 09:41 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-01-21 01:32 PM
@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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-01-21 01:47 PM
Cheers,
------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-01-21 02:03 PM
@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
------------------------------
