how to connect PAfe client to TM1 Server directly via RestAPI?
Posted: Thu Jun 05, 2025 1:48 pm
TM1 Admin server and TM1 Server are run on my local machine (windows), there is no PAW installed.
I run PAfe client (pa_excel_2.0.91_64b_win_ml.xll) with excel, and can see 'IBM Planning Analytics' panel appear on excel command bar. But when I tried to create a new connection to TM1 server with below setting:
the connection test returns success. However, when I saved this connection and make a real connection with it, system reported an error with below message "can not find below webpage: https://localhost:12662/api/?ttps://loc ... 662/api/v1". I don't know why it repeats my input URL.
I can get json information return when I input URL "https://localhost:12662/api/v1/Configuration" on the browser directly. and my tm1s.cfg setting as below:
My question is
1) can PAfe directly connect to TM1 Server by RestAPI without PAW?
2) if above solution works, how should I set the connection URL? and should other parameters be set?
I run PAfe client (pa_excel_2.0.91_64b_win_ml.xll) with excel, and can see 'IBM Planning Analytics' panel appear on excel command bar. But when I tried to create a new connection to TM1 server with below setting:
Code: Select all
Data Source Type: IBM Planning Analytics
Connection URL: https://localhost:12662/api/v1 # (12662 is defined in my tm1s.cfg as HTTPPortNumber)
Friendly Name: a
I can get json information return when I input URL "https://localhost:12662/api/v1/Configuration" on the browser directly. and my tm1s.cfg setting as below:
Code: Select all
IntegratedSecurityMode=1
UseSSL=T
AdminHost=127.0.0.1
PortNumber=12660
ClientMessagePortNumber=12661
HTTPPortNumber=12662
1) can PAfe directly connect to TM1 Server by RestAPI without PAW?
2) if above solution works, how should I set the connection URL? and should other parameters be set?