Reltio Connect

 View Only
  • 1.  How to load multiple entities from one source record

    Posted 09-27-2023 15:20

    Can Reltio load same data (source record with same source_id and source_system and source_table) in two different Reltio Entities?

    For example, if my source send a record for a site with address, can I populate the site in both Org and Site entities?


  • 2.  RE: How to load multiple entities from one source record

    Reltio Employee
    Posted 09-29-2023 02:25

    Hi Tarun, 

    The combination of source_id (crosswalk vaue), source system (crosswalk type) and source table is used to identify the unique crosswalks in Reltio. And Reltio does not allow us to persist records with the same aforementioned unique combination across different entities. So in your situation, you will get an error like below : 

    However, there is a way by which you can solve this. 

    • Append the entity name to the source id or the source table which will make the combination different for Org and site entities. 
      e.g. Let's say,  your source id is say ID000001, you can populate your crosswalk data with source id as "ORG|ID000001" for Organization and "SITE|ID000001" for Site. This makes the combination unique for the entity types.

      If you do not want to change the ID, you can do the same manipulation in the Source table as well. And it will work the same way. 

      Example : Here are two record that I have set up in my personal tenant 

      Organization : 


    Let me know if you have any follow up question.

    Diparnab Dey
    Technical Consultant
    Kolkata, West Bengal

  • 3.  RE: How to load multiple entities from one source record

    Founding Member
    Posted 09-29-2023 13:02

    The purpose of Source Table in crosswalks is to avoid a conflict between two different entity type having same source name and source Crosswalk. 

    Ashish Rawat
    Sr. Manager
    Fresh Gravity