Reltio Connect

 View Only

  • 1.  Data Validation Function | Before and After Save

    Posted 05-09-2025 09:37

    Hi Team,

    We have an Important requirement of utilization of DVF function.

    Scenario - We have a simple attribute in an entity known as " Publish Date". Where it must be compared against Reltio's load date through DVF function. I have created a Validation function in Datamodeler in this rule - "Publish Date "Greaterthan" reltioLoadDate". 

    Clarification needed - 

    • Need to define it via Before Save and After Save - 
      • Example 
        • Before Save - Current status in tenant - (publish date is 05/05/2025) and reltioLoadDate is 06/05/2025. 
          • Need it to work like - New data is incoming as publish date is 07/05/2025 and it should be compared against 06/05/2025 and throw validation function. Because after updating it to Reltio - ReltioLoadDate will be updated to current date and it will not work.

        • After Save - Current status in tenant - (publish date is 05/05/2025) and reltioLoadDate is 06/05/2025.
          • It should work as per current state of values present

    Need your all expertise in knowing the feasability and approach to satisfy the requirement.



  • 2.  RE: Data Validation Function | Before and After Save

    Posted 05-12-2025 13:31

    Chetan,

    The Publish Date is already available in the Crosswalk as sourcePublishDate or  crosswalk's updateDate, which can be used to store the actual update date from the source system.

    That said, if you map the source system's lastUpateDate to Reltio's sourcePublishDate, keep in mind that Reltio's  load Date  always reflects the actual load timestamp. Therefore, this requirement becomes theoretically invalid when loading from a legitimate source system into Reltio, since source systems typically maintain proper audit fields like lastUpdateDate. Issues generally arise only when data is manually entered (e.g., via Excel), which increases the risk of errors

    Please reach out to me if you have more questions



    ------------------------------
    Radhakrishnan Ramalingam
    Majix Solutions
    San Ramon, CA
    https://majixsolutions.com
    ------------------------------



  • 3.  RE: Data Validation Function | Before and After Save

    Posted 05-13-2025 01:23

    Hi Radhakrishnan, 

    I agree to the point that reltioLoadDate reflects actual load timestamp. And also i have noticed another case (issue) - Since we are considering DVF at Entity level, reltioLoadDate focuses only on Crosswalk level - So when multiple crosswalks are available - then confusion may arrise.

    So, to avoid that we have considered "Updatetime". But it is still not satsifying requirement. And apologies for confusion on "Publish Date" it is just another timestamp column where external source populates. Please treat the column as another Timestamp column and not Reltio's system values.

    I have added Validation function as -  lte(attributes.Publish_date.value, 'updatedTime.value') \\ Not Working

    Looking for a way to - Use UpdatedTime of the entity to compare against Publish_date(Simple attribute and user defined value)

    Any help on this?

    Thanks,



    ------------------------------
    Chetan P
    Tech Mahindra
    ------------------------------

    Original Message


  • 4.  RE: Data Validation Function | Before and After Save

    Posted 05-13-2025 12:26

    Hi Chetan,

    I'll get in touch with you to understand the requirements

    Thanks



    ------------------------------
    Radhakrishnan Ramalingam
    Majix Solutions
    San Ramon, CA
    https://majixsolutions.com
    ------------------------------

    Original Message


Related Content