Open Forum

Expand all | Collapse all

Data Integrity

  • 1.  Data Integrity

    TOP CONTRIBUTOR
    Posted 22 days ago

    A common topic that comes up within the Caplugs leadership group is data integrity.  Anything from new reports to item setups to order entry can impact this.  We govern select fields using the controls NAV/BC gives us along with custom development (required values, value range checks, workflow, approvals, etc.) but there are always new leaks that spring up as we expand our system and implement add-ons, add new reports and grow the business through acquisitions (and thus inheriting another system's data).

     

    Does anyone utilize tools or systems specific to data integrity and can you share how you address this within your company?



    ------------------------------
    Anthony Darden
    Vice President - IT
    Protective Industries, Inc.
    Buffalo NY
    NAVUG All-Star
    NAVUG CIO Council
    ------------------------------


  • 2.  RE: Data Integrity

    TOP CONTRIBUTOR
    Posted 22 days ago
    We've been looking into MDM (master data management) tools. This is mostly to manage data in one template company and pass to other companies. Not sure if this would help you but might be worth taking a look

    ------------------------------
    Kim Dallefeld
    Kim@Dallefeld.com
    Dallefeld Consulting, LLC
    Member of Dynamics Consulting Group
    Ft. Worth, TX
    2019 NAVUG Board of Advisors
    Past NAVUG Board Chairman
    NAVUG Programming Committee
    ------------------------------



  • 3.  RE: Data Integrity

    GOLD CONTRIBUTOR
    Posted 21 days ago
    Have you explored any field level security solutions?  Expanding your use of item templates may eliminate the need for your users to access sensitive fields because they are already completed by the template.  Security by dimension also comes to mind.  If you have multiple entities something like Binary Stream's Multi-Entity Management provides security at the entity level within the same company.

    ------------------------------
    Jason Nicolaou
    Engagement Manager
    Sikich, LLP
    ------------------------------



  • 4.  RE: Data Integrity

    TOP CONTRIBUTOR
    Posted 21 days ago
    @Jason Nicolaou - we are using Easy Security in our NAV 2018 environment today and are big fans of the field level security they provide.  I like the idea of expanding our use of templates and I'll take a look at that Binary Stream product you mentioned...our biggest Achille's heal is getting data into the system from an acquisition and the apples-to-oranges effect it causes us.​

    ------------------------------
    Anthony Darden
    Vice President - IT
    Protective Industries, Inc.
    Buffalo NY
    NAVUG All-Star
    NAVUG CIO Council
    ------------------------------



  • 5.  RE: Data Integrity

    Posted 8 days ago
    Hi, Tony.

    This is an interesting question.  Certainly one can make fields required.  And one can leverage lists and selections to make data consistent.  But really the values within fields -- the adherence to any business-mandated naming convention -- is challenging to enforce.  We periodically audit values and correct discrepancies as we find them.   We also clean up discrepancies in the cleansing layer of our BI.  But preventing the discrepancies from occurring to begin with is a better approach.

    Alex.

    ------------------------------
    Alex Scheler
    Carma Laboratories, Inc.
    Franklin WI
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role