This discussion is archived
2 Replies Latest reply: Jan 2, 2013 9:22 AM by Andreas Wismann RSS

Multiple Database Connections

user11210018 Newbie
Currently Being Moderated
Trying to develop a functionality wherein we can view data of a remote database (not the database instance where APEX is installed) using the Report.
As APEX doesnot support multiple database instance access from a single workspace/applciation.. any workarounds .. I'v used dblinks previously.. but was on a lookout for a more roboust solution..Dont find db links a reliable opiton.
  • 1. Re: Multiple Database Connections
    Andreas Wismann Explorer
    Currently Being Moderated
    Hi,

    how about delving into the wonderful world of Web Services and XML?
    APEX is quite powerful in that realm.
    Of course WS adds a little overhead to communication and is a bit slower than a database link, but there are lots of benefits on the other hand. In my opinion it's the perfect option if you plan on loosely coupling your applications (not only APEX - ask the Java folks :-)
    It always depends on what your expectations are concerning "Quality of Service". A typical APEX page wouldn't load like a million of rows and therefore Web Services might be the right way.
  • 2. Re: Multiple Database Connections
    Brian Bontrager Expert
    Currently Being Moderated
    Out of curiosity, what did you find unreliable about database links?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points