Hello Forum,
Does anyone have experience in connection TM1 (8.2.0) to Teradata (12.0.0.04) ?
Since the release of Teradata Version 12 we have problems connecting this to TM1.
It worked fine when using Teradata 6.2 but after upgrading we can no longer connect
to Teradata via the TM1-server as a TM1-client-user using Excel
in order to execute an import-process to a TM1-cube.
We use the ODBC-connection to import aggregated data from Teradata to TM1
in order to allow our Marketing-Department to analyse various campaigns.
We get the following error message : Unable to open connection to database.
The ODBC-interface itself works fine : We can connect to Teradata using SQL Assistant.
So the connection works and userid/password is correct, etc.
I guess there is a conflict between the TM1-Excel-plug-in and the ODBC-driver.
Can anyone help me ? Thanks in advance.
Hans van Stippent
Otto B.V.
Database Marketing
The Netherlands
Email: hans.vanstippent@ottobv.nl
TM1 <-> Teradata
-
jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: TM1 <-> Teradata
Hi,
Have you updated the ODBC driver on the machine you are using to connect to Terradata? I don't have any experience of connecting to Terradata but we have had issues with ODBC client version when connecting to Oracle (We were still able to test the connection but it didn't work within TM1 before upgrading, very similar to what you are experiencing.),
Jim.
Have you updated the ODBC driver on the machine you are using to connect to Terradata? I don't have any experience of connecting to Terradata but we have had issues with ODBC client version when connecting to Oracle (We were still able to test the connection but it didn't work within TM1 before upgrading, very similar to what you are experiencing.),
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
hansstip
- Posts: 22
- Joined: Fri Sep 19, 2008 8:29 am
- OLAP Product: TM1
- Version: 9.1 SP 3
- Excel Version: Excel 2007
Re: TM1 <-> Teradata
No idea why but suddenly it worked... 
Thanks for your post anyhow.
Thanks for your post anyhow.
-
bakmester
- Posts: 1
- Joined: Fri Mar 20, 2009 11:34 am
- OLAP Product: TM1
- Version: 9.0s-91sp3-9.4MR1_FP1-TM1WEB
- Excel Version: 2003
Re: TM1 <-> Teradata
Hello, I am facing really similar issue with connecting to Oracle.
I can use with Excel the created system DSN ODBC connection(s) pointing to the Oracle database but wit TI it throws an error:
"Unable to open connection to Database"
The TM1 server(9.1sp3 32bit) and the Oracle database are not on the same HW but the Oracle client is installed on the TM1 server.
So there are two ODBC drivers for ORACLE but none of them is working with TI but just with Excel.
(Oracle in OraClient10g_home and Microsoft ODBC for Oracle)
Any Idea?
Thanks,
Bakmester
I can use with Excel the created system DSN ODBC connection(s) pointing to the Oracle database but wit TI it throws an error:
"Unable to open connection to Database"
The TM1 server(9.1sp3 32bit) and the Oracle database are not on the same HW but the Oracle client is installed on the TM1 server.
So there are two ODBC drivers for ORACLE but none of them is working with TI but just with Excel.
(Oracle in OraClient10g_home and Microsoft ODBC for Oracle)
Any Idea?
Thanks,
Bakmester
-
Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: TM1 <-> Teradata
Hi,
Just a guess... Are you running TM1 on a 64-bit Windows machine and are you connecting through the 32-bit ODBC driver using the gateway service?
If so, the (32-bit) gateway service executable is probably installed in the Program Files (x86) directory. The Oracle ODBC driver has a problem with the parentheses in the path-name. So, if I guessed right the problem can be soved by moving the installation of the gateway service executable to a directory with no parentheses in the name. Another option is upgrading the Oracle ODBC driver (if a version without this problem is available).
Michel
Just a guess... Are you running TM1 on a 64-bit Windows machine and are you connecting through the 32-bit ODBC driver using the gateway service?
If so, the (32-bit) gateway service executable is probably installed in the Program Files (x86) directory. The Oracle ODBC driver has a problem with the parentheses in the path-name. So, if I guessed right the problem can be soved by moving the installation of the gateway service executable to a directory with no parentheses in the name. Another option is upgrading the Oracle ODBC driver (if a version without this problem is available).
Michel