Skip to main content

Tableau - Connecting to IOMETE

In this guide, we will explain how to effortlessly integrate IOMETE with one of the most popular BI tools: Tableau.

What is Tableau?

Tableau is an Business Intelligence, Reporting and Dashboarding tool. Data has limitless potential to transform businesses and the world as long as people are empowered to use it. Tableau is used to build a data culture and to change lives while providing access to the data.

Tableau should be accessible from cloud

Tableau can be directly connected from the tableau cloud page.

Add IOMETE as the data source

The next step is to connect the IOMETE Lakehouse to Tableau.

Create a new workbook in Tableau. Once new workbook interface is opened up, you will have the following menu, where you need to add a new data source:

IOMETE data source | IOMETEIOMETE data source | IOMETE

After clicking on the “New Data Source”, an option would be provided to select a source. Then click on “Connectors” tab. In the Connectors tab, select Spark SQL as your database:

Spark SQL database | IOMETESpark SQL database | IOMETE

Once Spark SQL is selected following pop-up would be provided, and then you should be able to enter the details for connecting to IOMETE Lakehouse. Server details can be found in your “Lakehouse” which you want to connect for analytical purposes.

connect IOMETE lakehouse | IOMETEconnect IOMETE lakehouse | IOMETE

All connection properties can be extracted from the connection string, from the “lakehouse” details sheet in IOMETE (sample picture below):

ConnectionSparkThriftServer(Spark1.1 and later)
Server{domain or IP address}
Port{server port}
AuthenticationUsername and Password
Username{your user name}
Password{personal access token}
HTTP Pathlakehouse/{lakehouse name}
IOMETE lakehouse details | IOMETEIOMETE lakehouse details | IOMETE

Once the platform is connected, it would appear as a database as presented below with name “Fuad”. And then the “Schema” provides list of schemas from which tables can be selected for reporting purposes.

In the following example, “sample_db” schema is selected and then “employees_proxy” database is previewed before it’s used part of the report to be generated.

Tableau schema connector | IOMETETableau schema connector | IOMETE

Looking at the table details helps to understand the data types and based on which the reporting can take place.

The report requirement is to generate the gender equality for recruitment within organization across years.

table report | IOMETEtable report | IOMETE

Once table is selected we can add a report to the sheet, by adding a attribute (”Hire Date”) to the report Sheet. It’s done by clicking on the “Add to Sheet” after right-clicking on a attribute. Hire Date is important to understand which year an employee is recruited and on-boarded into the organization.

report to sheet Tableau | IOMETEreport to sheet Tableau | IOMETE

Gender provides the details on which gender has been recruited during that period.

gender sheet tableau | IOMETEgender sheet tableau | IOMETE

Then we need to add number of employees onboarded each year, such that count of the number of employees joined is put on a table.

employees sheet tableau | IOMETEemployees sheet tableau | IOMETE

Once the counts are there, then in Tableau a visualization can be chosen to present the report.

A nice looking dashboard presenting the information of required report. Tableau and IOMETE work together seamlessly, lets get connected to take your data analytics to next level.

IOMETE Tableau dashboard | IOMETEIOMETE Tableau dashboard | IOMETE

How to connect to IOEMTE using Spark SQL by CData connector

  1. Download Tableau and install.
  2. Download tableau Spark SQL by CData and install.
  3. Open tableau.
  4. Click To a server and find Spark SQL by CData and click.
  5. Enter following properties.
Server{domain or IP address}
Port{server port}
Auth SchemePlain
User{your user name}
Password{personal access token}
Transport ModeHTTP
HTTP Pathlakehouse/{lakehouse name}
Use SSLTrue
IOMETE tableau CData connector | IOMETEIOMETE tableau CData connector | IOMETE