TM1 Forum

Reviving this after a 8 years..

Since the code in the epilog doesn't execute, is there a way to identify the error log filename as GetProcessErrorFileName() would return blank in the parent process.

Thanks,
Saurabh

We tried various approaches to handle this. I am listing down below. 1) Tried to locate if we can attach service accout with MySQL server, however couldn't find much documentation on mysql for this. There is indeed a 'windows authentication plugin' available bowever seems to work only with.net appli...

Hi Guys, Apologies for the delay in response. The error that I am receiving is "SQL statement failed" while performing preview. Paul SImon - The query is actual, that said, mysql doesn't force to use 'from' clause. ("Select 1" works in mysql). Interesting that SQL server stored p...

Hi, We have a strict infosec policy to make sure that the passwords are secure all through the process. My question is regarding the transmission of password from connecting from TM1 to DB using ODBC connector. Is this connection secure using SSL/TLS? How can I identify or make it to use SSL? Thanks!

Thank you Paul, David, Brian for your response. This is really helpful.
We are now trying to implement windows authentication process based on Paul's thoughts. We make use of AWS RDS and trying to check the feasibility for the same.

I shall share update on how it goes.

Thanks,
Saurabh

Hi Greg,

Were you able to identify a solution to address the password in plain text issue. I am a newbie to TM1 TI and trying to address exactly the same issue.

It would be very helpful if you can share your findings.

Thanks!

Hi everyone, I am a newbie and trying to understand the concepts of TM1. We are struggling to manage our TI processes version and found this post to be very helpful. However it would e great if I could get a guide on integrating our TM1 environment to a version control system (preferably GIT). Thanks!

Hi, I have created a function in MySQL which I want to call in my query box in data source tab. However it seems to be not working and fails. The same query works when run on sql prompt. I am an newbie to TI processes. Can anyone share their experience on this? As a simple example: SELECT 'a.txt' as...