Reltio Connect

 View Only
Expand all | Collapse all

In Reltio Console UI , Bulk Update concept default source is "Reltio", is there any way to set custom SourceSystem Name during Bulk update ?

  • 1.  In Reltio Console UI , Bulk Update concept default source is "Reltio", is there any way to set custom SourceSystem Name during Bulk update ?

    Posted 07-28-2021 12:33
      |   view attached
    In Reltio Console UI ,
    In Bulk Update concept default source is "Reltio",

    is there any way to set custom "Source System Name" during  the Bulk Update ?

    ------------------------------
    Das M
    Subway
    ------------------------------


  • 2.  RE: In Reltio Console UI , Bulk Update concept default source is "Reltio", is there any way to set custom SourceSystem Name during Bulk update ?

    Reltio Employee
    Posted 07-28-2021 19:39
    Hi,
    All updates from the Reltio UI are made with the source system "Reltio", and this is true for bulk update too. 

    It looks like you are trying to bulk update values from another source system without actually reloading the data. Wouldn't that lead to inconsistency between Reltio and the source system? 

    Have you considered using the dataloader and doing a partial update of the attribute, instead of using the bulk update? 


    ------------------------------
    Venki Subramanian
    Reltio
    ------------------------------



  • 3.  RE: In Reltio Console UI , Bulk Update concept default source is "Reltio", is there any way to set custom SourceSystem Name during Bulk update ?

    Reltio Employee
    Posted 07-29-2021 09:16
    I agree with Venki that with our current technology the easiest thing to do is to use the data loader. 

    To expand on the steps, from the same screen as the screen shot above, export the data.  The only field needed in the export is the crosswalk, so only select that field in the export wizard.  Open the CSV file with an editor (excel or other spreadsheet program will work particularly well in this use case) and add a column with the new value to 'bulk update'.  You will need to sort the file by source system and create separate files for each source if you want to use the data loader.  Otherwise, you can use another tool such as the jar available on ROCS.

    VERY IMPORTANT: I want to say this before you think of doing it: the LAST step in the instructions is very important!  Read until the end!
    With the file(s) created above, use the data loader to import the file, mapping the source system and id to the crosswalk and the new column created to the attribute you would like to update.  On the LAST screen of the data loader wizard, there is a radio button that defaults to "Full Update" YOU MUST CHANGE THIS to "Partial update".  If you do not, you will overwrite all your data with the change instead of updating the attribute!

    ------------------------------
    Gino Fortunato
    Senior Solution Engineer
    Reltio
    ------------------------------