InterSystems IRIS Analytics connector for Google Data Studio

Features

Visuzalization with Google Data Studio
Works with InterSystems IRIS Analytics (DeepSee)
Utilizes /api/deepsee embeded in IRIS
Generates MDX queries and execute them on the target server

Demo Report

Developer Community Analytics

Installation and development

Requirements

Access to Google Apps Script
cli tool for Google Apps Script, installed globally with npm
npm i @google/clasp -g

Authorize clasp to get access to your account on Google Apps Script, with command

clasp login

To confirm successful authorization, may you this command

clasp login --status

Clone this repo

git clone https://github.com/caretdev/iris-analytics-datastudio.git
cd iris-analytics-datastudio

Deploy the application with one make command, this will create a new project on Google Apps Script, push files there, and deploy it

make

Any subsequent make will skip creation Google Apps Script if file .clasp.json exists. And will skip to create a new deployment if file .deploymentId exists. For existing deployment it will create a new version with the deployment id stored in file .deploymentId. So, after any changes in javascript files, needs to call make to deploy those changes.

Usage

Open Google Data Studio. Create a new Data Source, select “Build your own” connector.

Build Your Own connector

Enter Deployment ID stored in file .deploymentId, and press Validate, it should show the tile with a new connector below

New Connector

Authorize connector, by button Authorize. Then it will be possible to enter URL to /api/deepsee of desired server available online, and credentials. URL should be in form https://myiris.example.com/api/deepsee/v1/MYNAMESPACE/, with /api/deepsee and target Namespace. Username and password for user with permissions to execute queryes there

Connection Settings

After veerification, it will allow to select a Cube, then press Connect

Select Cube

On the next screen it should show all the dimensions and metrics available for the selected cube

Fields