TM1 Forum

Posted: **Wed Oct 06, 2021 6:22 am**

We have multiple data source from ODBC , therefore we create the parameter cube to record the password.

But for the new policy need to encrypt password.

Now , we try to use function CubeSetConnParams encrypt the password ,but in the next step we don't konw how to decrypt it.

Anyone knows how to decrypt this cell ?

Code: Select all

cubeName='!Cube';
providerName='OLAPDB';
dataSourceLocation='TM1Server';
dataSourceName='DB';
dataSourceCatalog='test';
userID='admin';
password='apple';
sapClientID='';
sapClientLang='';
providerString='';

CubeSetConnParams(cubeName, providerName, dataSourceLocation,dataSourceName, dataSourceCatalog, userID, password
, sapClientID, sapClientLang, providerString);

Code: Select all

sDataSourcePassword=CellGetS('}CubeProperties','!Cube','PASSWORD');

DataSourceType='ODBC';
DatasourceUsername=sDataSourceUsername;
DatasourcePassword=sDataSourcePassword;

Posted: **Wed Oct 06, 2021 9:34 am**

CubeSetConnDatabase is used to set a password specific for connecting to your tm1 cube.

TM1 databases are already encrypted (if usessl=T is set on the model) so as long as you ensure no one has read/write access to the cube no one except admin users can access the passwords you've stored in the cube.

If you must have the passwords stored in encrypted form (even within the already encrypted database) do so using powershell/cmd and then decode them also using powershell/cmd.

Posted: **Thu Oct 07, 2021 1:32 am**

burnstripe wrote: ↑Wed Oct 06, 2021 9:34 am CubeSetConnDatabase is used to set a password specific for connecting to your tm1 cube.

TM1 databases are already encrypted (if usessl=T is set on the model) so as long as you ensure no one has read/write access to the cube no one except admin users can access the passwords you've stored in the cube.

If you must have the passwords stored in encrypted form (even within the already encrypted database) do so using powershell/cmd and then decode them also using powershell/cmd.

Yes , we must have the passwords stored in encrypted and we will try to using cmd , thanks for your advice.

TM1 Forum

How to decrypt the cell which CubeSetConnParams fill in?

How to decrypt the cell which CubeSetConnParams fill in?

Re: How to decrypt the cell which CubeSetConnParams fill in?

Re: How to decrypt the cell which CubeSetConnParams fill in?