Extract data from heterogeneous databases.

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.

Hi Denise - in this case Ankur was posting on my behalf re: a support ticket I filed. I was trying to build a report for my customer that was built off an MDA object that contained their usage data. 

I was hoping to run a report showing various metrics by date filtered by their overall health score. So ideally they could have a dashboard that showed "Metric A over past 6 months" by red, yellow and green health customers. I was attempting to reference the "overall score" field in the Company object, but ran into an issue because apparently the database that field lives on does not communicate with the Redshift MDA table where my customer stores their usage data. 

Spencer -
In this case, there probably is a missing join between the usage table and Company standard object - you should be able to use the MDA joins in RedShift using the SFDC ID or the GSID.

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.

So the scorecard component is where you have the challenge?  You are using Scorecard 2.0 right?

Yes and yes

Hi Spencer, Sorry for the trouble. I will discuss with our engineering team on this and I will get back to you.

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.

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

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.