cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle api

aseelodeh
Level 5
Hi all,

How can I connect to oracle database with REST API?
1 BEST ANSWER

Helpful Answers

ewilson
Staff
Staff
@aseelodeh,

See this page. There's some discussion of publishing SOAP web services from the Oracle DB. Personally, I'd stay away from SOAP as it requires more overhead and the importation of WSDL's into Blue Prism can be hit-or-miss depending on their complexity.

https://oracle-base.com/articles/misc/web-services-and-the-oracle-database#publishing-web-services

Here's a link to our existing Oracle DB integration on the DX. Will this not work for you?

https://digitalexchange.blueprism.com/dx/entry/3439/solution/oracle-mda---utility

Cheers,
Eric​

View answer in original post

3 REPLIES 3

ewilson
Staff
Staff
@aseelodeh,

I believe this depends on your Oracle DB and what features are enabled. If you have REST Services for Oracle DB enabled then you'll want to look at Oracle's docs. The following link is to the REST Services info for Oracle r19.

https://docs.oracle.com/en/database/oracle/oracle-database/19/dbrst/index.html

We don't have an existing asset for encapsulating REST access to Oracle DB's. We do have an asset that leverages the Oracle Managed Access Provider though. 

Is there a specific reason you're trying to with Oracle DB via REST?

Cheers,
Eric​​

aseelodeh
Level 5
@ewilson

Can I Use SOAP instead? ​

ewilson
Staff
Staff
@aseelodeh,

See this page. There's some discussion of publishing SOAP web services from the Oracle DB. Personally, I'd stay away from SOAP as it requires more overhead and the importation of WSDL's into Blue Prism can be hit-or-miss depending on their complexity.

https://oracle-base.com/articles/misc/web-services-and-the-oracle-database#publishing-web-services

Here's a link to our existing Oracle DB integration on the DX. Will this not work for you?

https://digitalexchange.blueprism.com/dx/entry/3439/solution/oracle-mda---utility

Cheers,
Eric​