Re: APEX

APEX can pretty much expose any of the underlying capabilities of the database (though some you'd need database development skills for), the limitations therefore are pretty much the limitations of the underlying feature. In the case of views of data over db links, especially ODBC , these tend to come down to performance. For non trivial stuff I therefore tend to prefer to keep a local, periodically updated, copy of the sql data in Oracle and join natively.

On Thu, Mar 3, 2011 at 8:21 PM, Toon Koppelaars <toon.koppelaars_at_rulegen.com
> wrote:

> Of course you can:
>
> Just configure DG4ODBC (data gateway for odbc), and then create a database
> link that connects to sql-server.
>
>
> On Thu, Mar 3, 2011 at 9:15 PM, Zelli, Brian <Brian.Zelli_at_roswellpark.org>wrote:
>
>> Does anyone use APEX? If they do, can you integrate it with MS SQL
>> Server data? So a screen can call both oracle and sql server data?
>>
>>
>> ciao,
>>
>> Brian
>>
>>
>>
>> *Brian J. Zelli*
>>
>> title => Senior Database Administrator
>>
>> dept => Enterprise Applications/Systems Integration
>>
>> org => Roswell Park Cancer Institute
>>
>> phone => (716) 845-4460
>>
>> email => brian.zelli_at_roswellpark.org
>>
>>
>>
>> This email message may contain legally privileged and/or confidential
>> information. If you are not the intended recipient(s), or the employee or
>> agent responsible for the delivery of this message to the intended
>> recipient(s), you are hereby notified that any disclosure, copying,
>> distribution, or use of this email message is prohibited. If you have
>> received this message in error, please notify the sender immediately by
>> e-mail and delete this email message from your computer. Thank you.
>
>
>
>
> --
> Toon Koppelaars
> RuleGen BV
> Toon.Koppelaars_at_RuleGen.com
> www.RuleGen.com <http://www.rulegen.com/>
> TheHelsinkiDeclaration.blogspot.com<http://thehelsinkideclaration.blogspot.com/>
>
> (co)Author: "Applied Mathematics for Database Professionals"
> www.rulegen.com/am4dp-backcover-text
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l