Integrate with Tableau

ModelOp Center seamlessly integrates with existing Business Intelligence (BI) systems such as Tableau, enabling enterprises to create custom ModelOps-related visualizations using their existing IT investments.

Table of Contents

 

Introduction

ModelOp Center collects and persists detailed metadata about every model across the entire life cycle, from inception to production usage through continuous improvement, in order to govern the models. A key challenge is making this data visible and consumable in dashboards that represent essential Model KPIs. Such KPIs include: What kinds of models are developed in your business? How many of those models will deliver business value? What impact will they have on your runtime environments?

ModelOp Center integrates with Tableau so you can capture and visualize the metrics that make your company unique, using tools you already know and trust.

Tableau Integration Setup

Tableau provides connectivity to external data sources through Web Data Connectors, which ModelOp Center embeds to communicate with our services. Since ModelOp Center comes with this connector preinstalled, there is no need to add additional features into the Tableau installation.

Here are the steps to integrate with Tableau:

  1. Select Web Data Connector from the “Connect to a server” interface.

  2. Enter the web data connector URL to the ModelOp Center installation.

     

  3. If security is enabled, the user is presented with a login screen. Enter the OAuth2/SSO credentials:

  4. After a successful authentication, select “View all models”.

     

  5. Once connected, a series of tables that comes directly from ModelOp Center will be available to start building reports.

 

ModelOp Center will dynamically identify the schema of critical tracked complex data objects and will flatten them into simplified rows of data required by Tableau. This allows for two-way communication between Tableau and ModelOp Center. Parameters can be passed in from Tableau to manage queries and filtering of data and data can be refreshed in reports with minimal effort allowing for Tableau to represent live ModelOp Center data dashboards.

Connecting Tableau to Secure ModelOp Environments

ModelOp Center’s plugin for Tableau allows for integration with an enterprise’s OAuth2 provider to provide the same authorization and access control that is provided in the ModelOp Center UI.

The following provides detailed steps of how Tableau connects to a secured ModelOp Center environment, via OAuth2 Integration using JWT tokens:

 

#

Steps

#

Steps

1

Tableau sends a request to ModelOp Center.

2

ModelOp Center returns a 401, User not authenticated.

3

Tableau component redirects to OAuth2 AS login page.

4

User inputs credentials.

5

Access Token issued from AS to OAuth2 client with OAuth2 Login configuration.

6

Gateway maps session with Access token, and stores locally.

7

Tableau server performs next request.

8

Gateway forwards request along with Access token to the destination service.

9

Service reads Access Token from header, and validates it locally ( JWT ).

10

If token is valid, Service responds.

11

Gateway forwards results to Tableau Desktop.

 

Related Articles