Hello Community,
I was wondering how you manage to secure database credentials (user/password) when you're using TM1 and a RDBMS.
When you need to feed a cube from a relational database, no big deal, you just have to type in the credentials in the datasource tab of the TI process and the password is hidden, only the user is exposed. So it's secure.
But when you need to push back data from a TM1 cube to a database table, we've found to way to do this :
- First solution, use the ODBC TI functions but the bad thing about this is the fact that you have to provide the user password to the ODBCOpen function....
- Second solution, use a tier program (SQLLoader in my case as I'm dealing with Oracle) and here again we'll have to have the password visible at a point of time but at this time, it's no more a TM1 topic
The first solution, even if the performance is quite poor, would have been compliant with basic security standard if you didn't need to do an ODBCOpen and be able instead to use the ODBC credentials declared in the datasource to perform the ODBCOutput SQL commands.
How are you dealing with this kind of topic ?
Regards,
Bob
#PlanningAnalyticswithWatson