Connecting to the XMLA Provider

OLAP provides XMLA-based access to OLAP data models running in an Infor EPM farm. XMLA provides read/write access to existing data models based on XMLA/SOAP and MDX standards. In addition, there is an extended set of XML functions allowing full OLAP data modeling to build entire OLAP models.

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.