Re: APEX
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: toon.koppelaars@xxxxxxxxxxx
- Date: Thu, 3 Mar 2011 20:48:27 +0000
Just to add to that
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@xxxxxxxxxxx
> 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@xxxxxxxxxxxxxxx>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@xxxxxxxxxxxxxxx
>>
>>
>>
>> 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@xxxxxxxxxxx
> 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
Other related posts:
- » APEX- Zelli, Brian
- » Re: APEX- Toon Koppelaars
- » Re: APEX - Niall Litchfield
- » RE: APEX- Stephens, Chris
