Product Updates

exMon 4.7 delivers further improvements to the diagram editor and scheduler, as well as smaller bug fixes and improvements.Diagram process map improvementsWe continue to develop the process map editor introduced in exMon 4.6. The insert tab now includes helpful actions.Import From Process Map copies the design of another process map. Templates has a couple of common process map templates as a starting point. Recent Images include the last 10 imported images.Process and scheduling execution improvementsSchedule groups have in previous versions always executed all tasks in parallel. This is the desired behaviour in most cases but can result in too heavy a load on the source systems. With exMon 4.7 you can choose to execute a scheduled group in Sequence. The schedule groups will by default execute everything in parallel.Related to this there is also a new global option that can be set in Configuration. General.System.MaximumGlobalParallelThreads allows you to set a maximum number of tasks that can be executed at the same time in exMon. This only affects tasks executed in processes or schedules and queues up all new tasks. If you manually execute a single task it will execute without regard to other executions.    Schedule holidaysWhen scheduling tests and processes you would often send out unwanted emails to employees during holidays. With exMon 4.7 we added the ability to add a list of holidays and assign it to specific schedules. When schedules trigger during holidays, the execution will be ignored and executed according to the schedule after that day. exMon 4.7 includes the Icelandic public holidays but you can add your specific holiday, either in exMon Data Governance or by merging data from existing tables with SQL Server.View previous task versionsRight-clicking an entry in Audit now allows you to view that specific version. A read-only view of the version opens that allows you to compare and copy.Other improvementsExceptions containing numbers written in scientific notation now work correctly. Tasks on the process map no longer flash red/yellow when starting the process. When the task is deleted, it will be removed from the schedule, object and process groups. exMon Data Governance should now upgrade correctly. It's safer to execute multiple instances of the same query at the same time. PowerShell queries no longer require a DataTable called $exMonResults. exMon reads output from the pipeline

exMon 4.8 contains further improvements to version control as well as some new possibilities when developing and execution tests.Version ControlWith the introduction of exMon 4.7, we took our first steps in allowing users to view older versions of tasks. With exMon 4.8 we have improved this feature, making it more user-friendly and visible. With these new improvements you can view both task’s current version on PROD as well as older versions and it is very simple to revert to them.Parameter List For TaskWe’ve improved task parameters to allow for a list of legal values that can be passed to the task. This list can be either a static list made by an exMon developer or a T-SQL function.For more information, visit Send parameters to query and compare queryDataprovider Group can execute a single Data providerWhen you have multiple data providers which are structured the same way, it can simplify things a lot to create a dataprovider group that you query the dataproviders with so when a test using the dataprovider group is executed, it will run its query against all dataproviders contained in the group. With exMon 4.8 we’ve added support to allow users to execute the test without executing all of the dataproviders. There are many situations this can be helpful as this allows the user to fx. execute the test against only dataproviders that were offline during the scheduled execution.  Improved SAP Query SupportexMon has supported SAP for a long time. That being said, creating an SAP test has always been a rather confusing task as the query was written in XML. We’ve improved the GUI for SAP queries quite a bit, making them easier to understand and work with.  Other improvementsThe normal process can now be configured to allow multiple executions of itself Holiday Lists are now ordered correctly in exMon Data Governance Data Providers can now be moved into folders Dimensions now are properly audited Process map editor allows users to use the customized Portal’s colours Email Summary column format improved Added more customization to exception tables in Email Template

In this new release, exMon 4.9 contains a few new features and a lot of smaller improvements and bug fixes.Global ParametersWith exMon 4.9 we’ve added Global Parameters which allow the user to define values that can be used across most tasks in exMon. These values can also be encrypted, ensuring they will not be written or sent in plain text to users or logs.Further details can be found at Global Parameters  Exception Status improvementsexMon 4.9 brings a few changes to how the user can view and change exceptions. With previous versions of exMon, an exception marked as not an exception could not be opened again. While using the not an exception feature should be well thought out, human errors can and do happen so we’ve added a way to reopen those exceptions.Similarly, we’ve also added a way to reopen marked as fixed exceptions so the user will no longer be required to rerun a task to do so. Another change we’ve made is that details of exceptions both show when the exception was opened and reopened as well as when it was closed, along with the information that was already shown.Other improvementsExecution History performance improvements Logging greatly improved More granular settings for the style of the exMon Portal Process Map background editor improvements. For example, it's now easier to change object properties Integrated support for SSIS 2016 processesBug fixesSuccess emails were not sent out when executed from the portal Executing a task on the portal with a DateTime parameter would not always work if the region settings on the server and client were not the same The process queue would not always clean up after itself after failure. This happened when Windows had a process with the same PID running again as the failed exMon instance Fixes with "Execute from Last Known Good State" Deploying objects in exMon Data Governance would in some setups hang the application. Forcing the user to restart exMon Data Governance Auto creation of users did not always work correctly when using CC User Mapping 

exMon 5.0 has two major improvements and several smaller improvements and bug fixes.Exception ImprovementsWith exMon 5.0, exceptions for each test are stored in separate tables. This change allows exMon to execute multiple tests simultaneously considerably faster as well as making working with exceptions faster.Discovery HubIn May, Expectus partnered with TimeXtender which develops Discovery Hub, a product which simplifies modelling a datawarehouse. With this release, we’ve created a new type of exMon package that simplifies executing Discovery Hub execution packages.Package and Data Provider changesPackages and data providers require users to configure each UAT separately. This behaviour is great when development and production environments are completely separated. However, in many or even most instances that is not the case and having to copy the configuration between UATs can be annoying for users as well as increases the possibility of input errors.With exMon 5.0 we’ve added the option to both packages and data providers to use the same configuration for all environments.Other improvementsAdded report template that shows exMon user association to exMon tasks Several places in exMon Data Governance have been changed to allow the developer to select exMon users rather than type in email addresses Removed Overview tab in Portal. The exception tab now directs to the page the Overview tab previously did exMon upgrader now shows other execution connections left to upgradeBug fixesUnder certain conditions executing from the last good state did not work correctly Test with the primary key selected will show a strange error message when the column is deleted from underlying data Losing connection to the exMon database while waiting for a package to finish on the remote server would Deleting process did not work in some exMon versions

In this new release, exMon 5.1 has two major improvements and several smaller improvements and bug fixes.Data Transfer packagesThe main new feature of exMon is the introduction of Data Transfer packages. This feature reduces reliance on third-party components to handle simple data transfers.Data Transfer packages use data providers as the source and destination of the transfer with column mapping between the two data sources.Powershell Query TaskQuery tasks are a niche feature in exMon that allows the developer to create actions after a query has been executed.exMon 5.1 adds the Powershell Query Task to the type of actions that can be used, which allows even greater customization.Process Gantt ChartA new addition to the exMon process emails is a Gantt chart that shows an overview of the process execution, how long each step took to finish, what failed and what did not run.This feature should work well in combination with the process map to show a clear status of the process but will also allow the developer a more in-depth view of things such as execution bottlenecks.Global System ParametersGlobal parameters were released with exMon 4.9 and have been a great addition to the exMon system. With exMon 5.1 we are adding system parameters to the functionality of the global parameters, where the exMon developer can now use these parameters in their task to access any ID used by the exMon execution.Currently, there are four Global system parameters:{$__ExecId} {$__RemoteExecId}{$__SystemId} {$__UserId}.Further details can be found under Global ParametersOther improvementsOn the portal, a task with parameters will now have the run button enabled if a default parameter value is set Tasks that have never been deployed will send a notification email when executed Service email in configuration will now only receive more critical exMon emails, rather than all emails Execution history in exMon Data Governance now allows users to view the execution log Email history now properly renders images contained in emails Process Queue now allows users to select/terminate multiple executions at the same timeBug fixesWhen execution of a package, inside an object group, with the execution connection set was terminated, the object group would sometimes continue exMon properly cleans up execution details after a timeout Exception Overview no longer shows tasks with open exceptions after the exception manager has been disabled In exMon Data Governance, pressing enter with task-focused inside Object Explorer now opens the task

exMon 5.2 focuses on improvements that allow more separation between systems. The version introduces two major changes along with a few smaller improvements and bug fixes.Data Provider / Execution Connection changesCurrently, Data Provider and Execution Connection are always available in all systems. The changes we've made to Data Provider and Execution Connections allow an administrator to configure which system they are available in.Development role changeThe developer role used to have access to all systems in exMon Data Governance. We have changed that so now a developer has only access to systems that are specially granted through the systems tab.Other improvementsProcess Map is now colourblind-friendly Users can create a destination table in the Data Transfer GUI Data Transfer works with PowerShell Links on the process map can be in standard hyperlink format Data Connector can now create a PowerShell Data Provider  Tests now retry creating exceptions on failure Object/Process/Schedule Group highlights undeployed tasksBug fixesCompare Query using PowerShell did not correctly compare non-string values Executing Object Group containing task parameter in exMon Portal did not work correctly When adding Discovery Hub packages to the process/object group they did not disappear from the task list Flush did not correctly work when the task was Discovery Hub and/or Data Transfer package

exMon 5.3 focuses on a new add-on to the exMon environment along with two major feature improvements, minor improvements and bug fixes.Dashboard Add-OnOut of the box, the dashboard add-on gives users the option to analyze exceptions better, whether from the perspective of their users, individual tests, or their overall exception status.This addon also allows those who focus more on process management to see an overview of their exMon executions and options to expand these dashboards into the future, both improvements of these two dashboards as well as options to add custom dashboards.Execution Connection configuration can be configured by the EnvironmentIn exMon 5.3 you can now separate an Execution Connection configuration by the environment. This change primarily benefits Discovery Hub and Data Transfer packages which before would always use the same Execution Connection, whether they were running on Development or Production.This change will also simplify the setup of Command-Line packages that use the same Working Directory and Command-Line.Dimension improvementsWith exMon 5.3 we've released improved exMon dimensions. Dimensions allow the user to view their exceptions from a different perspective. A perspective focused rather on the data that exceptions have in common instead of when the exceptions were created.You can read more about dimensions under How do I use Dimensions?Other improvementsProcess Map with a process attached will now show a Sync with Process button that adds exMon tasks on the process map that are in process but missing on the process map When exMon execution fails to connect to the exMon database it can be configured to retry connecting rather than failBug fixesWhen a schedule is disabled, holiday options are now also correctly disabled Duplicating Data Provider now works correctly Check all in the Deploy window sometimes selected rows are not visible in the UI Execution History cleanup with keep rows option set sometimes did not correctly store execution history

exMon 5.4 has focused on fixing issues brought to our attention by our users, whether they were bugs or improvements that would make exMon better and easier to use.AnalyticsOut of the box, the exMon Analytics add-on gives users the option to analyze exceptions better, whether from the perspective of their users, individual tests, or their overall exception status.This addon also allows those who focus more on process management to see an overview of their exMon executions and options to expand these dashboards into the future, both improvements of these two dashboards as well as options to add custom dashboards.exMon now supports installations on Azure SQL databasesMore and more of our clients have been moving their infrastructure, including exMon, to Microsoft Azure. In the past, installation in Azure was a manual process but with exMon 5.4 we now support SQL Azure out of the box.Unified login experienceUsers of exMon Data Governance and exMon Data Management cloud services used to have to keep track of separate usernames and passwords when logging in.With exMon 5.4 we introduce a unified login, which works especially well when clients have enabled Azure Active Directory.Head over to https://login.exmon.com to try our new unified login experience.Exception overview improvementsException overview worked great for most users but some of our power users could have issues with its behaviour. We have made major changes to how we manage and display the exception overview.Query Snippets/Global Parameter improvementsBoth Global Parameters and Query Snippets are great but some of our users had issues using them when the list became too large. With exMon 5.4 we've added both a filter and multi-select to make using both of these features a more pleasant user experience.Other improvementsThe package now warns when SQLCmd is not installed on the machine exMon Upgrader no longer requires SQLCmd installed on the machineBug fixesGlobal parameters were not used for packages executing PowerShell scripts When a task incorrectly had a different name on DEV and PROD, object groups containing the task could not be opened The configuration window in the toolbar did not correctly display the email authentication information 

The release of exMon 5.5 contains a beta release of Turnkey, a new web interface that makes it easier for business users to create data quality controls for their data. Included in the release are also a few new features and improvements to exMon Data Governance.TurnkeyThe core philosophy behind Turnkey is twofold; to move the data layer further from the business user and simplify the process of making data quality controls.In Turnkey you have Datasets, which are the definition of how to access data and how the data should be configured.A user creates a dataset e.g. SQL query to a database and configures things such as which column is the primary key, the caption and/or format.Since Datasets are simple queries to a data source, a data administrator can be tasked to create the required Datasets without much input from the business user.When a Dataset has been created, the business user can start creating Rules that use the Dataset as their source. Rules can be quickly created as the only definitions required are that of the rule filters.Turnkey is currently available to cloud customers only but will become available to all customers who want to try it when we release the first stable version, expected in Q3 or Q4 of 2021.Other ImprovementsA hierarchy view has been added to Execution History.  Users can now switch between grid view and hierarchy view. This provides users with a better overview of their executions.Powershell has been added as a destination for data transfer.Data Provider packages are a new type of package. They enable users to either run stored procedures or create a custom SQL to run.A feedback button has been added to most exMon products. The exMon team is hoping for a lot of interesting feedback about things that we are doing well and/or things that can be improved.Bug fixesProcess execution showed a wrong error message when no task inside the process was executed Object groups sometimes showed the wrong error message when they were unable to connect to the database Pressing Test Connection with Analysis Service Data Provider open always showed success The user did not by default see exceptions assigned to the user group he was a part of The browse button for Active Directory users did not work Email Summary did not work properly

We are working hard at making exMon Turnkey, our next generation of exMon, ready for public testing. With exMon Turnkey, we focus on enabling business users to configure their own business rules within exMon.Our goal is to release exMon Turnkey for public preview this fall.exMon Data GovernanceImprovements we made in 5.6 for existing exMon customers. Data Connector ImprovementsWhen queries fail to run through the data connector, rather than failing or timing out the data connector will now rather retry executing the query. This prevents temporary timeouts or locks from stopping queries from running.Data Connector is now also able to execute multiple queries simultaneously.Improvements and bug fixesUsers without Administrator/Developer privileges will no longer get an Email Authentication login screen if the company has Windows Authentication enabled Saved Comparative Compare query didn't show variance error for string columns Changing a user in configuration sometimes saved their name rather than their email address

Turnkey is coming along nicely and along with it there are a lot of changes and improvements to underlying aspects of the exMon infrastructure. We are working hard on making it easier for potential customers to register for trials and improving the user experience of all our products.exMon Data GovernanceImprovements we made in 5.7 for existing exMon customers.Data Connector ImprovementsexMon Data Connector has been redesigned, making it both look better and easier to use.It is now also able to execute multiple queries simultaneously.Cloud Customers movedCloud customers have been moved to the Azure ecosystem. This will make exMon considerably faster and makes it easier to move existing customers to the cloud version of exMon.TimeXtender improvementsexMon now displays the error message from TimeXtender packagesImprovements and bug fixesData transfer with PowerShell did not work with same syntax as Tests use Data connector no longer crashes when test returns abnormally large amount of dataTurnkeyThere have been many improvements to Turnkey, most notable is the Customer FilterCustom FilterNow user can create custom filter for rules which fulfill outlier cases where the standard validations are not enough.Improvements and bug fixesUser can pin their favorite workspaces Workspaces are now sorted by name Datasets are now only created on their workspace

Our January 2020 DM 2.5 update includes a lot of improvements and features.Web Edit (Preview)Our Web Editor has had major improvements, It is still in Preview and if you would like to try it out contact us and we will enable Web Edit for your account.Single Row Edit in DM ClientWhen adding one row or doing changes to only one row it can be better to view only one row at a time in a Single Row view.With The Single Row Edit function, any row in a Table can be edited in a Vertical Single Row Edit Mode.Export/Import ProjectMoving Projects and all their contents can migrated between exMon DM Services with the Export/Import project feature. We improved the usage of this feature with the following improvements:Performance Improvements Ability to include data in the export Ability to select which categories are included Various bugfixes.User Windows AuthenticationOnPremise instances can now benefit from single sign-on with their Windows Active Directory account. Item List from ValuesIf you have a Table that has data and you would like to create a pickable ItemList you can now convert the existing column to an ItemList.Bugfixes & Minor ImprovementsExport to Excel left Table Editor in an unclean state Import Large Project timeout Windows Authentication - can change AD Name DM Web Edit possible on calculated fields DM Web Improvements DM Web Lookup/Item List better support Recently used in DM Web Symbols in Object Names Export Project performance improvement and supports hierarchy Run Action UI fixes

Our March 2020 DM 2.6 update includes a lot of improvements and features. Power BI ViewVisualize changes to a table live inside the exMon DM Web interface by embedding your Power BI online dashboard inside the DM interface. Filtering on the dashboard will filter your Table so you don't have to find the row that you need to update.For more information visit Create Power BI Embedded ViewSet a default value for columnsAssign a default value to new rows by defining a default value for a column. The value can be modified by the user or be read-only.Access FilterThe user access filter is now more powerful and allows you to define row-level access with SQL statements. The statement could, for example, select security from a SQL table or with a SQL function.For more detailed information visit User Setting Permissions and User Access FilterDisable User Access and Reset PasswordYou will now be able to better control access to your exMon service by disabling access and resetting the user's password.When a user is disabled they will not able to log into exMon DM, but the user's records and audit history remain unaffected. Resetting a user's password will then require them to request a new password next time they log in. You can utilise these features when you think the password has been compromised or when an employee leaves your organisation. Search Display Value in Web [Beta]Now the search on the web will also search the display value of lookup Columns.Compact view on the Web [Beta]Enjoy a more compact Web view with a small row height and width.Other exMon DM Web Improvements [Beta]We have continuously been improving the web experience and it is the quickest way to enrich data in exMon DM. If you want to try out our exMon DM Web Beta, contact us here Bugfixes & Minor ImprovementsStart page and NavigationBetter experience when opening up exMon DM for the first time Fixes for drag and drop bugs in the navigation view Users could not drag a table/category into an empty category/project Users could not right-click on the project if they don't have access directly to the project - just categories/tables under itProject editingCould not import a project if the name of the ZIP had been changed Could not export/import a project if a table had an emoji in the name Tab order is now correct in the Edit Project Form Edit Projects Form was constantly asking you to save when moving between elements The user could not drag a table/category into empty a category/project Fixed an error when deleting a category with existing tablesSettingsSwitching between User Configuration and Account Settings doesn't warn you that changes will be lost Creating new users On-Premise did not send the Invitation email exMon now prevents the user from changing the email address of user because of security reasons When you rename a table from the navigation bar and the table is open, the name on the tab does not update Audit schema did not exist for all schemas Navigation jumps to the beginning when you open or close the settings window Enter and Escape keyboard shortcuts in the Edit User Details form Creating a user was extremely slow for large installations Error when adding a user to a service, when the user already existed in exMon DMTable DesignRenaming a table through the Table Properties dialog did not update the tab name Import a new table dialog was too small when importing multiple columns Import into a new table now supports customized format for DateTime When importing into a new table, the Preview in the Verify step was sometimes empty Table Properties could not be opened right after creating the table A label was partly hidden in the Calculated column designer The „Duplicate Table“ button was not working correctly in the Advanced tab Fix errors when duplicating a table that had previously been duplicated Added a UI validation to make sure the table and action database names are unique. Before the error came when saving. Saving a table did not work when it had an action with the same name in another schema Moving a task to a different project through „Right-click and Edit“ failed Duplicating a table did not duplicate associated item lists Import a new table from a database did not always work Deleting the last Action for a table resulted in an error UI warning when trying to create a duplicate database name for an Action Duplicating a table with actions, now duplicates and renames the actions Duplicating a table, resulting in a duplicate table name, now appends „ Copy X“ to the name The SQL procedure name for SQL Actions now does not contain the IDs. When creating new Action, the default name was 'New Action'. Now it becomes 'New Action_[NUM]' to make sure there are no duplicates If you have a table containing actions and you change the schema and the new schema has an action with the same name that causes an error, exMon now automatically renames actions so that they are unique Editing custom lookups did not always save the correct settingsTable editingCould not add a new row when the table had a group by column Import from Excel and Database Actions did not work Export Excel had empty cells because the __Display column is null Excel export shows custom display text even though "custom display" is not selected Lookup columns as filters show the key value but do not display the value Run Action form only has a Close button Action with „Refresh after save“ messes up filters Import from database action doesn't ignore columns that have been deleted from the table Misc. smaller fixes in import from a database Import data into a table containing large lookup table times out Custom Import from a database works for the first time, but when you click the generated action afterwards it failed The dateTime column as a filter was not ideal Null exception for lookup column where the referenced table had been deleted in the Single Row Edit Error in Single Row View after saving in Table Designer Single Row View new row has value in the lookup editor Single Row View   missing formatting for number columns Error and error sound when saving with Ctrl+S in Single Row View Action with "Save before execution“ is not saving when the focus is still in the cell that was changed Filter popup did not show lookup display values correctly exMon DM WebFixing shortcuts in grid view and fixing if the region is set to the UK to replace, with the United Kingdom. Ctrl/Shift + click and right-click to open a table in a new tab now works correctly Lookups were not displayed correctly

Our May 2020 DM 2.7 update includes a lot of improvements and features.Single Sign-OnAzure Active Directory allows organizations to enable Single Sign-On for many cloud services. In exMon DM 2.7 we add support for Azure Active Directory enabling your users to sign in using their existing credentials. Furthermore, this allows IT to reset passwords and disable users when employees are no longer active.The Single Sign-On works both for the Windows Client and on the Web. For further information on how Single Sign-on works and how to enable it for your organization visit Single Sign-On Azure AD.Constraint Column InputColumn constraints are restrictions on the data that can be inserted into a given column and can be used for columns that have one of the following Data Types: String, Decimal, Double, Number, and Large Number. In the Table Designer, you will find a tab called 'Size & Format' when editing your Column properties where you can set the columns Min- and Max values as well as create a pattern in which all values of the column must match.  You simply create your pattern in regEx and add it to the pattern text field. If a user inserts a value that conflicts with any of the column constraints he will get a warning and is unable to save the data until that value has been fixed.  For further information on how Column Constraints work visit Column Designer.Parameter Action on WebNow it is possible to run Actions that contain Parameters on the Web. When you press the Action a window will pop up where you can insert the parameter value/s for the Action.  For further information on how you create Action with parameters in the client visit Table Actions.Custom Table IndexCustom Table Index allows the user to create indexes on their tables. A well-constructed index will make your tables faster to use, especially tables used as Lookup Tables.For further information on how you create a Custom Table Index in the client visit Custom Table Index.Bugfixes & Minor fixesStart page and NavigationRenaming an open table would not update the display name in the UI until re-opened PowerBI reports could not be deletedTable DesignSimplified the UI for designing actions  Added the ability to select a schema and Database table name when duplicating a table Creating a new table from an Excel spreadsheet or CSV is now smarter at suggesting data type sizes for columns. Creating a new table from an Excel spreadsheet or CSV and trying to ignore some columns would result in an error. Duplicating a table would not duplicate Item Lists correctly Duplicating a table would not duplicate a Default value correctly when the table contained an Item List Duplicating a table from the navigation tree would not always work Some save actions would not roll back correctly on error. More reliable save Default value improvements for Lookups and Item ListsTable editingImporting data into a very large lookup column is much faster Fixed some edge cases when importing dataexMon DM WebBetter experience when searching and selecting values within lookups Better UI for dates and dropdowns in tables Entering a column with the data type string and size large would resize the focused row Fixed some errors with lookups Fixed an error when saving NULL values Better error messages when a running Action fails

Our August 2020 DM 2.8 update includes a lot of improvements and features.Web file importexMon DM online now supports importing Excel and CSV documents on the web! Simply press the button 'Import data' from the toolbar in the table editor and go through the three simple steps (Upload, Preview, Map Columns). When all steps are finished you do not have to wait for the import to finish, instead, you will receive an email letting you know if your import was successful or not. This can save you time since you can now use the time spent waiting for the import to finish working in other tables in exMon DM.For further information on how web file import works visit Web file Import.Microsoft Teams IntegrationMicrosoft Teams has taken remote work by storm and in many offices, like our own, Microsoft Team is the central hub for collaboration.With exMon DM 2.8 we have optimized the web experience so that you can easily integrate your data within Teams and have relevant data at your fingertips. For more information visit Integration with Microsoft Teams.Contributor Access changesTable designers can now control better who can add or remove rows in specific tables. Under Table Properties, you can choose if Contributors can modify, add, and/or remove rows.For further information on how Contributor Access work visit Create New Table or import the existing Table.Lock/Unlock rows on the webYou can now use the Lock/Unlock feature on the web. When you lock a row the row becomes instantly a read-only. To make it editable again select the row and press Unlock. This feature can be helpful to prevent someone from accidentally modifying a row that should not be modified.For further information on how you lock/unlock rows on the web visit Web - Add, Change or Delete Data.Bugfixes & Minor fixesTable DesignItem list dropdown was not sorted depending on if it is a string or number Actions which do not have a display name should get the database name instead Changing the table name inside the Designer did not update the tab titleTable editingFixed some column constraint errors Publishing data to an external database now respects if the destination table is in a different collation than exMon DM.exMon DM WebBetter experience when using filters on the web Pasting into Lookups with Custom Display values did not work. The dropdown list of services was not sorted alphabetically Memo box missing for string columns with >100 char Fixed some errors with DateTime columns Better start page UI with shortcuts to Documentation 

Our May 2021 exMon DM 3.0 update includes new exciting features that bring new possibilities to the service.FivetranFivetran connectors offer a way to pull data from a variety of external data sources such as Salesforce, Google Analytics, Facebook and many more.Fivetran offers more than 100 data source connectors which you can choose from. In order to set up a data connector for your exMonDM service you need to go to the Settings page and choose the External Data Connectors tab on the left-hand side.In the External Data Connectors tab, you will see a list of all data connectors which have been set up in your exMonDM service and if you want to add a new one you can do so by clicking the Add connector button. Then you can simply select the data connector you want to use from the list. REST APIAdministrators can now share table data with third parties using our REST API.  By clicking the Share button in the Table toolbar -> Advanced you can create a link to share with others.Note: Anyone with the link will be able to see your data. To get an overview of which tables/projects/categories have active links go to Settings > API Access. It is also possible to create and delete links from there by right-clicking the item you want to share.Database UsersAdministrators can now create SQL Server database users from within exMon Data Management. that you can use to integrate with other solutions. You have the option to give different permissions depending on the schema. Simply check all the permissions you want the user to have for each schema in your system. When the user has been created, he can be used to connect to your data, for example with Power BI and DataFactory.Saved views on WebUsers can now select their Saved Views on the Web. The Saved Views preserve the column layout and visibility as well as applied filtering.Product FeedbackLet's talk! We want your help to shape the future of exMon. A user Feedback Button has been added that allows you to give us feedback on how we could improve. If you would like to get involved, simply select the smiley face and type away.After reviewing the feedback we may get back to you requesting additional information or providing you with a solution.Create schemaAdministrators can now create new database-level schemas from within exMon Data Management. Schemas allow you to both organize your data and enforce access controls. This feature is available in all the schema dropdowns for editing/creating a table or project. When creating/editing a Table or a Project simply click the 'create schema...' in the Database Schema dropdown.Then a small popup will appear where you canThen a small popup will appear where you choose a name for your new schema and press 'Create'. New icons for ActionsA common request is "Can we get more icons for actions?" Well, we added thousands of them! The icons are now visible on the desktop version and will be available on the web soon. To change icons for Actions go to Table Designer > Edit Actions in the table toolbar. You must check the Visible in toolbar checkbox to see the action in your table toolbar.Bugfixes & Minor fixesNavigationDeleting categories did not work Deleting web views did not work Changing the name of the table resulted in its hierarchies disappear  Web views disappeared when their category was moved between projects Properties of a table were not updated in the editor if the table was open when they were changed from the navigation Unable to create a new table in service with no projectsUser AccessAdmins of the project were unable to open a table in the project that was created by othersTable EditorColumn constraints prevented certain tables from opening Clicking the Import Data button with unparseable data raised an errorTable DesignImproved layout of Create Table popup Added Back button after selecting a create table mode in Create Table popupexMon DM WebThe custom filter did not work when unchecking a filter item The lookup column dropdown was too small Lookup columns did not have a minimum width Dropdown for cells with long text did not contain a scrollbar

exMon Data GovernanceThis release contains two new types of packages along with a few improvements.Data Factory PackageexMon could already execute Data Factory Pipeline through a PowerShell script. With this release, we have made it far easier to execute Data Factories by adding it as a new type of package. This feature will also support our efforts to make it easier to connect to cloud systems through exMon.To start using Data Factory, Right click Package and selecte New Data Factory Pipeline.PowerShell PackagePowerShell scripts have always been an important part of exMon data processes. This has however always been done through command-line executions. exMon 5.8 adds native support for PowerShell scripts. With native support error and exception handling becoming easier, changes are version controlled and you don't have to rely on placing PS1 on the correct server.To start using the PowerShell integration, right-click Packages and select New PowerShell Script.ImprovementsAdded new SSIS template to command-line packages Improved the look of test emailsTurnkeyTurnkey is now in private beta and we are improving based on user feedback. This time we have added two features along with some bug fixes.Show Execution PreviewWhen designing a new rule it can be important to see the output of the rule, things like new, opened, or closed exceptions as well as emails that will be sent out.Executing rules in the preview has therefore been added to Turnkey.(Image: Execution Preview - Query Result)(Image: Execution Preview - Execution Result)(Image: Execution Email Preview)Workspace Start PageEach workspace now has its own start page that shows the overview of the workspace, recently changed and executed rules, and provides shortcuts to create new datasets and rules.ImprovementsImproving the edit look for Datasets and Rules Fix exception links

Our June 2021 exMon DM 3.1 update mainly contains big improvements to already existing features.Convert database tables to exMonDM tablesUsers can now select tables that exist in the exMon DM Database and convert them to exMonDM tables.Fivetran improvementsIn 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 ColumnsNew 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 ImprovementsDatabase users can now be given permissions to create stored procedures, functions, views and tables across all schemas to the database user has access.Table IndexesSystem columns can now be added to custom exMonDM indexes.Open table in the browserUsers 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 fixesTable EditorError 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 namesTable DesignImport 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 workUser AccessPossible to press next when adding a new user without writing an emailOtherRemoving 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

In exMon 5.9 we made improvements both in exMon Data Governance and in our next-gen version, Turnkey.exMon Online supports on-premise process managementexMon Online, the SaaS version of exMon where we offer exMon in the cloud, now supports executing processes On-Premise. That means we can orchestrate hybrid data processes where parts of the tasks are On-Premise and parts are in the cloud while visualizing the processes on a live map.This can be really helpful when migrating your data pipeline to the cloud.Multiple service support in exMon OnlineexMon 5.9 now supports quickly switching between services. This can be really helpful for people with more than one exMon Online instance.ImprovementsTimeXtender installation path can now be changed from the default path. Packages that ran through the Command Service now show up correctly in the Execution History TreeTurnkeyOur next generation of exMon, codenamed Turnkey, is now in private beta and we are constantly improving based on user feedback.Exception OverviewImprovementsUsers can now stop the scheduled execution of datasets Rule filter no longer shows two scrollbars User no longer enters authentication loop when he is lacking access to customer Rules that have been deleted are no longer shown in the recently executed list

Our November 2021 exMon DM 3.2 includes two new types of Actions and improved stability of the web.exMon DG integration actionWe have introduced a new feature that allows you to run actions in exMon DG directly from the exMon DM action panel. So whenever you want to run exMon DG tasks based on your exMon DM data you can do so - by simply adding a new action, choosing your desired task and configuring it to your liking.Read more about exMonDG Integration ActionPowershell ActionThe other new type of action is a Powershell action. You can now create an action that executes a PowerShell command. Within the PowerShell action, table data can be accessed and used.Read more about Powershell ActionBugfixes & Minor fixesTable EditorThe Clear filter doesn't clear the search Values in lookup columns are updated on save when a row is lockedOtherBetter error message when the user can't connect to the database The application looks weird on some laptop screens Improved stability of web Delete category sometimes failed 

We are excited to bring you the exMon 22.3 release with many new features and improvements. Recently, we have been integrating exMon Data Governance and Data Management to ensure they work seamlessly together. With this release, we are taking the next step by synchronising releases and having a common versioning scheme. Therefore we made the jump from exMon DG 5.9 and DM 3.2 to a version that uses the current year.Our goal is to release 4 major versions a year with smaller improvements in between.SummaryThis release brings an update to the data connector - for future references data gateway - this will now allow you to connect to on-premise data and data pipelines from the cloud. Everybody hates too many emails - so now we have added a summary function for email notifications to make it easier to get an overview, get fewer emails and reach inbox zero.Amongst some of the new features we have of course fixed some bugs.exMon Data GovernanceexMon Gateway and Process ManagementexMon Data Connector has been renamed to exMon Gateway for better clarification. exMon Gateway can be set up on any computer within an internal network, allowing cloud customers to connect to on-premise data and data pipelines.exMon Gateway now supports running packages on-premise. This means that our cloud customers can now seamlessly control and monitor on-premise TimeXtender, Jet Analytics, SSIS and custom PowerShell, Python etc. jobs using the cloud version of exMon.A common use scenario could be a customer using on-premise SSIS packages needing to run in parallel with TimeXtender execution packages. When they are finished, exMon is used to ensure the data is correct and finally update the PowerBI reports.Email Summary ImprovementsEmail Summary is a great way to send a weekly digest of the progress for specific data quality controls. With exMon 22.3, we are also improving email summaries sent to query owners. One significant improvement allows you to turn off email for specific data quality controls and instead send out a summary.exMon Data ManagementOpen exMon DM Application from the webIn each release, we have been improving the experience in using the overall data entry user experience in the exMon DM web portal.In exMon 22.3, we have added a new toolbar button, Open exMon DM App. This button allows the user to open the current table in the Windows client version of exMon DM. This allows the user to quickly jump into the Table Designer to make changes to the design.Improvements on the webFurther exMon DM web client improvements include better functionality when scrolling and filtering through large tables and filtering. The filter panel is now located next to the data instead of on top of it so all columns are visible. Upgrade Later between Minor VersionsOur aim is to keep all clients up-to-date on new features and improved stability. Therefore, we frequently release new versions of exMon. When we publish new versions, users are given the choice to upgrade their Desktop Client immediately or later on.exMon TurnkeyOur next generation of exMon, codenamed Turnkey, continues to be in private beta. It is continuously being improved based on user feedback.Process MapsTo get a better overview of the processes running in the workspace, we have added a process map that allows you to monitor a variety of processes.(Image: Process map)(Image: Failed process in the process map)Adding usersWe’ve added the beginnings of user management into turnkey, starting with creating a new user.Data providers addedWe’ve added a data provider page to turnkey to add and/or manage data providers.(Image: Data providers page)(Image: Data provider creation)Bugfixes & Minor fixesThe execution preview has been improved The preview dataset no longer shows two scrollbars Improved error messages in execution preview Compare queries now work in TurnkeyWe are slowly adding new beta testers to Turnkey and we are excited to bring this to more users in the coming months.Bug fixes and smaller improvementsData GovernanceAzure Function as a new package type Upgraded all code to .NET 6, improving speed and size exMon cloud now uses SendGrid for emails, improving reliability Null exception is thrown when the task is deleted Data connector should not need to be upgraded to work for newer versions of DG TimeXtender packages throw a wrong error message Users cannot change portal colours under Tools -> Configuration Description and Action for Email Template do not work Create data provider - UI is disabled after selecting PowerShell as datasource type Fix error where test execution fails because too many tests are running through the command service Better error message when the user has not executed test in query window before previewing/executing it fully Command service is now 64-bit by default Disabled tasks throw an exception Dashboards in old DG don't work CommandService is not included in the on-premise installer Upgrading exMonDG on-premise does not work correctly for the CMD service Recalculate hashes sometimes fails Switching to Dimension overview does not work  After deleting the system in old DG, tasks that were on the system can still be executed When logging in on the DataFactory package that has values on the initial load it throws an errorData ManagementSome legacy tables did not work in the web application Upgraded all code to .NET 6, improving speed and size Users could not change the values of Item List in Table Designer Making hidden columns visible didn't work in the web application Users can now copy the full database name of a table from the Table Properties window High-DPI and layout problems in the Desktop client were fixed Column caption in tables automatically added spaces before capital letters When string columns were marked as Summary the table showed now rows More descriptive error message when users delete a column being used by an ActionHow to upgrade?Contact support@exmon.com to upgrade

We are excited to bring you the exMon 22.5 release with many new features and improvements.SummaryThis release brings Single Sign-On (SSO) Login for all exMon products. This allows you to easily log into various exMon products without having to remember multiple different passwords. We have also added new icons to exMon Process Maps; including commonly used company logos and Azure icons.As well as adding new features, we have of course also fixed some bugs.exMon Data GovernanceSSO LoginexMon Data Governance now supports Single Sign-On using Azure Active Directory (AAD). This makes it easier for users to use login credentials, on their local machine, to log into exMon services. Furthermore, this ensures that users who are no longer enabled on your network immediately lose access to exMon. With this release, all of exMon now supports Single Sign-On.For more information on how to enable Single Sign-On visit Single Sign-On Azure AD.New Icons in Process MapsUsers can now choose predefined icons both from a collection of 450 Azure icons, and 19 company logos to insert into their process map backgrounds. exMon Data ManagementImport text file with fixed widthUsers can now import text files with fixed-width columns into existing tables. Read more about this here.Saved views also save single row editUsers can now save a view with a single-row edit view. A single-row edit will appear in the same place as it was saved when selecting a view with a single-row edit view.  exMon TurnkeyOur next generation of exMon, codenamed Turnkey, continues to be in private beta. It is continuously being improved based on user feedback.Activity for issue detailUsers can now access a new section in the issue details which is the Issue Activity. The section lists the history of actions on the issue details, along with buttons for changing the status of the issue.SettingsUsers can now configure their exMon Data Governance service using the settings within Turnkey. The settings allow users to change general settings, email settings, test settings and advanced settings. In order to get to the settings page – you can find a cog icon in the top navigation bar. DM Data ProviderUsers can now create data providers specifically designed to get data from an active exMon Data Management service. This feature allows users to more easily set up data providers, without providing all the nitty-gritty details when setting up a regular database connection string.Create a support ticket when an error occurs in the systemUsers can now report errors that occur in exMon DG Desktop and Turnkey. Each time users encounter an error, they will be given an option to report the error – which will result in a support ticket being created. This will hasten the process of solving the issue for the user that is experiencing these errors. Autosave for datasetsUsers no longer need to worry about saving their datasets when working on them, because they are automatically saved for them. The dataset is saved as a draft, so it will not interfere with the published version of the dataset until it has been published again. Publishing a dataset is still a manual task – because it may have more impact on rules which depend on the dataset. Bug fixes and smaller improvementsData GovernanceUser groups could not be saved Users could not assign exceptions to different user Users with administrator privileges could not log in as a different user User set as Process Administrator could not run tasks on process map Recent Images in Process Map were empty Query Email now shows only a description Exception Email Preview shows Action twice Web did not show PowerShell packages on process maps Running Command Line Package returned "Specified cast is not valid" error Package parameters were not usable by all package types Data Transfer UX improvements Data Provider with system selected didn't show Execution connection with the system all selected TimeXtender data provider UX improvements in Gateway A process that finished successfully eventually sent a timeout email when running in the cloudData ManagementThe import data button did not work in the web application The user experience for Import from the database was improved Tables were not shown when searching for projects in the navigation in the web application The refresh button in the Import Data form didn't work Locking and unlocking rows did not work in the web application Clear filters didn't work correctly in the web application Import in the web application did not support text files Deleting a column that was being used by an index threw an error instead of informing the user of it. Column names in indexes form were empty Users could not edit connections when editing and Import from database action Import action displayed the wrong name in the toolbar Filters were reset when the filter panel was collapsed Users could not add a new project when right-clicking an empty space in the navigationTurnkeyThe workspace key URL was cut off when the screen was too small Setting column as the primary key did not work User status doesn't update in the UI after enabling/disabling a userHow to upgrade?Contact support@exmon.com to upgrade 

We are excited to bring you the exMon 22.6 release with new features and improvements. Summary This release brings an improved PowerShell experience for cloud users in exMon Data Governance as well as a change in behaviour for how items are set to run through execution connection. In exMon Data Management we have been working on feature parity in desktop and web applications.In this release, we introduce the first preview of Hierarchies on the web and the possibility to import fixed values when importing into a table in the web application. We have also added a feature for administrators to give their users access to specific columns.exMon Data Management Hierarchies on the web (Preview) The first preview of hierarchies in the web application is now available. Creating hierarchies is still only possible in the desktop client. However viewing, editing, and managing hierarchies is now possible on the web client.  Read more about the web hierarchies preview here.User permissions for columnsAdministrators can now grant users Viewer or Contributor privileges to specific columns, giving them better control over who can view and edit data. Read more about this here. Import fixed value in web application Previously users could only import fixed values in the Desktop client, but we have now added the possibility to do so through the web application.  exMon Data Governance Running PowerShell in Cloud Cloud users can now run PowerShell scripts in packages and queries without using an execution connection. The script can only include commands that the exMon team has approved. Read more about PowerShell in the cloud here.Execution connection queue Execution connections are used to execute tasks on different servers than the main exMon DG server. With this change exMon no longer requires direct access to the server that should run the task but instead the execution connection polls exMon DG for tasks to execute. This change prevents issues such as execution connection overload and firewall problems. Bug fixes and smaller improvements Data Governance ETA for the process map did not work   Process timed out after it had finished executing   TimeXtender did not allow for custom paths  Links to support pages were updated   Email summary was by default set to true for compare queries   Create table did not work in Data Transfer when the source was set to PowerShell   Passwords containing hashtags did not work in the DG desktop client   Package parameters are now usable by all package types Data Management Create table from imported .csv files did not work   Link to support article “Unable to connect to database” was wrong   Logo in trial popup was tiny An error message after changing privileges for database users    Weird button in the settings form    Fivetran connector with space in schema did not work    Actions set to run automatically after saving did not run after importing in the web client  Saving changes in the execution tab in Actions did not work  Better error message when converting column datatype fails  Changing Import from Database action did not work Turnkey We’ve been working hard on making Turnkey production ready and continue to improve the user experience in many areas. For example, user management, auto-saving, and rule configuration. Furthermore, we have made small fixes where necessary and continue to add new features. The goal is to bring in more beta testers in January. If you are interested, please contact us at support@exmon.com.How to upgrade? In Exmon Data Management, users in versions 22.5 and above can complete the upgrade themselves through the Desktop client. See the Guide.Contact support@exmon.com to upgrade

We are excited to bring you the Exmon 23.1 release with new features and improvements. Summary We are excited to bring you the first version of 2023. In this release, we bring improved hierarchies with added features in the DM web application. In Exmon DG, users can now select default email templates globally, per system, and, per query.Exmon Data Management Hierarchies in web We have continued to work on the hierarchies in the web application. New features that are included in this second version of the preview are: adding children to nodes, unassigning nodes, and improving the experience when moving nodes. Additionally, we have made some smaller improvements and bug fixes. Read more about the web hierarchies this article.Execution queue change for DM’s DG action The Execution Queue has been added to on premise DG actions. With this change on premise Exmon users no longer require direct access to the server that should run the task but instead the execution connection polls Exmon DG for tasks to execute. This change prevents issues such as execution connection overload and firewall problems. Read more about DG actions here.Exmon Data Governance Set email template as default template The ability to set an email template as default for the entire environment or per system has been added to DG. At the report level, if no template is specifically chosen for the report the system level default will be used. If no system level default is set the global default will be used instead. At the system and report level, the current default will be indicated in the dropdown list of templates. Switch from DG portal to other products If your account is associated with multiple Exmon services. You can now switch between them from the DG portal by clicking the service name in the top right corner. Bug fixes and smaller improvements Data Governance Command line packages could not be opened from Execution History Status page on DG portal cloud could not be opened  Error when selecting Data Provider in Source in Data transfer package  Saved Comparative did not always work correctly  Compare queries using DateTime column as value did not work  TX packages ended unsuccessfully when TX had multiple projects DM Data provider does not show up in Data provider command packages  UI for Data Provider type Data Management is incorrect  Incorrect data was shown in Available Data Providers column when creating Data Provider Group  Data Providers were sometimes visible in incorrect Systems  Data Provider Groups are displayed twice in the navigation Sometimes queries could not be opened  Switching from PROD to Development did not work in the web client for cloud users  Some users could not create new queries  Some tasks failed when being run in a Schedule  Cache did not refresh when a user created a new system It was not possible to save Power BI Refresh package without a subscription  Power BI Refresh package did not work correctly Data Management Desktop:  Import into double column did not work  Run Task button disabled when DG Action was opened in the Table Designer  Web application:  Could not open hierarchies with decimal columns  Default values did not work when adding a row to a table  Users without table administrator privileges were not able to change column order in hierarchies  Previously assigned nodes were shown at the top of the Hierarchy instead of in the Unassigned section in hierarchies  Clicking the Exmon logo to go to the start page in hierarchies did not work  The color of read-only columns in tables was wrong  When a child node was added in a hierarchy, the parent node was collapsed, and it looked like the child node had not been added  It was not possible to search for hierarchies in the navigation  The UI was stuck loading after user clicked “continue without saving” when importing into a table in the web application  Running DG Action did not always work  Turnkey In this version of Turnkey, we have emphasized improving the user interface and user experience.  If you are interested in becoming a beta tester for Turnkey, please contact us at support@exmon.com. New UI for Dataset Column SettingsNew UI for Rule Column SettingsHow to upgrade? In Exmon Data Management, users in versions 22.5 and above can complete the upgrade themselves through the Desktop client. See the Guide.Contact support@exmon.com to upgrade

We are excited to bring you the Exmon 23.2 release with new features and improvements. Summary In this release, we have been working on improved integration with Azure and have added Azure Connection as a data provider and Azure Synapse as a package type. We have also continued working on Hierarchies in the web for Exmon Data Management and have added the Delete nodes feature along with other smaller fixes and improvements. Rebranding In both Exmon Data Governance and Exmon Data Management we have updated our logos and colors. You can now see the new logo when you use our products. Exmon Data Governance Azure Connection as a Data Provider We have added an Azure connection as a data provider. Currently, only Azure Synapse packages are using this type of data provider but in the future, it will be connected to other items using Azure connection. Azure Synapse Package added to Exmon Data Governance The option to connect to and run Azure Synapse packages from Exmon Data Governance has been added. In order to use this option the user must first create a Data Provider for Synapse containing the authentication information for the relevant Azure subscription. Once this is done, a DG package connecting to and running a specific pipeline from an Azure Synapse package can be created. Read more about Azure Synapse packages in Exmon here.TimeXtender ODX Package type (BETA) We have added a new Data Provider Type, TimeXtender SAAS, and a new package type that allows you to connect to TimeXtender ODX and execute jobs.  This is a part of our TimeXtender integration improvements to make TimeXtender and Exmon work better together.Exmon Data Management Hierarchies in web We continue working to improve hierarchies in the Exmon web application. We have implemented the Delete branches feature and made some smaller improvements and bug fixes. Read more about the web hierarchies here.Bug fixes and smaller improvements Data Governance Could not create Data Transfer Package with a PowerShell data provider through an execution connection  Users were unable to search for a Data Provider Datasource Type  When a package was run through gateway, it did not send an email to the user  Not all Data Providers were shown when a Data Provider Group was created  A newly created Data Management Data Provider was shown as empty when opened again  User could not run the Data Provider Command package through Gateway  Reports in object groups were not displayed in Process Maps  Failure emails from executions through Gateway did not include error text  The Run button in a Process Map in the Portal did not work properly  Process maps were not ordered in alphabetical order  The User got an error dialog when they opened Test Details in the Portal  Test and Production environment did not work for Test Connection in Gateway Gateway did not use package timeout when it was specifically set  PowerShell command with Select-Object could not be run Data Provider Package did not work through Gateway on PROD  No logging while waiting for a Gateway package to finish  Exception is thrown when the user double clicks background in a Process Map  SQL timeout for Dimensions was too short Data Management ID column was called exTables Row Id instead of Exmon Row Id in Lookup Column Options  Adding a comma to Default Value for Double column was not possible  Create a table with Import from database multiplied decimal and double columns  Help in importing a text file with Fixed Width navigated the user to an error page  The next button was disabled after changing Delimiter from Fixed Width to something else  Users could not move data nodes from a Hierarchy to Unassigned in the web application  Moving root to its branch is possible in a Hierarchy in the web application  Importing a DateTime value with a specific format did not work properly  Lookup to DateTime column did not show the value with the correct format  Read-only columns were not visible to use as a Unique Key column when importing  When user created a Hierarchy with Max Height less than 6 an error was thrown  Deleting a table with a hierarchy did not delete the hierarchy tables and views in the database  Executing DG action did not work  Text overlap between columns in an open table in web application  Client became unresponsive when user tried to remove a Thousand Separator for Large Number column  If an Audit Schema did not exist and the user tried saving a table with Full Audit History On, they got an error and the toolbar stayed disabled. Turnkey We have been working on updating the design and user interface for Turnkey in this release using the new colors for Exmon. How to upgrade? In Exmon Data Management, users in versions 22.5 and above can complete the upgrade themselves through the Desktop client. See the Guide.Contact support@exmon.com to upgrade