This discussion is archived
3 Replies Latest reply: Feb 14, 2013 6:25 AM by jwellsnh RSS

APEX on SQL Server

sky123 Newbie
Currently Being Moderated
Hi,

We've many packaged applications on the top of our SQL Server databases. Is it effective and efficient to build side applications in Oracle APEX against SQL Server databases by creating a schema in Oracle that connects to SQL Server databases through dblink with Oracle Database Gateway? Or does it make more sense to develop in ASP.Net or Oracle JDeveloper/ADF?

We've been using Oracle APEX for years and are very sophisticated building front-end applications with APEX and PL/SQL.

Thanks.
  • 1. Re: APEX on SQL Server
    TexasApexDeveloper Guru
    Currently Being Moderated
    If you can justify the cost and confusion of building an APEX app who's data ultimately resides in a SQL Database, go for it.. Sounds like you are trying to use a hammer to put screws in.... Use the appropriate tool for the job...

    By the time they had diminished from 50 to eight, the other dwarves began to suspect "Hungry".

    Thank you,

    Tony Miller
    Ruckersville, VA
  • 2. Re: APEX on SQL Server
    sect55 Journeyer
    Currently Being Moderated
    sky123,

    You can use APEX but you should realize that the performance would be affected since you will be using Database Gateway (and dblink) to perform DML (select, insert, update, delete,etc.). It is not the best approach but it can be a workable one if the not efficient performance is not noticeable.

    I think it is a good alternative when the data must exists on a non-Oracle DB when you have staff with APEX skills and can develop an application quickly using those skills.

    But, I never have done this approach before, so I cannot tell you from experience.

    Robert
    http://apexjscss.blogspot.com
  • 3. Re: APEX on SQL Server
    jwellsnh Expert
    Currently Being Moderated
    sky123,

    Since our requirement was to only read SQL Server data; we pump the data daily into Oracle and then go at the data via APEX.

    Jeff

Legend

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