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.
Has anyone successfully connected Amazon Redshift to TM1? also, any idea what is causing this?
Appreciate any help.
TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift
- macsir
- MVP
- Posts: 785
- 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
Are you sure your password in TI is right?
-
- 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
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'.
It has the same login details as 'ODBC data source Administrator'.
Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift
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.....
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.....
-
- 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
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?
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?
-
- 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
You have two different post with the same content mate. Already replied to the other one.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?
Thanks
Evgeny
-
- 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
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).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.....
Thanks
Evgeny