Hello
A little about servers, we would like to know if somebody connected a Oracle 10g database on Solaris (32-bit) to a Win 64-bit TM1 Server via ODBC.
Free drivers exists?
Thanks,
Oracle ODBC for a TM1 64 bit server
-
lotsaram
- MVP
- Posts: 3702
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Oracle ODBC for a TM1 64 bit server
For 9.1 you can use the 32 bit AXNET gateway and use the native Oracle 32 bit drivers.
For 9.4 series AXNET has been discontinued and 64 bit drivers need to be sourced. I believe the reason for AXNET gateway being dropped was that it does not support unicode. This is a bit of an issue for x64 sites on 9.0 or 9.1 considering an upgrade to 9.4 as it is a bit of a show stopper if there is an Oracle data source. If you are on 9.1 this shouldn't affect you but given how common this scenario must be it is very surprising that IBM haven't come up with a better solution than just telling customers "go and find your own drivers."
For 9.4 series AXNET has been discontinued and 64 bit drivers need to be sourced. I believe the reason for AXNET gateway being dropped was that it does not support unicode. This is a bit of an issue for x64 sites on 9.0 or 9.1 considering an upgrade to 9.4 as it is a bit of a show stopper if there is an Oracle data source. If you are on 9.1 this shouldn't affect you but given how common this scenario must be it is very surprising that IBM haven't come up with a better solution than just telling customers "go and find your own drivers."
-
mattgoff
- MVP
- Posts: 516
- Joined: Fri May 16, 2008 1:37 pm
- OLAP Product: TM1
- Version: 10.2.2.6
- Excel Version: O365
- Location: Florida, USA
Re: Oracle ODBC for a TM1 64 bit server
rodrigo: Yes, you can get free 64-bit Oracle drivers directly from Oracle. You'll need both the Instant Client and ODBC installers.
lotsaram: I'm not following your logic. Why would rodrigo want to use AXNET when 64-bit Oracle drivers are readily available? AXNET is a kludge for situations when running 64-bit TM1 and no 64-bit ODBC driver is available.
Matt
lotsaram: I'm not following your logic. Why would rodrigo want to use AXNET when 64-bit Oracle drivers are readily available? AXNET is a kludge for situations when running 64-bit TM1 and no 64-bit ODBC driver is available.
Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
-
lotsaram
- MVP
- Posts: 3702
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Oracle ODBC for a TM1 64 bit server
I agree AXNET is a kludge and better avoided if possible, just that in the past I have had a lot of trouble sourcing Oracle 64 bit drivers as none were available from Oracle. If this has changed for the better then that is great news as x64 is the future.
-
mattgoff
- MVP
- Posts: 516
- Joined: Fri May 16, 2008 1:37 pm
- OLAP Product: TM1
- Version: 10.2.2.6
- Excel Version: O365
- Location: Florida, USA
Re: Oracle ODBC for a TM1 64 bit server
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
-
rodrigo
- Posts: 49
- Joined: Tue Jun 03, 2008 10:34 pm
- OLAP Product: TM1, Executive Viewer
- Version: 9.4 MR1 with FP3
- Excel Version: 2003
Re: Oracle ODBC for a TM1 64 bit server
Thanks Guys, I thought axnet was something only on 8.x versions.
Thanks Matt for providing the link, 64-BIT is going straight forward...
Thanks Matt for providing the link, 64-BIT is going straight forward...
-
jstrygner
- MVP
- Posts: 195
- Joined: Wed Jul 22, 2009 10:35 pm
- OLAP Product: TM1
- Version: 9.5.2 FP3
- Excel Version: 2010
Re: Oracle ODBC for a TM1 64 bit server
I am confused about the native driver to Oracle database.
Does it mean, 9.1 has a native OCI for Oracle (so not the ODBC which is slower)? Is that right I can query from 9.1 much, much faster Oracle databases than from later versions of TM1?For 9.1 you can use the 32 bit AXNET gateway and use the native Oracle 32 bit drivers.