Skip to main content

Our June 2021 exMon DM 3.1 update mainly contains big improvements to already existing features.

Convert database tables to exMonDM tables

Users can now select tables that exist in the exMon DM Database and convert them to exMonDM tables.

Fivetran improvements

In our last version, we introduced the Fivetran data connectors feature. We have now made some improvements for better usability. Tables will now be converted automatically to exMonDM tables and will be located in the Fivetran project folder. 

Required Columns

New property to table columns indicates whether the column must include a value. This property is set for each column in the Table Designer.

If the table does not contain a value in a required column an error icon is displayed indicating that it's missing and a message is shown before saving to ask the user if they want to ignore the errors.

Database User Improvements

Database users can now be given permissions to create stored procedures, functions, views and tables across all schemas to the database user has access.

Table Indexes

System columns can now be added to custom exMonDM indexes.

Open table in the browser

Users with web enabled can now open their tables in the browser from the desktop application. The 'Open in Browser' button is located in the Advanced tab of the Table Editor.

Bugfixes & Minor fixes

Table Editor

  • Error message gets lost when action fails on save in a table
  • Error when importing data from the 'Import data' button in the toolbar and set ignore to all columns
  • Trying to import into a table with no columns needs to notify users that they need to add columns first
  • Unable to refresh open hierarchy after making changes to attribute names

Table Design

  • Import from database action saved to toolbar shows icon name as the action name
  • Renaming table does not rename it in the tab
  • Edit connections in import data when the already existing table is open doesn't work
  • Warn users if they are trying to create two new SQL tasks that have the same name. Make the save button disabled.
  • Changing values for multiple columns simultaneously did not always work

User Access

  • Possible to press next when adding a new user without writing an email

Other

  • Removing system keys from API share
  • Sometimes generating a password for a DB user does not automatically pass password enforcement(missing 2 of 4 requirements)
  • Save in settings doesn't disable save and navigation buttons while saving
  • Telemetry crashed program when user could not connect to application insights
  • An exporting project that contains tables with lookup columns would fail when the lookup table itself was not part of exported project