We have set up a little TI application for the centralized administration of users and groups across several TM1 models. What we would love to add next is automated email sending, with notifications like "You have been added to group XYZ..." and so on. But of course our IT guidelines will especially not allow us to send passwords unless messages are encrypted.
We use Outlook 2013, so my first idea was to somehow use the Outlook encryption mechanism, but I have no idea how one could do that out of a TI process.
Can anyone think of an easy solution?
Thank you
Holger
Send encrypted email out of TI
-
- Community Contributor
- Posts: 306
- Joined: Mon May 12, 2008 8:11 am
- OLAP Product: TM1
- Version: TM1 11 and up
- Excel Version: Too many to count
Re: Send encrypted email out of TI
One solution would be to write the email to text on the TM1 Server and have some VBA in an Outlook instance which looped round any text files in the directory and used the text to send the email. The advantage here is that you are just using VBA and Outlook's built-in encryption. The disadvantage is that you need an Outlook instance (or a way of firing up Outlook when there's something to send, something I've never been able to get working reliably under PowerShell etc) to be running all the time.
Alternatively, take the passwords out of the equation by using integrated login, and send out the emails via good old SMTP.
Alternatively, take the passwords out of the equation by using integrated login, and send out the emails via good old SMTP.
Paul
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Send encrypted email out of TI
Why do you need someone's password in order to send them an email? I've done exactly what you're taking about calling SendMail with ExecuteProcess inside a TI without ever having to know a password.
-
- Posts: 131
- Joined: Tue May 17, 2011 10:04 am
- OLAP Product: TM1
- Version: Planning Analytics 2.0
- Excel Version: 2016
- Location: Freiburg, Germany
Re: Send encrypted email out of TI
Sorry I was unclear in this point - what I had in mind is, we set up a new TM1 user profile and want to communicate the user's password. Or the user asks for the password to be reset, and we want to send a message with the new password.
And yes, Paul, we will have integrated login actually, but not within the next couple of months.
And yes, Paul, we will have integrated login actually, but not within the next couple of months.
-
- Posts: 131
- Joined: Tue May 17, 2011 10:04 am
- OLAP Product: TM1
- Version: Planning Analytics 2.0
- Excel Version: 2016
- Location: Freiburg, Germany
Re: Send encrypted email out of TI
I discussed the matter with our IT department. Looks like we will use a separate Outlook mailbox which encrypts all outgoing email by default, so it seems to be solved.