Home » Other » General » B2B data sharing
B2B data sharing [message #684860] Thu, 09 September 2021 16:10 Go to next message
Amine
Messages: 341
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
Re: B2B data sharing [message #684861 is a reply to message #684860] Fri, 10 September 2021 02:25 Go to previous messageGo to next message
John Watson
Messages: 8619
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
Re: B2B data sharing [message #684863 is a reply to message #684861] Sat, 11 September 2021 15:59 Go to previous message
Amine
Messages: 341
Registered: March 2010
Senior Member

Thanks John Watson.

Could you illustrate that through an example ?


Previous Topic: Database synchronization strategy
Next Topic: Licensing confusion
Goto Forum:
  


Current Time: Sun Oct 17 21:29:55 CDT 2021