Anaplan XL Reporting allows you to connect to Databricks as one of the supported relational connectors.

To connect:

  1. Select Connections from the Anaplan XL Menu
  2. Choose New Connection in the Connections dialog.
  3. Select Relational and choose Databricks.

The format required for the Server Address field is the concatenation of the three elements below:

  1. https://
  2. Server hostname
    For example: mycompanyname-prd-pds-us-west-2.cloud.databricks.com
  3. HTTP path
    For example: /sql/1.0/warehouses/8318a6c1fcff08da

The server hostname and HTTP path are shown in the SQL Warehouses – Connection details screen in Databricks.

The final format for the example above would be:

https://mycompanyname-prd-pds-us-west-2.cloud.databricks.com/sql/1.0/warehouses/8318a6c1fcff08da

After entering the Server hostname, select the Requires Logon checkbox. Then, choose your preferred Auth Type to Connect, and the available databases will be listed.

Having connected, you can create Table style reports using valid Databricks SQL syntax.