Sharing data between applications

Sometimes applications need access to data from another application. Here is one approach you could take:


  1. Define a view in the database that owns the data - this view should expose the data that the external application needs

  2. Grant select permissions so that the external application can select from the view

  3. Create a synonym in the external applications database for the view so that it appears as a local resource



This has the advantage that the owner of the data defines what is exposed. Handy if the data is sensitive in any way.

This solution also assumes that the external application only wants to read the data. If it wanted to write to the database, then the application that owns the data should probably publish an API (eg web services et al).

Popular posts from this blog

Slow, Buffering, Stuttering Udemy Video

Udemy video has been completely unusable from my home broadband connection. Videos would take minutes to start playing and then continuously stutter and buffer. Searching for a solution I came across this Reddit post - and I found the solution was to change my DNS to use CloudFlare (1.1.1.1). After changing my AppleTV from automatic DNS to manual and using 1.1.1.1 video playback from the Udemy app has been as you would expect. I don't know why this helps, but it seems to have so far.
Read more

Intellij tip - Joining multiple lines into one

There are times when you have some code with each statement on its own line, and you want to move it all onto one line. CSS is where I've needed this the most. You start off with some code like this: And really want this: Intellij has a very simple way to do this by using Ctrl-Shift-J - for more information, see http://www.jetbrains.com/idea/webhelp/joining-lines-and-literals.html
Read more

Looking for IT work in Australia? JobReel.com.au!

I'm currently looking for contract work, and all of the usual places offer vague job descriptions that makes it hard to differentiate one from the other. This makes it hard to decide which ones to apply for, and almost always mean that you end up applying for jobs that are totally inappropriate. Now there is JobReel.com.au - much along the lines of jobs.joelonsoftware.com , positions must display the employer. I'm still looking for a site that lets me specify location, price range, responsibilities and technologies - but JobReel is closer than any of the others, and from what I've seen so far, the job descriptions are more useful and realistic. It looks relatively new to the scene - good luck!
Read more