Skip to main content
Gainsight Inc.

Gainsight Matrix Data Architecture Overview

Gainsight Standard Edition
This article supports Gainsight Standard Edition. This Edition is built on Gainsight's state of the art Matrix Data Architecture (MDA) platform, and is designed for customer success professionals for driving revenue, increasing retention, and scaling operations. To learn more about Gainsight Standard Edition, click here.

If you are using Gainsight Salesforce Edition, which is built on Salesforce and customer business data is stored in SFDC, you can find supporting documentation here.

 

Overview

The MDA (Matrix Data Architecture) is Gainsight’s proprietary back end infrastructure that serves as the foundation for any instance of Gainsight. From data storage to Gainsight’s Rules Engine, the MDA is the invisible layer that Gainsight is operating on.

Gainsight designed MDA to replicate multi tenancy within the product. Data in MDA is organised and maintained in different types of objects:

  • System Objects
  • Standard Objects
  • Custom Objects

Customer data is collected and stored in various data stores in any organization. It could be resident in CRM / ERP systems or it might reside in internal IT systems. In some scenarios, there could be third party aggregators/tools that collect the information, based on customer usage of the product.

The Gainsight Data Platform offers a mechanism through which all of this data can be managed in the matrix data model, and transform this data to derive business metrics through the tools offered by the Platform - Rules Engine, Aggregations, CTA's, etc.

Connectors are integrations that are offered out of the box to connect the varied data sources and sync up information into Gainsight.
Data Management information is categorized into:

  • Managing Data In Gainsight
  • Gainsight Standard Objects
  • Data Spaces

The MDA is actually a distributed system comprising of four different data store types:

  • AWS Redshift: This is Gainsight’s primary bulk data store DB and holds all the actual data values that are stored in the MDA.
  • Mongo DB: This is a NOSQL type database used to store all the schema / meta data for the tables that are in Redshift.
  • Postgres: This database is used to store and process transactional type data and is used in specific parts of the Gainsight product, such as Scorecards 2.0 and Programs.
  • Redis: This database is used to cache session data.

Databases in MDA.png

  • Was this article helpful?