OraFAQ Forum: General » B2B data sharing

Home » Other » General » B2B data sharing

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

B2B data sharing [message #684860]

Thu, 09 September 2021 16:10

Amine
Messages: 376
Registered: March 2010

Senior Member

Hi guys,
I have a little question on how does B2B data sharing work ?
Say I am the department of home affairs and I want to share the data I hold (data that lives into an Oracle db) to others departments of the country.

Especially the data about HR.

So how to do with that :
- give a SQLplus access to each department ?
- create a web service that gives the desired data ?

What's commonly done in this kind of situations ?

Thanks in advance.

Amine

Report message to a moderator

Re: B2B data sharing [message #684861 is a reply to message #684860]

Fri, 10 September 2021 02:25

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

The developers I work with would do it with ORDS and APEX. Create a web service that that will distribute the data as JSON documents. JSON is anathema to a relational engineer (it is name-value pairs on steroids) but it is the way to go. Oracle provides all sorts of facilities for working with it. 21c even has a JSON data type.

Give my boss a call if you'ld like any consulting assistance Smile

Report message to a moderator

Re: B2B data sharing [message #684863 is a reply to message #684861]

Sat, 11 September 2021 15:59

Amine
Messages: 376
Registered: March 2010

Senior Member

Thanks John Watson.

Could you illustrate that through an example ?

Report message to a moderator

Previous Topic:	Database synchronization strategy
Next Topic:	Licensing confusion

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 11:02:39 CST 2024