phpOLAPi is a PHP-client for XMLA webservices. It allows to build and execute MDX queries, transform the results into different structures and even explore database schemas, cubes, measures, dimensions, etc.
The number of business web apps powered by PHP is rapidly increasing, which leads to a growing need for backend-integration with enterprise systems like ERP, CRM, WMS, etc. However, when it comes to large business software like SAP, integration is not really straight forward - especially with web applications built with totally different technology. This article aims to give an overview of different possibilities to exchange data between a PHP-based web app with a SAP backend.
This article demonstrates, how to query OLAP cubes in Microsoft SQL Server Analysis Services (SSAS) using an ODBC connection. Although, the code examples are provided in PHP, this method should work with any other programming language. In PHP, the same can be done via the sqlsrv extension. In a nutshell, we are going to tunnel MDX queries through SQL via OPENQUERY() or OPENROWSET() functions.
Guzzle is probably the most popular PHP HTTP Client, but since the latest version introduced native support for the PSR-7 HTTP message interface, there is no more built-in cache. In this tutorial I will demonstrate how to use any caching library supporting the standard PSR-6 cache interface with Guzzle.