Extract data from heterogeneous databases.

  • 6
  • Problem
  • Updated 3 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

  • 916 Points 500 badge 2x thumb

Posted 8 months ago

  • 6
Photo of Denise Stokowski

Denise Stokowski, Official Rep

  • 11,214 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

  • 916 Points 500 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

  • 11,214 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

  • 4,178 Points 4k badge 2x thumb
Yes and yes
Photo of Aditya Marla

Aditya Marla, Employee

  • 1,374 Points 1k 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

  • 4,178 Points 4k 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

  • 7,878 Points 5k 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

  • 7,878 Points 5k 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,372 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

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

Aditya Marla, Employee

  • 1,374 Points 1k 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,372 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... :-)