Oracle api

[aseelodeh]

Hi all,

How can I connect to oracle database with REST API?

[ewilson]

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

@ewilson

Can I Use SOAP instead? ​

[ewilson · Accepted solution]

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