Connecting to the XMLA Provider
Make sure you can connect to the database as the specified user.
XMLA connections use http(s) for communication.
To connect, first send a DISCOVER_DATASOURCES request to the OLAP Service Manager. The URL of the OLAP Service Manager is https://host:port/BI/APP/SOAP/OLAPDB. If SSL/TLS encryption is not enabled for service-to-service security, use http:// instead. The port of OLAP Service Manager can be configured in Service Expert. OLAP Service Manager forwards the DISCOVER_DATASOURCES request to the System Worker which then responds. From this response, pick the URL of the appropriate Database Worker and connect to it using this URL.
Some Infor EPM farms are configured as single-tenant Cloud. Direct access to OLAP in a single-tenant Cloud environment is not possible in general. However, a special ELB (Elastic Load Balancer) option can be deployed. This needs to be requested before single-tenant Cloud provisioning is done. In this case, the port of the ELB need to be addressed, not the port of the OLAP Service Manager.