Page 1 of 1

TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Posted: Fri Feb 23, 2018 1:39 am
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 4210 times
Image 3
Image 3
ODBC_connection_3.PNG (8.32 KiB) Viewed 4210 times
Image 2
Image 2
ODBC_connection_2_LI.jpg (872.67 KiB) Viewed 4210 times


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

Appreciate any help.

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Posted: Fri Feb 23, 2018 3:22 am
by macsir
Are you sure your password in TI is right?

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Posted: Fri Feb 23, 2018 4:23 am
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'.

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Posted: Fri Feb 23, 2018 7:03 pm
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.....

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Posted: Thu Jan 23, 2020 9:04 pm
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?

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Posted: Thu Jan 23, 2020 9:45 pm
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

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Posted: Thu Jan 23, 2020 9:50 pm
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