How to connect to Azure Databricks from Denodo

Applies to: Denodo 7.0
Last modified on: 17 Oct 2019
Tags: Databricks Azure Cloud JDBC data sources

Download document

You can translate the document:

Goal

This document describes how to connect to Azure Databricks from Denodo Virtual DataPort.

Content

Azure Databricks is an Apache Spark-based analytics platform optimized for Microsoft Azure cloud services.

Connecting to Azure Databricks from Denodo

  • In the Virtual DataPort Administration Tool, select a “JDBC ” data source in order to gather the data from the Azure Databricks.

  • Provide the Name for the JDBC Data source.

  • Select the respective database adapter. In this example, we are using the Spark SQL 2.x Adapter.
  • Provide the Driver Classpath.
  • Now provide the Driver Class. In this case, we provide the class to be ‘com.simba.spark.jdbc4.Driver
  • Next, provide the  Database URI.  

Format : ‘jdbc:spark://<host_name>:<port>/<database_name>; , also, some parameters can be added to URI after the database name like httpPath, Spark Server Type, SSL etc. To know more about the parameters refer to Configure JDBC/ODBC connection.

  • You can select what type of Transaction Isolation you want from the options provided. In this example, we use the ‘Database Default’.
  •  Authentication: There are three options provided. In our example, we are using the ‘Use login and password’.
  •  In the Login provide the username you use for the Azure Databricks instance.
  •  In the Password, provide the access key token.
  •  After providing the connection you can test the connection by clicking on the Test     Connection button.
  •  You should be getting the ‘JDBC connection tested successfully’

  • Now save the data source.
  • Once saved, click on the ‘Create base view tab’ to introspect source metadata available through the Data Source.

  • Click ‘Save’ to save the base view

  • You can also use the ‘Create from query’ option if you wish to custom your base view.

References

Virtual DataPort Administration Guide -  JDBC Sources

Configure JDBC/ODBC connection

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training