I can't find any evidence that Apex is certified against TimesTen, or vice versa. Similarly I can't find any records indicating that other people have tried to get it working with TT. Having said that, it's probably worthwhile to check with the Oracle Apex support / community if they're aware of any attempts to use Apex with TimesTen.
it does state that "Oracle Application Express cannot be installed into any other relational database." So unfortunately you may not be able to use these two products together.
the following link is how to connect to sqlserver from oracle database
it work with oracle hs and base of odbc connections
you should change sqlserver odbc connection to oracle timesten
As far as I am aware, recent (11g onwards) releases of Oracle Heterogenous services do not work with TimesTen as they now require an OBC 3.x driver and the TimesTen driver is currently 2.0. Even if they did work, this would not be a useful solution. It might allow Apex to access TimesTen after a fashion (though that is far from certain) but the performance would be very poor due to all the network hops and software layers between the application and TimesTen.
If you put one or two tables in TimesTen then one problem from an Apex perspective is that it is now dealing with two databases; the TimesTen cache containing two tables and the oracle database containing all the other tables. Is Apex designed to cope with this? Does it have the concept of data located in multiple databases where one of them is not the Oracle database? Also, do you need transactions or queries (joins) that span the TimesTen tables and the tables in Oracle DB? If so then this also will not work as that is not possible today.
I have to say that as far as Apex goes I think this is likely a non-starter. However, if you do try it and have any success then please do post the results here as we'd be interested to hear about it.
hi ChrisJenkins thanks for replay and notice.
you are right but i have a salary system in oracle apex 4.2.4 and oracle 11g r2 and all of my system work fine but i have a report that use two tables.
this report take a long time to generate so i want use timesten to improve performance.
thank you m.fazlollahi
i test and configure timesten with oracle hs and i can access timesten database within oracle database by db link.
thank you and thank you
But! i successfully configured hs with timesten in windows server 2008 r2 64bit
but my server is oracle linux 6 what a bout this?
ChrisJenkins said " As far as I am aware, recent (11g onwards) releases of Oracle Heterogenous services do not work with TimesTen as they now require an OBC 3.x driver and the TimesTen driver is currently 2.0."
and i could not successfully configure timesten with oracle hs
do you have an idea?