All Collections
Integrations
Resolving schema changes with Quantive
Resolving schema changes with Quantive

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

Neli Ivanova avatar
Written by Neli Ivanova
Updated over a week ago

Quantive Results 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 go over the schema resolution tool, which helps you keep everything working when the data schema changes.

How does it work?

Quantive Results connects to various data sources and then allows you to build various metrics using SQL .

Quantive Results builds data models against 3rd party systems, so for the customers of Quantive, all these data sources seem as one. This, also, allows Quantive Results 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 Quantive Results entity mapping.

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

Solution: Schema change resolution

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 if it's 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 Quantive Results

  • Navigate to Settings then under the Integrations section select Data Sources.

  • Open up the data source for which you wish to update the schema, click on the ellipsis menu and select Schema Changes.

  • Once you click on the Schema Change button, the Schema Resolution dialog will appear.

  • If If there are no changes, you will see all the mappings as they are without any action

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…) Quantive Results will highlight these changes and offer you the ability to update the schema automatically via the Update Schema button.


Schema conflict resolution

  • By clicking on the Update Schema button, Quantive Results will take you to the schema update screen and show you in real time how changes are being performed

    Update schema progress dialog

Summary

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

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

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

Did this answer your question?