Assure DQ

Welcome to the Assure DQ community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Translation table able to be updated by control execution?

    Posted 06-24-2025 12:24

    Is it possible to update the values within a translation table by having a control run daily to run a query against a SQL database? 



    ------------------------------
    Jamie Murray
    Health Care Service Corporation, A Mutual Legal Reserve Company
    Chicago IL
    ------------------------------


  • 2.  RE: Translation table able to be updated by control execution?

    Posted 06-25-2025 11:15

    We're using Assure control data tables for a few translations and find it works well.  

    We create a Database layout using InfogixAssureDS as the JNDI name and then build a SQL query against the Control Data Table listed in the storage tab of the Control Entity definitions. Then we set the Translation to use the new Database layout referring to the Assure Control.



    ------------------------------
    Bill Brown
    U.S. Bancorp
    Minneapolis MN
    ------------------------------