We need to push data from TM1 to Oracle database using ODBCOpen command. However this command requires database password to be captured in clear text. This is not acceptable by bank security policies. We need a solution to this problem with TM1.
Why is it useful?
|Who would benefit from this IDEA?||Anyone who need to push TM1 data to other database systems such as Oracle DB in a secure way.|
How should it work?
It would be good if it was possible to make use of TM1 ODBC password that is entered in the TI process, not only to read from source database but also to push data back to the database without having to capture database password in clear text? Without having this feature, bank security policies do not allow TM1 to push data to a database as TM1 requires destination DB password to be stored or captured in clear text.
|Priority Justification||Presently ODBCOpen command requires destination DB password to be stored or captured in clear text without any encryption. This is not allowed by bank security policies as it is not allowed to store and database password to be stored in clear text format. Without having this new feature, we are able to fully utilize TM1 data integration capabilities and hence reducing the TM1 use cases quite considerably.|
|Customer Name||A Banking Customer|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions