Acesso ao Analysis Services via HTTP/HTTPS: arquitecturas, configurações e mecanismos de autenticação e controlo de acesso

Abstract

Analysis Services disposes three Access Mechanisms: Direct Access, HTTP/HTTPS Access and XMLA Access. From among these mechanisms, the Direct Access is that one that guarantees the lowest response time and the strongest security, characteristics that turn it the mechanism of preferential use. But this mechanism can be used only in intradomain accesses, by imposition of the Authentication Mechanism that it uses, the Integrated Windows Authentication. When the Client and the Analysis Services doesn’t share the same domain, or when the access must be made by Internet, can be used the HTTP/HTTPS Access Mechanism. However, the use of this mechanism is not trivial, presenting some peculiarities; a consequence of Analysis Services doesn’t to support, by him self, HTTP/HTTPSAccesses. In fact, HTTP/HTTPS Access to Analysis Services is provided by the IIS Web Server.In this paper, the Logical Model and the Physical Models, used by Analysis Services, to provide HTTP/HTTPS access thought the IIS Web Server, will be analyzed, and will be explained the steps required to setting it up. The Mechanisms of Security and Access Control, used by Analysis Services, will be analyzed too, being covered both Users Authentication and Security Roles Definition.