Extract data from heterogeneous databases.

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.

Agree!!

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

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... 🙂

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. 

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.

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

Do we have any update on this? I have customer having HIGH volume custom object which has a look-up to company table. And the user wants the score value, so the path goes like this -

 

Custom object → Company(Current Score)→ Score(Scoring Scheme Definition)

 

But since High volume data object and the Scoring Scheme Definition resides in two different DBs, the look to retrieve score value is not showing up -

 

Expectation is something like this -