topic Re: Oracle api in Digital Exchange

Oracle api

aseelodeh — Thu, 14 Oct 2021 07:42:24 GMT

Hi all,

How can I connect to oracle database with REST API?

Re: Oracle api

ewilson — Thu, 14 Oct 2021 10:30:58 GMT

@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

Re: Oracle api

aseelodeh — Thu, 14 Oct 2021 10:41:50 GMT

@ewilson

Can I Use SOAP instead?

Re: Oracle api

ewilson — Thu, 14 Oct 2021 10:51:17 GMT

@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