Extract data from heterogeneous databases.

  • 7
  • Problem
  • Updated 5 months ago
  • In Progress
Currently, we are unable to fetch data from heterogeneous databases in MDA. Can we make this possible in future?
Photo of Ankur Bhat

Ankur Bhat, Employee

  • 1,136 Points 1k badge 2x thumb

Posted 1 year ago

  • 7
Photo of Denise Stokowski

Denise Stokowski, Official Rep

  • 12,290 Points 10k badge 2x thumb
Ankur - Can you clarify your ask/use case?  Do you mean within Gainsight MDA or from outside of Gainsight?
Bionic Rules in this release so fill the gaps with accessing from multiple sources and posting to S3 Export as an option.
Photo of Ankur Bhat

Ankur Bhat, Employee

  • 1,136 Points 1k badge 2x thumb
Joins are good Denise. We have lookup from MDA custom Object to Company Object to Scoring_scheme_definition. The first two reside in Redshift and the last one in Postgres. Hence the query formed in this case throws the error.
Photo of Denise Stokowski

Denise Stokowski, Official Rep

  • 12,290 Points 10k badge 2x thumb
So the scorecard component is where you have the challenge?  You are using Scorecard 2.0 right?
Photo of Spencer Engel

Spencer Engel, Employee

  • 5,638 Points 5k badge 2x thumb
Yes and yes
Photo of Aditya Marla

Aditya Marla, Employee

  • 3,104 Points 3k badge 2x thumb
Hi Spencer,

Let me know if my understanding is correct here....you have a custom MDA object that has data about the usage metrics for different companies over time and you want to report how these metrics are varying across the health score labels.

Would creating a new field in the custom MDA object (that contains usage data) that captures the current health score label of the corresponding company solve the issue? You can then use new this field in reporting (instead of the field looking up to the Scoring scheme definition).You can write a bionic rule which will fetch the health score label of a company and load it into this new field 
Let me know if this works 

Thanks
Photo of Spencer Engel

Spencer Engel, Employee

  • 5,638 Points 5k badge 2x thumb
I suppose it would technically, but I still think this is something we need to address so that we're not having to do workarounds for reports like this.
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 12,406 Points 10k badge 2x thumb
Hi Spencer, Sorry for the trouble. I will discuss with our engineering team on this and I will get back to you.
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 12,406 Points 10k badge 2x thumb
Hi Spencer,Sorry,currently this is a limitation in the product. I am working to get an workaround on this,will update you once I find the workaround.
Photo of Jeffrey Coleman

Jeffrey Coleman, Champion

  • 5,958 Points 5k badge 2x thumb
Wanted to jump in from a customer perspective on this. I just tried to generate a report using data I'd loaded to MDA (so a custom object) which looked up to the Company object (Gainsight standard.) From there I went to the (again totally OOTB from Gainsight Connect) Current Score which failed because of this issue.

I don't have a (valid) view as to how this should be engineered. But I do think that the underlying data structures should be totally transparent to the end user and admin. That I need to go back and create duplicate fields and mappings (rather than using the OOTB connectors) in order to complete this report seems like a miss.
Photo of Jeff Kirkpatrick

Jeff Kirkpatrick, Champion

  • 25,412 Points 20k badge 2x thumb
Agree!!
Photo of Aditya Marla

Aditya Marla, Product Manager

  • 3,104 Points 3k badge 2x thumb
Hi Jeffery,

Agree that this should be possible without the need to write any extra rules. We will be looking into fixing this so that health score is easily available when reporting on custom objects.
One question, apart from the score & score label would you need any other fields in reporting?

Regards
Photo of Jeffrey Coleman

Jeffrey Coleman, Champion

  • 5,958 Points 5k badge 2x thumb
Great! I don't have anything in mind... but then I didn't know I needed the score label until I went to go build that report so... :-)
Photo of Wayne Baker

Wayne Baker, Employee

  • 1,356 Points 1k badge 2x thumb
Adding on to this, seems strange that we provide the ability to see fields from these different databases through joins in report builder when we know the report won't work.

Any idea on a timeline of fixing this? And/Or removing the ability to pick fields from the report builder? We just wasted a few days and man hours on me trying to resolve it, then L1 to trying to, to L2 trying to resolve, then to engineering to understand this issue. 
Photo of Dan Wiegert

Dan Wiegert, Employee

  • 1,516 Points 1k badge 2x thumb
I have been working with Wayne on this, and agree with his sentiments. There is currently no positive indication that this issue is being pursued for resolution. I would be happy to discuss this issue in another venue, but it would be great to know that this issue was on engineering/dev's radar.
Photo of Aditya Marla

Aditya Marla, Product Manager

  • 3,104 Points 3k badge 2x thumb
Hi Wayne & Dan,

This is on the roadmap but I do not have an ETA as of no. Also, we will make it easier to possible to create the report rather than prevent the selection of the fields. Will keep you posted on any progress.  

Thanks
(Edited)