Reltio Connect

 View Only
Expand all | Collapse all

Monitoring - Mapping of Seed File Upload to Reltio

  • 1.  Monitoring - Mapping of Seed File Upload to Reltio

    Posted 05-13-2024 01:02


    Could you please let me know how the seed file mapping will be uploaded to reltio post registration to monitoring framework.
    Will the configuration be same as batch API trigger.
    Since the seed file will have update,delete,seed files.How will the mapping be handled once the file is placed in s3



    ------------------------------
    Akshaya Jawaharr
    Freshworks
    Chennai
    ------------------------------


  • 2.  RE: Monitoring - Mapping of Seed File Upload to Reltio

    Reltio Employee
    Posted 05-13-2024 04:05

    Hi Akshaya, 

    Once the seed files/notification files are available in the S3, you will need to execute the monitoring background job API to process those files in Reltio.  

    Here is the documentation for the same - https://docs.reltio.com/en/explore/get-going-with-apis-and-rocs-utilities/reltio-rest-apis/integrate-apis/db-connector-apis/monitoring-apis/monitoring-background-jobs

    You can execute this API in the ad-hoc mode as well as in scheduled mode using the cronExpression property. There is a small difference, which you should keep in mind though

    • If you run the API in ad hoc mode, it will process all files available in the S3 bucket. So this approach can be useful for processing the initial SEED data sent just after the monitoring registration. 
    • A cron-scheduled background monitoring process automatically calculates the new files on each iteration by searching for previously started jobs and extracting the max file timestamp from them. So, only the delta files will be processed in this approach. This is useful for your periodic monitoring data processing. 

    Also, the mapping for different notification types are handled through the Enrichment mapping. You should find the following sections in the Enrichment mapping. 


    Let me know if this answers your question. 



    ------------------------------
    Diparnab Dey
    Technical Consultant
    Reltio
    Kolkata, West Bengal
    ------------------------------



  • 3.  RE: Monitoring - Mapping of Seed File Upload to Reltio

    Posted 05-13-2024 04:58

    Thanks Diparnab Dey,

    What happens in case we choose only full product.is that option possible while registering for monitoring.what would be the best approach to be followed while doing dnb monitoring framework.Could you please provide us the gist



    ------------------------------
    Akshaya Jawaharr
    Freshworks
    Chennai
    ------------------------------



  • 4.  RE: Monitoring - Mapping of Seed File Upload to Reltio

    Posted 05-13-2024 05:02

    could you please provide the link for enrichment mapping provided in screenshot



    ------------------------------
    Akshaya Jawaharr
    Freshworks
    Chennai
    ------------------------------



  • 5.  RE: Monitoring - Mapping of Seed File Upload to Reltio

    Reltio Employee
    Posted 05-13-2024 05:10

    Hi Akshaya, 

    Reltio D&B Direct plus connector only allows us to use FULL_PRODUCT for monitoring registration. Refer to the documentation - https://docs.reltio.com/en/integrate/reltio-data-enrichment-integrations/reltio-enrichment-with-db/working-with-reltio-enrichment-with-db/monitor-reltio-enrichment-with-db#registration-0 for the options that needs to be used during monitoring registration. 

    Also, the screenshot that I shared is from the Enrichment mapping. You can execute the Get Enrichment Mapping API to retrieve this. Here is the Reltio documentation - https://docs.reltio.com/en/explore/get-going-with-apis-and-rocs-utilities/reltio-rest-apis/integrate-apis/db-connector-apis/mapping-apis/on-demand-enrichment-apis/get-enrichment-mapping

    Here is the cURL for the API 

    curl --location 'https://361-dnbconnector.reltio.com/b2bIntegration/config/profiles/{{dnbProfile}}/mappings/enrichment?plus=true' \
    --header 'Authorization: Bearer {{accessToken}}' \
    --header 'Content-Type: application/json'


    If you are executing the API in a DEV/TEST environment change the dnb connector URL to https://test-dnbconnector.reltio.com/b2bIntegration





    ------------------------------
    Diparnab Dey
    Technical Consultant
    Reltio
    Kolkata, West Bengal
    ------------------------------



  • 6.  RE: Monitoring - Mapping of Seed File Upload to Reltio

    Posted 05-13-2024 05:22

    Thank you.

    One final question if we choose dnb full product enrichment we need not worry about update,seed,under review notifications right?


    is my understanding correct
    Whatever may be the change in duns number / new seed value it will provide full product details



    ------------------------------
    Akshaya Jawaharr
    Freshworks
    Chennai
    ------------------------------



  • 7.  RE: Monitoring - Mapping of Seed File Upload to Reltio

    Reltio Employee
    Posted 05-13-2024 05:43

    Hi Akshaya, 

    The notification files will provide the full product details for for the notification type "SEED". That means for the DUNS numbers where D&B data is updated, you will get full snapshot of the D&B data in monitoring with notification type "SEED". However, for two other important notification types i.e. "TRANSFER" and "DELETE", the behavior is a bit different. 

    • For "DELETE" only the deleted DUNS number is sent in the monitoring notification file. And when that file is processed in Reltio, the connector will just update the DnBSource attribute to "Monitoring: delete duns". The existing D&B crosswalk data will not be modified. So you may need to build a process outside to check the records with this status and Delete/inactivate the DUNS number crosswalk data i.e. enrichment data.  This will depend on your requirement. 

    • For "TRANSFER", the previous DUNS number and the new DUNS number is sent from D&B in the monitoring notification file. And when that is processed in Reltio, the connector updates the DnBSource attribute to "Monitoring: transfer duns" and add the new DUNS number against the new DUNS number crosswalk. However, enrichment data for the new DUNS number is not sent. So for this scenario as well, as per requirement, you may need to build a process 
      • Check for the records where DUNS transfer occurred. 
      • Delete/inactive the old DUNS number crosswalk.
      • Re-enrich the records with the new DUNS number information, so that enrichment data is up to date. 


    ------------------------------
    Diparnab Dey
    Technical Consultant
    Reltio
    Kolkata, West Bengal
    ------------------------------



  • 8.  RE: Monitoring - Mapping of Seed File Upload to Reltio

    Posted 05-13-2024 05:55

    Thanks a lot what happens in the case of full product detail notification is selected and we have an update for a record



    ------------------------------
    Akshaya Jawaharr
    Freshworks
    Chennai
    ------------------------------



  • 9.  RE: Monitoring - Mapping of Seed File Upload to Reltio

    Posted 05-13-2024 05:57

    what happens when we chose full product detail vs update notification differences in API file structure,operations,notification types



    ------------------------------
    Akshaya Jawaharr
    Freshworks
    Chennai
    ------------------------------



  • 10.  RE: Monitoring - Mapping of Seed File Upload to Reltio

    Reltio Employee
    Posted 05-13-2024 06:01

    Akshaya,

    You cannot select just update notifications. As I mentioned previously, Reltio D&B connector only works with FULL_PRODUCT



    ------------------------------
    Diparnab Dey
    Technical Consultant
    Reltio
    Kolkata, West Bengal
    ------------------------------



  • 11.  RE: Monitoring - Mapping of Seed File Upload to Reltio

    Posted 05-13-2024 07:33

    What is the steps to choose full product details and how can we register this to reltio

    Could you please summarize the steps to be followed for dnb monitoring framework



    ------------------------------
    Akshaya Jawaharr
    Freshworks
    Chennai
    ------------------------------