Ideas or feedback

Ideas or feedback for exMon we can use to improve our product.

Merge function

If it would be possible to somehow make the process of reading data from the source systems to exMonDM and then back into the DW more efficient

The current process is to:
1) Create a table in exMonDM
2) Create a data transfer to push the source data table to the exMonDM database
3) Create a merge script to merge the source data table into the table you've created
4) Attach the merge script to the data transfer task

One idea would be to be able to automatically create the merge script from the exMonDM destination table where you would select the source table and select what columns are the key columns and what columns to track changes on. This could be created as an action that could then be executed from the data warehousing tool or this is something that would be executed automatically when the source table is updated in the exMonDM database



  • Stefán Gunnar Jóhannsson
  • Jan 25 2023
  • Attach files