Reltio Connect

 View Only
  • 1.  Register Entities for DNB Monitoring in Batch

    Posted 13 days ago

    We are using the batch API to send organizations to DnB for matching and the DnB monitoring API to import updates from DnB for DUNS numbers that are registered for monitoring.  Both of these are scheduled to run daily and are working fine.

    Question for the community is how are you configuring the batch job to register newly added DUNS numbers from the match job for monitoring by DnB (dnb/monitoring/batch)?  It does not seem that the match job automatically registers them    Am interested in what filters you might be using to identify only organizations that have had DUNS numbers assigned in the previous run of the match job to limit the number of organization sent to DnB.

    I can run it manually and add a timestamp range for the Vendor Verification Date to pick up organizations recently matched , but this does not lend itself for having a scheduled job that runs once a day.

    Thanks.



    ------------------------------
    Michael Foxcroft
    Ritchie Bros
    ------------------------------


  • 2.  RE: Register Entities for DNB Monitoring in Batch

    Reltio Employee
    Posted 11 days ago

    I'm pinging the PM on this for more information. More to come



    ------------------------------
    Chris Detzel
    Director of Customer Community and Engagement
    Reltio
    ------------------------------



  • 3.  RE: Register Entities for DNB Monitoring in Batch

    Reltio Employee
    Posted 8 days ago

    Hi Michael

    Thanks for the question on the community.

    D&B connector does support a batch utility through an API where you can schedule the registration of DUNS for monitoring. Here's the documentation link to that API.

    https://docs.reltio.com/en/explore/get-going-with-apis-and-rocs-utilities/reltio-rest-apis/integrate-apis/db-connector-apis/monitoring-apis/registering-or-unregistering-multiple-entities

    You can use a cron expression to run on schedule and in the filter criteria provide the conditions. This API can be used to add DUNS to the list as well as remove DUNS from the registration - appropriate actions need to be set in the API parameter.

    I hope that this help you. Let me know if you have questions.

    Thanks

    Gaurav



    ------------------------------
    Gaurav Gera
    ------------------------------



  • 4.  RE: Register Entities for DNB Monitoring in Batch

    Reltio Partner
    Posted 2 days ago

    Hi Michael,

    Did this answer your question?



    ------------------------------
    Jay Daly
    Dun & Bradstreet
    Chattanooga TN
    ------------------------------



  • 5.  RE: Register Entities for DNB Monitoring in Batch

    Posted 2 days ago

    Not totally.  I was aware of the API but my question was more how to configure the filter in this API to only register DUNS numbers that have been added to our Reltio tenant since the last run of this API.  



    ------------------------------
    Michael Foxcroft
    Ritchie Bros
    ------------------------------



  • 6.  RE: Register Entities for DNB Monitoring in Batch

    Reltio Employee
    Posted 10 hours ago

    Thank you for your question. If I understand correctly, you're looking to automate the process of registering entities with newly added DUNS numbers. This can be accomplished through filter creation. Specifically, you can filter based on the presence of a DUNS number.

    Additionally, I should note that the DnB connector in this case uses an Export service, which in turn relies on a specific Filter system (link to documentation here). After reviewing this documentation, I believe you'll find it easier to configure the filter you're interested in. However, if you encounter any difficulties, feel free to reach out, and we'll be happy to assist you.

    As for timestamps, it is possible to incorporate static time ranges into your filters, but currently, there is no built-in functionality for dynamic date filtering for today's or yesterday's dates.

    You can combine multiple filter criteria using the and keyword for more precise filter configurations. As a result, your JSON filter might look something like this:

    {
      "exportTask": {
        "filter": "(exists(attributes.DUNSNumber) and equals(attributes.VendorVerificationStatus.value, 'Match'))",
        "distributed": true,
        "taskPartsCount": 300
      }
    }
    Overall, we have a great deal of flexibility in how we configure our filters based on the attributes of our entities.


    ------------------------------
    Dmitry Ishmitov
    Software engineer
    Reltio
    Lisbon
    ------------------------------



  • 7.  RE: Register Entities for DNB Monitoring in Batch

    Posted 8 hours ago

    Thanks for the response.  I guess I am really looking for dynamic date filtering.  When we match our organizations with DnB it ends up with a vendor verification status of Enriched.  We have 900K organization entities with this status.  Do you know if it is ok to continuously send. this number of organizations to DnB?     Most will already be registered with them.



    ------------------------------
    Michael Foxcroft
    Ritchie Bros
    ------------------------------