One of the most popular questions we get is how can the data from the OLAP cube be transferred to Flexmonster Pivot? Flexmonster Accelerator serves as an additional server-side layer that helps to restrict external access to the database. When connecting to the data source inside the pivot table, the URL to the Accelerator is used instead of the SSAS server URL. Flexmonster Pivot sends the requests to the Accelerator, then Flexmonster Accelerator communicates with the SSAS server and gets the necessary data. This data is sent back to the client from the Accelerator. The flowchart below shows the process:
To ensure server-side data security, the Accelerator doesn’t accept requests from any other web applications, only from Flexmonster Pivot. Is it not possible to send an HTTP request directly to Flexmonster Accelerator without using Flexmonster Pivot. The Accelerator also doesn’t accept a response/request that was changed during the communication process. Each response/request contains a checksum for the package to ensure that it was not changed.
The only requirement is the necessity to open an additional port on the server for the Accelerator. This is not a specific requirement for our component but a strong restriction imposed by the browser’s security. It is absolutely necessary to use CORS and an extra port and there is no workaround. Otherwise, the clients’ browsers will not allow communication with the server.