Connecting to Planning Analytics data servers from CA on Demand
From an IBM Cognos Analytics on Demand environment, you can connect to a TM1 data server that is in a Planning Analytics on Cloud environment.
Note: There are two types of Planning Analytics on Cloud: Hosted and On Demand. Only the Hosted
Planning Analytics on Cloud environment is supported if you are connecting from Cognos Analytics on
Demand.
To do so, create a data server connection, selecting IBM Planning Analytics as the data server type.
Important: This topic describes how to set the authentication method in Cognos Analytics
to match the authentication method used in the TM1 data server. However, the TM1 database
administrator must also secure the TM1 server using the dedicated Cognos Analytics instance that is
associated with the users' Planning Analytics tenant. Contact the TM1 database administrator to
determine the URL of the TM1 database server.
Users and groups are separately managed and configured in Cognos Analytics on Demand and Planning Analytics on Cloud. Therefore, security groups in Cognos Analytics on Demand cannot be used in Planning Analytics on Cloud.
The Cognos Analytics on Demand user ID must be included in the Planning Analytics on Cloud subscription.
For more information, see Planning Analytics security overview.
Procedure
- Click .
- In the Data server connections pane, click the Add data
server icon
.
- Select IBM Planning Analytics from the list of supported types.
- In the field New data server connection, type a unique name for the connection.
- Under Authentication method, select Integrated security, where the TM1 database is configured for Integrated Security mode 4 or 5.
- Beside Connections details, click Edit and enter
the connection details:
- In the TM1 database host field, enter the URL of the TM1 database server,
for example:
https://prodsupport.planning-analytics.ibmcloud.com/api/v0/tm1/GO_New_Stores
- In the HTTP port number field, enter -2
- Leave the Use SSL check box unchecked.
- In the TM1 database host field, enter the URL of the TM1 database server,
for example:
- Click Test
to ensure the connection is valid.
- Click Save.