TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Post Reply
thush_CMB
Posts: 3
Joined: Wed Mar 08, 2017 11:00 pm
OLAP Product: TM1
Version: 10.2.2 FP5
Excel Version: 2010 32bit

TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Post by thush_CMB » Fri Feb 23, 2018 1:39 am

Hi All,
Currently, I have an issue where TI unable to open ODBC connection to Amazon Redshift. This connection also worked well initially and unable connect now. (image 1).
Driver used is Amazon Redshift (x64) (image 3).

However, connection test is successful on Windows ODBC Data Source Administrator (image 2). ALl other ODBC connections work well with TM1.
ODBC_connection_1.PNG
Image 1
ODBC_connection_1.PNG (15.9 KiB) Viewed 409 times
ODBC_connection_3.PNG
Image 3
ODBC_connection_3.PNG (8.32 KiB) Viewed 409 times
ODBC_connection_2_LI.jpg
Image 2
ODBC_connection_2_LI.jpg (872.67 KiB) Viewed 409 times


Has anyone successfully connected Amazon Redshift to TM1? also, any idea what is causing this?

Appreciate any help.

User avatar
macsir
Community Contributor
Posts: 534
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Post by macsir » Fri Feb 23, 2018 3:22 am

Are you sure your password in TI is right?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

thush_CMB
Posts: 3
Joined: Wed Mar 08, 2017 11:00 pm
OLAP Product: TM1
Version: 10.2.2 FP5
Excel Version: 2010 32bit

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Post by thush_CMB » Fri Feb 23, 2018 4:23 am

Yes, the password is correct. The process ran for last 5 days successfully and now it cannot connect.
It has the same login details as 'ODBC data source Administrator'.

blackhawk
Community Contributor
Posts: 123
Joined: Thu May 29, 2008 2:29 pm

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Post by blackhawk » Fri Feb 23, 2018 7:03 pm

Thush_CMB:

You say it ran successfully previously?

Perhaps an application-based security/firewall change on the server?

Is the TM1 Service tied to a network account? Could that network account password have been changed but TM1 instance was never cycled to re-load it's authentication? i.e. Lost its ability to use domain services?

...Just a few thoughts.....

Post Reply