Page 1 of 1
Using JDBC to get to Oracle
Posted: Fri Jun 22, 2012 2:29 am
by mrnara
Are there plans to allow TM1 to use a JDBC driver to get to Oracle?
An incoming Oracle timestamp object causes data to stop loading.
The ODBC Driver's "Bind TIMESTAMP to DATE" option doesn't seem to work, and the workaround appears to be to modify the SQL to include a "cast(myTimestampCol as date) as myDateCol".
Re: Using JDBC to get to Oracle
Posted: Mon Apr 25, 2016 5:04 am
by wilsonmax
I also wonder if there is any native JDBC connector to Oracle DB could be used in TM1 10.2.2.
Re: Using JDBC to get to Oracle
Posted: Mon Apr 25, 2016 1:33 pm
by jim wood
Have either of you raised it as an enhancement request with IBM? I am sure if you do it'll get a few votes. Although keep in mind that TM1 does not have any native connection drivers. It only uses ODBC drivers installed on it's server. Have you tried to install a JDBC driver at all and connect using TM1?
Jim.
Re: Using JDBC to get to Oracle
Posted: Mon Apr 25, 2016 3:21 pm
by David Usherwood
Cognos BI supports JDBC so you should be able to build a package in BI and use that as a data source in TM1. Does beg the question why, when Oracle ODBC drivers are available and work.
Re: Using JDBC to get to Oracle
Posted: Mon Apr 25, 2016 5:47 pm
by BrianL
Since the TM1 server isn't written in Java and there are other language independent connectors to Oracle, I doubt IBM would have any interest in this. If you really wanted to connect TM1 to Oracle via JDBC, you could look at writing your own java extension to pull data from a JDBC datasource.