Class XmlaOlap4jDriver

java.lang.Object
org.olap4j.driver.xmla.XmlaOlap4jDriver
All Implemented Interfaces:
Driver

public class XmlaOlap4jDriver extends Object implements Driver
Olap4j driver for generic XML for Analysis (XMLA) providers.

Since olap4j is a superset of JDBC, you register this driver as you would any JDBC driver:

Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
Then create a connection using a URL with the prefix "jdbc:xmla:". For example,
import java.sql.Connection;
import java.sql.DriverManager;
import org.olap4j.OlapConnection;

Connection connection =
   DriverManager.getConnection(
      "jdbc:xmla:");
OlapConnection olapConnection =
   connection.unwrap(OlapConnection.class);

Note how we use the java.sql.Connection#unwrap(Class) method to down-cast the JDBC connection object to the extension OlapConnection object. This method is only available in JDBC 4.0 (JDK 1.6 onwards).

Connection properties

Unless otherwise stated, properties are optional. If a property occurs multiple times in the connect string, the first occurrence is used.

It is also possible to pass properties to the server end-point using JDBC connection properties as part of the XMLA driver connection properties. If the JDBC URL contains properties that are not enumerated in XmlaOlap4jDriver.Property, they will be included as part of the SOAP PropertyList element.

Property Description
Server URL of HTTP server. Required.
Catalog Catalog name to use. By default, the first one returned by the XMLA server will be used.
Schema Schema name to use. By default, the first one returned by the XMLA server will be used.
Database Name of the XMLA database. By default, the first one returned by the XMLA server will be used.
Cache

Class name of the SOAP cache to use. Must implement interface XmlaOlap4jCachedProxy. A built-in memory cache is available with XmlaOlap4jNamedMemoryCache.

By default, no SOAP query cache will be used.

Cache.* Properties to transfer to the selected cache implementation. See XmlaOlap4jCache or your selected implementation for properties details.
TestProxyCookieString that uniquely identifies a proxy object in PROXY_MAP via which to send XMLA requests for testing purposes.
Role Comma separated list of role names used for this connection (Optional).
Available role names can be retrieved via OlapConnection.getAvailableRoleNames()
User User name to use when establishing a connection to the server. The credentials are passed using the HTTP Basic authentication protocol, but are also sent as part of the SOAP Security headers.
Password Password to use when establishing a connection to the server. The credentials are passed using the HTTP Basic authentication protocol, but are also sent as part of the SOAP Security headers.
Since:
May 22, 2007
Author:
jhyde, Luc Boudreau
  • Field Details

    • PROXY_MAP

      public static final Map<String,XmlaOlap4jProxy> PROXY_MAP
      For testing. Map from a cookie value (which is uniquely generated for each test) to a proxy object. Uses a weak hash map so that, if the code that created the proxy 'forgets' the cookie value, then the proxy can be garbage-collected.
  • Constructor Details

    • XmlaOlap4jDriver

      public XmlaOlap4jDriver()
      Creates an XmlaOlap4jDriver.
  • Method Details