May 6, 2023
PowerConnect Prerequisites
System Configuration
Hardware:
- 8 cores.
- 64 GB memory.
- 128 GB disk space.
Operating System:
- Windows Server 2016 or higher.
Microsoft Azure App Registration
For OAuth2 authentication, a Microsoft Azure App API App needs to be registered. The required scope for the app is User.Read. Admin consent needs to be applied.
The redirect URL for the app is
https://oauth.powerbi.com/views/oauthredirect.html
An Azure tenant admin usually does the App registration.
Network Configuration for Outbound Requests
The service component will issue requests on HTTP or HTTPS to IBM Planning Analytics instances.
IBM Planning Analytics Local
The URLs for outbound requests in your IBM Planning Analytics Local environment are composed by the protocol, the machine name followed by the HTTPPortNumber.
The protocol depends on the UseSSL setting in the tm1s.cfg file for a given instance.
UseSSL = T
UseSSL = F
http://<tm1server>:<port>
If CAM authentication is used, outbound requests are sent to the IBM Cognos Analytics gateway configured in the tm1s.cfg file for a given instance.
Example:
http://ca-host:80/ibmcognos/bi/v1/disp
IBM Planning Analytics on Cloud
The URLs that PowerConnect uses can be found in your welcome kit provided by IBM Planning Analytics on Cloud. These have the following format:
https:/<tenant>.planning-analytics.ibmcloud.com
The outbound port is 443.
Network Configuration for Inbound Requests
The service component can be configured to listen on a specific port. Firewall rules for inbound requests need to match this port.
Two main sources of inbound requests for PowerConnect are the Custom Connector and the Microsoft Power BI On-premises gateway.
Custom Connector
If firewall rules need to be implemented for inbound requests based on individual IP addresses, the project owner will need to provide a list of the relevant IP addresses.
Microsoft Power BI On-premises Gateway
The Microsoft Power BI On-premises gateway can be installed on the same machine where the PowerConnect service is installed. In this case, no additional firewall rules apply.
If the Microsoft Power BI On-premises gateway is installed on a different machine, a firewall for inbound requests must be added for the IP Address or FQN on the port configured for the PowerConnect service.
Software
To enable the ability to refresh datasets in the Microsoft Power BI Service, a Microsoft Power BI On-premises gateway needs to be installed or configured if one already exists.
PowerConnect installs a Windows service. This service can be configured to use service credentials if IT policies require it.
The installation of PowerConnect requires administrator credentials.
Remote Access
To install software and configure a Windows Service, remote access with an administrator account is required.