Skip to main content
jim_barker
jim_barker
Contributor ⭐️⭐️
November 14, 2020
New Idea

Px Connector - Ability to Populate Custom MDA Table

Related products:CS Data Management & Integrations
  • November 14, 2020
  • 3 replies
  • 119 views

Please create an enhancement to the Px Connector in Cs so that you are able to pull data from either the Account or Audience table and populate a custom MDA object.  The connector currently only allows for updates to Company or Company Person but more is needed.

One use case:  A business does NOT want to have users from their application in the Company Person/Person tables, they want to have a customer table called online_user.  They don’t want 1000+ software users in Company Person/Person, they only want SFDC Contacts in those tables...they are desperate for a secondary table.

 

 

    3 replies

    link_black
    link_black
    Gainsight Employee ⭐️⭐️
    November 23, 2020

    IMO - This would be a nice extension of the CS PX Connector, but similar results/possibilities can be achieved right now with a custom PX+CS integration using the high level steps below:

    1. Enable the PX AWS S3 integration to have user, account, and other aggregated usage information pushed to either the Gainsight Managed or Customer’ Managed AWS S3 bucket nightly
    2. Ingest the nightly Users and Accounts exports with a CS Rules “S3 Dataset Task” and implement the required Actions to insert/update/upsert into the desired CS MDA tables.  

     

    -- Link
      Pragati Garg
      Helper ⭐️
      January 13, 2021

      Hi, @jim_barker we have the requested item on our roadmap. Meanwhile, the workaround that @link_black suggested can help. 

        broghanzwack
        broghanzwack
        Contributor ⭐️⭐️⭐️⭐️⭐️
        July 31, 2023
        Under Consideration→Implemented
        Terms & ConditionsAccessibility statement