Reltio Connect

 View Only
  • 1.  Extract Source name in Potential Match extract using ROCS

    Posted 11-03-2023 09:02

    Hi All,

    We are extracting Potential Matches report using ROCS utility. Is there a way to extract crosswalk information (Source contributor name or ID) to generate reports for Potential Matches.

    Thank you,

    Sudha Polaki



    ------------------------------
    Sudharani Polaki
    First Tech Federal Credit Union
    ------------------------------


  • 2.  RE: Extract Source name in Potential Match extract using ROCS

    Posted 01-25-2024 09:41

    HI,

    Potential match report should give you the crosswalk information.

    https://bitbucket.org/reltio-ondemand/pot-mat-data-extract

    If not,  you should be able to modify the jar to fetch the crosswalk.



    ------------------------------
    Radhakrishnan Ramalingam
    Architect
    San Ramon CA
    ------------------------------



  • 3.  RE: Extract Source name in Potential Match extract using ROCS

    Posted 01-25-2024 20:30

    Hi Radhakrishnan,

    Appreciate your response. If you can provide details on below topics, it will be really helpful:

    What mapping parameters we need to provide to extract the Crosswalk information as part of existing ROCS functionality?

    Thanks & Regards,

    Sudha



    ------------------------------
    Sudharani Polaki
    First Tech Federal Credit Union
    ------------------------------



  • 4.  RE: Extract Source name in Potential Match extract using ROCS

    Posted 01-27-2024 16:20

    Sudha,

    Checked the code. I couldn't find the reference for the crosswalk extract.   Please work with your developers to extract the crosswalk.   You need to modify the PMExtractTask.java file to add the crosswalk info.

    if that doesn't work, here are a few options for you.

    1. Select the match rule in the  UI along with its Matching attributes including crosswalks, and export them as CSV
    2. Run the potential match report with a few attributes. This report should give you the entity URI along with the Matched URI
    3. Do the Vlookup in Excel or use any of the SQL database  

    The Reltio snowflake connector has the potential matches and merges view.

    https://docs.reltio.com/en/integrate/export-data-from-reltio-in-bulk/export-data-from-reltio-to-business-intelligence-tools/reltio-snowflake-connector/datasets-for-the-snowflake-data-schema/matches-dataset-for-snowflake

    Hope this helps.



    ------------------------------
    Radhakrishnan Ramalingam
    Architect
    San Ramon CA
    ------------------------------



  • 5.  RE: Extract Source name in Potential Match extract using ROCS

    Posted 01-29-2024 19:19

    Hi Radhakrishnan ,

    Thank you for the follow up with the recommendations. This is helpful.

    Regards,

    Sudha



    ------------------------------
    Sudharani Polaki
    First Tech Federal Credit Union
    ------------------------------