Integrate with Tableau

Owned by Brendan Kelly (Deactivated)
Nov 25, 2020
2 min read

ModelOp Center seamlessly integrates with existing Business Intelligence (BI) systems, such as Tableau, to allow enterprises to allows users to create custom ModelOps-related visualizations, using 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. With all of that data, one challenge is to make the data visible and consumable in dashboards that can represent these key Model KPIs. Some of these KPIs include: What kinds of models are developed in your business? How many of those models are eventually delivering business value? What are the impacts of these models on your runtime environments?

ModelOp Center integrates with Tableau in order to allow it to provide enterprise grade BI tools to design your own reports rather than rely on built-in static reports.

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. After connecting through our Sprint Cloud Gateway services, select the test data desired from the interface.

     

  4. 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 an 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.