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

To connect to Databricks:

  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 appear on 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. The available databases appear.

After connecting, you can create table-style reports using the valid Databricks SQL syntax.