Resolving schema changes with Gtmhub

Gtmhub is an OKR software which connects to over 100 applications and data stores, such as JIRA, Salesforce or MySQL. We use this data to automatically track and update key results – such as a number of open bugs or average deal size.

In this article, we will introduce a new tool, which helps you keep everything working when the data schema changes.

How does it work?

Gtmhub connects to various data sources and then allows you to build various metrics using either SQL or R programming language. Gtmhub builds data models against 3rd party systems, so for the customers of Gtmhub, all these data sources seem as one. This, also, allows Gtmhub to execute cross-system joins (e.g. calculating the average number of support tickets for enterprise accounts, by combining the data from ZenDesk and Salesforce).

Salesforce to Gtmhub entity mapping
Salesforce to Gtmhub entity mapping

While this approach is very powerful, because of it’s amazing performance and cross-system join operations, changes in the remote schema (e.g. new custom field added to Salesforce) used to be a challenge.

Solution: Schema change resolution

Last week, we have released a new tool that takes care of the changing schema problem. This tool can automatically compare the old schema of a remote system (regardless is it a database or a Saas product) and automatically merge and update all the mappings.

To take advantage of this tool, all you need to do is following:

  • Log in to Gtmhub
  • Navigate to Setup > Data Sources
  • Click on the hamburger icon on the data source for which you wish to update the schema
  • Click on the Schema Change button
Data Source schema change button
Data Source schema change button
  • Once you click on the Schema Change button, the Schema Resolution dialog will appear.
  • If there are no changes, you will see all the mappings as they are without any action
No schema changes dialog
No schema changes dialog
  • If, on the other hand, the schema of the remote data source has been changed (new field was added, a field was removed…) Gtmhub will highlight these changes and offer you the ability to update the schema automatically
Schema conflict resolution
Schema conflict resolution
  • By clicking on the Update Schema button, Gtmhub will take you to the schema update screen and show you in real time how changes are being performed
Update schema progress dialog
Update schema progress dialog

 

Summary

Schema resolution is not a tool that new users of Gtmhub will use immediately. This feature was born out of the experience and need that came from our clients.

Schemas change, data is not static. People add new fields to Salesforce, change the data types in databases, remove the fields from JIRA.

With the new schema resolution tool, Gtmhub makes sure that you can always use the latest data with your OKRs and KPIs.