Database schema with primary and secondary keys to build external to Gainsight product universe for reporting

  • 16 March 2021
  • 6 replies

Greetings Gainsight Community, 

I am looking for a database schema with primary and secondary keys.  I need this to be able to build from the 18 or 19 exported Gainsight tables.  I am building a product universe for reporting and increased dashboarding with other company data outside of the Gainsight environment.


Thanks for reviewing my post.  All contributions are very welcome as it will be more than I had today when I posted this question.

Hope your day is filled with joy and fun!



6 replies

Userlevel 7
Badge +2

Hi @Janine Marlatt can you share a bit more about your use case? If you’re looking to integrate Gainsight data with other non-Gainsight data sources, we have a number of solutions that can help with that. If you want to use Gainsight data outside of Gainsight, we have a full integration with Tableau to let you leverage Gainsight data in that BI tool. If you want to use external data in Gainsight, we have a number of tools to bring that data in to combine for extensive reporting and dashboarding use cases. 

Hi Dan,

We are currently exporting 19 data tables via api into the AWS S3 bucket.  And this is for each Gainsight product tenant.  Very tedious and then something will need to be built to look across all tenants.


Another need just came up to report the in-app performance engagement data for looking at who touched the engagements.  instead of painstakingly going into each one and exporting the detail data… is there a better way to do this?

Userlevel 2
Badge +1

@Janine Marlatt Thanks for the feedback.Would it be possible for you to elaborate on the usecase and painpoints.

We are building where an internet application is a unique tenant in Gainsight.

I am looking for engagement high level dashboard across all Tenants so that we can count the number of assets (engagements) , number of unique viewers, and total number of users.


Also, when listing the analytics/knowledge center/integrated articles.  One must click on the blue link for number of users and then individually export the data.  Why not allow export at the article level?

I wrote a python program to consolidate the engagement exports and the integrated articles exports and tie the download file to the actual engagement name.   

Userlevel 4
Badge +1

@Janine Marlatt 

Would Metadata APIs help you create the objects in scale without having to login to the tenants help here?

Also would the Object details be available as a CSV File? If so, we have the CSV upload option to create Objects and load data in a single flow


Thank you 


Good morning to you Preethi,

Thanks for replying to my email.  I really appreciate your response.

Would you please provide more information on the Metadata APIs?

I use the px-data loader to upload data via json.

I use the BULK API for the download of engagements ready for language translation.

And i have a python script to upload many xliff translated files.  I am told there is no equivalent BULK api for the upload of xliff translated files so that i could spin by api, by engagement where the api file would be an excel file i would use.

I am being asked to report data by label to specify various internal company categories like marketing releases, marketing promotions, educational content etc., and I can’t get this data out in the AWS api stuff either.

Anything you may see that may help will be of benefit.


Thanks again,