An XML/A connection describes how to connect to a remote XML/A provider, such as an XML/A source in another instance of JasperReports Server. In this case, the XML/A source points to a Mondrian connection in the remote server.
Anatomy of an XML/A Connection
JasperReports Server can act as either an XML/A provider or as an XML/A client. In the former case, remote servers retrieve data from an OLAP data source exposed by an XML/A definition in the JasperReports Server repository. In the latter case, JasperReports Server connects to a remote XML/A provider to retrieve data that populate reports and views. Typically, the server accesses a remote instance of JasperReports Server to form a distributed environment (Performance Tuning), but the server can also connect to other types of XML/A provider, such as Microsoft SQL Server Analytic Services (SSAS). Because JasperReports Server uses OLAP4J (http://www.olap4j.org/), it may also be able to connect to other types of XML/A provider, though such configurations aren't currently certified. In this release, only JasperReports Server and Microsoft SQL Server Analytic Services are certified as XML/A providers.
The remote server must also be configured for XML/A. For instructions regarding Jaspersoft OLAP, see Jaspersoft OLAP Administration and Creating an XML/A Source. If you're connecting to Microsoft SQL Server Analytic Services, at a high level, you must:
|•||Configure Internet Information Services (IIS) to provide connectivity to Microsoft SQL Server Analytic Services.|
|•||Deploy and configure msmdpump.dll, which is an IIS extension that provides data connectivity via HTTP.|
|•||Configure security in Microsoft SQL Server Analytic Services according to your needs.|
|•||Test Microsoft SQL Server Analytic Services using an XML/A client tool, such as waRehouse EXplorer (REX; http://sourceforge.net/projects/whex), which is an open source Java client for browsing multidimensional data sources. Testing with a third-party tool can help you troubleshoot your Microsoft SQL Server Analytic Services configuration.|
For more information about Microsoft SQL Server Analytic Services, refer to the associated documentation.