Cognos TM1 SSL connection
To connect to Cognos TM1 with HTTPS and an SSL secured port, follow these steps:
- Enable SSL on IBM Cognos TM1 Application Server. See the TM1 documentation at https://www.ibm.com/docs/en/cognos-tm1/10.2.2?topic=configuration-usingssl-data-transmission-security.
- Download the tm1server.pem certification file. For example, if using Firefox:
- Open a browser window and enter your TM1 Server datasource URL such as https://9.30.204.176:8010/api/v1/. Then click View Certificate to open the server certification.
- In the new Firefox browser window, click PEM (cert) to download the tm1server.pem file.
- From the command line, go to the SPSS Modeler jre\bin directory and then
run the following command to import the tm1server.pem file to the SPSS Modeler
Server (modify the paths to match your environment, as needed):
C:\Program Files\IBM\SPSS\Modeler\18.3\jre\bin> keytool.exe -import -alias tm1server -file C: \Users\Administrator\Downloads\tm1server.pem -keystore ..\lib\security\cacerts
- Enter the default keystore password
changeit
if prompted. - When prompted whether to trust this certificate, enter
yes
.
- Enter the default keystore password
- Restart SPSS Modeler Client and SPSS Modeler Server.
You can now use HTTPS and the SSL secured port number to connect to Cognos TM1.