Visualize data from Azure Data Explorer in Sisense
Sisense is an analytics business intelligence platform that enables you to build analytics apps that deliver highly interactive user experiences. The business intelligence and dashboard reporting software allows you to access and combine data in a few clicks. You can connect to structured and unstructured data sources, join tables from multiple sources with minimal scripting and coding, and create interactive web dashboards and reports. In this article, you'll learn how to set up Azure Data Explorer as a data source for Sisense, and visualize data from a sample cluster.
You need the following to complete this article:
Create a cluster and database that includes the StormEvents sample data. For more information, see Quickstart: Create an Azure Data Explorer cluster and database and Ingest sample data into Azure Data Explorer.
The StormEvents sample data set contains weather-related data from the National Centers for Environmental Information.
Connect to Sisense dashboards using Azure Data Explorer JDBC connector
Download and copy the latest versions of the following jar files to ..\Sisense\DataConnectors\jdbcdrivers\adx
Open Sisense app.
Select Data tab and select +ElastiCube to create a new ElastiCube model.
In Add new ElastiCube Model, name the ElastiCube model and Save.
Select + Data.
In Select Connector tab, select Generic JDBC connector.
In the Connect tab, complete the following fields for the Generic JDBC connector and select Next.
Field Description Connection String
JDBC JARs folder
Driver's Class Name
User Name AAD user name Password AAD user password
In the Select Data tab, search Select Database to select the relevant database to which you have permissions. In this example, select test1.
In test (database name) pane:
- Select the table name to preview the table and see the table column names. You can remove unnecessary columns.
- Select the check box of the relevant table to select that table.
- Select Done.
Select Build to build your dataset.
In the Build window, select Build.
Wait until build process is complete and then select Build Succeeded.
Create Sisense dashboards
In Analytics tab, select + > New Dashboard to create dashboards on this dataset.
Pick a dashboard and select Create.
Under New Widget, select + Select Data to create a new widget.
Select + Add More Data to add additional columns to your graph.
Select + Widget to create another widget. Drag and drop widgets to rearrange your dashboard.
You can now explore your data with visual analytics, build additional dashboards, and transform data into actionable insights to make an impact on your business.