Reltio Connect

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

    Posted 09-14-2023 19:41

    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 09-16-2023 07:00

    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 09-20-2023 01:51

    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 09-25-2023 10:49

    Hi Michael,

    Did this answer your question?



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



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

    Posted 09-25-2023 14:19

    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 09-27-2023 17:39

    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 09-27-2023 19:57

    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
    ------------------------------



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

    Reltio Employee
    Posted 09-29-2023 11:54

    Hello Michael

    From a technical standpoint, our Reltio DnB connector is capable of handling high volumes of data without any issues. However, it's important to note that the receiving entity in this scenario is Dun & Bradstreet (DnB). Therefore, I would highly recommend that you refer to their specific guidelines for data submission.

    According to DNB's best practices, here are some key points to consider:

    • For lists of 100,000 or fewer, multiple requests per day can be submitted, but should be limited to 2 or 3; requests will be rejected if the registration is locked. If a registration is locked, no API requests for it will be accepted until the initial requests have been processed.
    • For larger lists, please coordinate with your Dun & Bradstreet representative to schedule a seed file delivery.

    Here is the link to their documentation

    Given these guidelines, I find it hard to provide a definitive answer to your question as it falls outside my area of expertise. However, I hope this information is helpful and points you in the right direction for further inquiries.

    If you have more questions or need further clarification, feel free to reach out.



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



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

    Reltio Partner
    Posted 09-29-2023 15:48

    @Gaurav Gera - @John Caiafa - If I'm reading the filtering documentation correctly the would use gte if there is a timestamp assoicated with adding the DUNS Number to the Master Record.  Is the issue here that this timestamp is located in another area (like a log) that can't be used in the filter process for Creating a list of DUNS Numbers to be added to Monitoring?

    Would an option be to create a process to store the result of the filter today, (list of DUNS) and compare the new list to the prior list to identify new DUNS numbers and use that as input to the D&B Monitoring registration process?



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



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

    Reltio Partner
    Posted 10-11-2023 17:19

    Hi Michael,

    Has someone from Reltio Prof Svcs been in contact?  What I had heard is that this can be done through the creation of a script and Reltio PS was going to reach out to you on getting this created for your use.



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