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 »

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.
Image 1
Image 1
ODBC_connection_1.PNG (15.9 KiB) Viewed 4200 times
Image 3
Image 3
ODBC_connection_3.PNG (8.32 KiB) Viewed 4200 times
Image 2
Image 2
ODBC_connection_2_LI.jpg (872.67 KiB) Viewed 4200 times


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

Appreciate any help.
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Post by macsir »

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 »

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: 136
Joined: Thu May 29, 2008 2:29 pm

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Post by blackhawk »

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.....
mincharug.shulft
Regular Participant
Posts: 155
Joined: Fri May 20, 2011 8:17 am
OLAP Product: Applix,Cognos TM!
Version: applix9.0Cognos tm1 9.5.1
Excel Version: Excel 2010 2007

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Post by mincharug.shulft »

Hi All:

I have requirement: I have the data in Amazon AWS S3 and i need to read the Data using TI (Tm1 10.2.2 on-prem Enviroment) and load into Cube. Is there any solution to achieve this? really appreciated any solution?
EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Post by EvgenyT »

mincharug.shulft wrote: Thu Jan 23, 2020 9:04 pm Hi All:

I have requirement: I have the data in Amazon AWS S3 and i need to read the Data using TI (Tm1 10.2.2 on-prem Enviroment) and load into Cube. Is there any solution to achieve this? really appreciated any solution?
You have two different post with the same content mate. Already replied to the other one.

Thanks

Evgeny
EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Post by EvgenyT »

blackhawk wrote: 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.....
As far as I remember access to AWS RS resources are controlled by IAM. Perhaps check whether data_analyst is assigned to a correct IAM role(s).

Thanks

Evgeny
Post Reply