Assure DQ

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

    Original Message