Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: Naven on 03 Nov 2009 08:23:16 AM

Title: Need to import data into TM1 using ODBC
Post by: Naven on 03 Nov 2009 08:23:16 AM
Hi All,

I am trying to connect ODBC (Oracle) with TM1 but it throwing an error 'Unable to open connection to database'.

We have 64 bit Windows 2003 Server and 32 bit ODBC drivers.

Thanks,
Naveen
Title: Re: Need to import data into TM1 using ODBC
Post by: MichelZ on 03 Nov 2009 08:54:59 AM
Hi Naveen,

I think you've hit a problem with the Oracle ODBC driver. I guess the 32-bit ODBC Gateway service for TM1 is installed in the directory 'Program Files (x86)'. Oracle has problems with the parenthesis in the path name.
The workaround for this problem is installing the 32-bit TM1 components in an alternative directory which does not contain any parenthesis in the pathname.

Michel
Title: Re: Need to import data into TM1 using ODBC
Post by: Naven on 03 Nov 2009 09:13:03 AM
Hi Michel,

Thks for ur reply.

Will check and revert.
Title: Re: Need to import data into TM1 using ODBC
Post by: MichelZ on 04 Nov 2009 12:26:10 AM
Hi,

As you maybe already have read on the IBM TM1 forum I forgot to mention that if you're on TM1 9.4 the ODBC gateway is no longer supported. So if you're on 9.4 you need to use 64-bit drivers. Here is a link (http://forums.olapforums.com/viewtopic.php?f=3&t=1581&p=8392e#p8411) to a post on this subject on olapforums, which provides a link to the driver download.

Michel
Text only | Text with Images