# Integration

Data from Jamku can easily be integrated in your tool of choice

  1. Excel
  2. Power BI
  3. 3rd party Tools

WARNING

The Integration feature is currently in it's very early stage. Hence it may introduce some breaking changes in the future. We plan to add many more functionality & data points for connection in future.

# Concept

Instead of manually exporting the data from Jamku and using it in Excel, you can create a connection to Jamku in Excel. Apply all the filtering and data transformation in Excel, as you normally do.

When you wish to refresh the data, simply click on Refresh Button and excel will refresh the data for you. No need to even open Jamku.

While, in above paragraph we have mentioned Excel, it could be Power BI or any of your favorite tool.

# How it works

The connector needs a way to authenticate itself to Jamku. This will enable Jamku to share the data with the conector. We use API Key for authentication.

Go to Office Config > Api Key > Click Add. When you click save, it will create an API Key for you. Keep this API Key secret. Don't share it with anyone. You will need this API Key in create connector in your tool.

# Getting Started

Read our section on Excel, for more details on how to integrate Jamku in Excel. This will provide you a basic idea on how it works.

In brief, the steps are as below

  1. Create API key (Office Configuration)
  2. Choose which
Last Updated: 24 Apr 2020