Reltio Connect

Hello everyone, 
I want to generate a report that helps us identify count of crosswalks for each MDM ID  and further break those crosswalks down to identify how many records are coming from each of the sources. Any ideas?
I want something like this:

Hi Haresh,

Thanks for asking this question. I can think of two ways of achieving this:

1. Use the native export functionality to export the data from Reltio in a CSV format. Load that CSV file into Excel and generate the report in the format you desire.
2. Use Reltio analytics which transfers the data from Reltio tenant in real-time to GBQ relational tables. You can query the GBQ tables to generate the report and optionally connect it to various BI tools.

See below screenshot where I generated the report in the format you asked from my sandbox GBQ environment:


The report was generated using the below SQL query :

select
   a.id as MDM_ID,
   a.crosswalk_count,
   b.source as crosswalk,
   b.source_cw_count as breakdown 
from
   (
      select
         id,
         count(id) as crosswalk_count 
      from
         `customer - facing.views_riq_dw_gus_training_<tenant>.entity_Organization`,
         unnest(crosswalks) as cw 
      group by
         id
   )
   a 
   inner join
      (
         SELECT
            id,
            cw.source,
            count(id) as source_cw_count 
         FROM
            `customer - facing.views_riq_dw_gus_training_<tenant>.entity_Organization`,
            unnest(crosswalks) as cw 
         group by
            id,
            cw.source
      )
      b 
      on a.id = b.id 
order by
   a.id limit 100;​

Read more about Reltio Analytics here

Please let me know if you have any follow up questions.

Thanks,
Snehil

I use the following api to generate a summary report

[GET] {apiURLForTenant}/entities/?filter=(equals(type,'configuration/entityTypes/{entityType}') and gt(crosswalks_count,'{maxCount}') and gte(updatedTime,'{lastRunEpoch}'))&select=uri,updatedTime,crosswalks&max={blockSize}&offset={offset}&sort=uri

• {apiURLForTenant} -> your full tenant api url
• {entityType} -> the entity type you are checking on
• {maxCount} -> I use this so I'm only getting uris with large crosswalk counts
• {lastRunEpoch} -> this is to get only the records that were updated since the last time I checked
• {blockSize} -> number of records to pull back per call
• {offset} -> start with zero and add the block size as you iterate thought the list

I'm using python, so I append the response to a list and then run a count on the collections to create a summary data set

@Snehil Kamal thanks a lot​

Hi Haresh, 

We export all data from Reltio to Oracle Tables via a jar program,  so that it can be delivered to downstream applications.   

From these Oracle Tables we have built many end user reports bia Power BI to be able to provide this information.   Do you store the information in any databases outside of Reltio?  This has been a win with our Data Steward team and many end users,   they can 'search ' reltio data without having access to reltio or knowing reltio,  and many Data Quality reports to audit our stewarding have been generated to continually check our data integrity.   We continue to build reports/queries based on requests coming in and use this to build our monthly metrics for the Business. 


Angie

@Brian Geiszler and @Angela Wawrzaszek thanks for such great ideas. ​​