Product Updates

This week, we’ve published a hotfix release of TimeXtender Orchestration 24.3.0.53 that contains the changes listed below.FixedWhen packages/processes go to an idle state that exceeds their timeout, users will now be able to rerun those packages/processes without clearing the job queue after the configured timeout has passed.

Today, we’ve published a hotfix release of TimeXtender Master Data Management  (v. 24.2.0.24 and 24.3.0.21) that contains the changes listed below.FixedResolved an issue where opening a table that referenced a deleted lookup table caused the application to display an error message.  

Today, we’ve published a hotfix release of TimeXtender Desktop (v. 6898.1) that contains the changes listed below. FixedResolved an issue that occurred when adding conditional lookup fields with joins on fixed values in a Snowflake prepare instance. Optimized data cleansing procedure to improve performance in a Snowflake prepare instance. Fixed an issue with out of memory exception when changing schemas after migrating. Fixed an issue where Jobs would say they were invalid due to unsupported version.

The first major release of 2025 brings new time-saving features for data source connections, an improved REST data source provider, less "simple" Fabric Prepare instance storage, and a whole lot of smaller changes. Check out the full list below! New Import and export data source connectionsYou can now import and export data source connections to use in different accounts, save for later, or share with coworkers. You can of course use import to create new data source connections, but you can also override the data of an existing connection. In case some fields cannot be mapped to the connection when you import, the mismatched fields will be listed so you can decide what to do.Two import/export formats are supported: The connection string ("key=value;key2=value") used by the ODX in TimeXtender 20.10, and a JSON-based connection profile that includes more extensive information. No matter the format, passwords, and other sensitive fields, will always be excluded from the export.  Change data source providerWe added the option to change the provider of a data source connection. While you can change freely between providers, changing from one SQL provider to another is obviously less of a hassle than changing from SQL to a REST provider. If the old and new providers don't have exactly the same fields, you'll be able to review the mismatches and make adjustments before committing the change. Customize code for Prepare instances on Fabric Lakehouse (Public Preview)When you're using Microsoft Fabric Lakehouse as Prepare instance storage, you can now add inline scripts that are executed along with the Fabric Notebooks created by TimeXtender Data Integration. With this, the customize code feature is now also supported for Prepare instances on Fabric. Improved Improved REST data source providerWe've made a ton of improvements to the REST provider to make it more flexible and able to support more data sources. You can now import connection information that follows the OpenAPI/Swagger Specification which can be a real time-saver. The new 'Authentication endpoint' authentication type allows you to get authentication data, e.g. a token, from an endpoint and use that for authentication, e.g. by adding it to the header of all requests. We've also eliminated the requirement to select a table in TimeXtender Data Integration from all endpoints that the endpoint you actually wanted data from depended on. The new 'Endpoint query' dynamic values source lets you create dynamic values that combine data from multiple endpoints with a SQLite query. On top of that, the REST provider now supports data in CSV format in addition to JSON, XML, and plain text. Other changes included the following:New option on endpoints to set a delay before the first request to the endpoint as well as a delay between requests. Global values, i.e. variables that can be set once and used across endpoints. Dynamic values created by pagination are now available outside of pagination. New built-in dynamic values: TX_ExecutionTimestamp, TX_XmlFileName, TX_TableFlatteningFileName. Support for OAuth response with 'accessToken' instead of 'access_token'. Support for a custom header prefix for OAuth token. New option for setting the data format (JSON/CSV/XML/Text) explicitly instead of relying on the automatic selection logic. After converting from JSON to XML, tables with an ID column only are now removed from the metadata result. The endpoint path can now be overridden by a complete URL. Pagination can replace both the URL and the post body at the same time. New option to set empty fields to null. New option to enable debug logging. Prepare instance on Fabric Lakehouse no longer "simple" (Public Preview)When we added support for Microsoft Fabric Lakehouse as Prepare instance storage in our last major release, functionally was limited to what's possible with simple mode enable. With this release, that's no longer the case. We've added support for transformations, conditional lookup fields, supernatural keys, and aggregate tables.However, we still have some work to do since the following features are still not supported: History, custom data, custom views, junk dimensions, related records, table inserts, and hierarchy tables. While incremental load is supported, it is currently necessary to manually define an incremental selection rule on the Prepare instance. Incremental settings from the source are not automatically applied. Remember instance migration settingsYou can now save your settings when migrating an instance between environments, making it easier to reuse them later. Saved settings will automatically apply when you migrate the same instance again, but can be modified as needed before migrating.  Fixed (TDI Portal)Fixed more than a dozen smaller issues and inconsistencies in the look and feel of various tables in the Portal to create a more streamlined and user-friendly experience. Fixed an issue where right-click was disabled in tables even when there was no custom menu defined, preventing users from, e.g., opening an instance in a new tab. Fixed an issue with changing Prepare storage type. Values could visually overlap on the instance overview page. Fixed an issue where uncategorized instances could not be added when creating a new environment. Fixed an issue where timeouts were treated as shorts instead of integers on some instance pages. The Data Source Mappings section would shift when opening a dropdown. On the Instances page, the Uncategorized Instances section would be displayed even when empty. The Edit Environment modal couldn't handle long instance names. When adding a data source connection, sometimes an error message would only pop up after you had been redirected away from the page. Unclear wording in successful update message on data source connections. Removed ":" from data source connection checkboxes with no description. Fixed an issue where customers could not change basic info for their organization. In the activity log, some values related to firewall rules and restoring an instance would not be displayed correctly.  Fixed (TimeXtender Data Integration) Fixed reference to old instance type names in the job log. Fixed issue where editing a snippet-based script action could cause a "Label not found" error Fixed an issue where you could add an execution package with failure handling set to retry steps while having multiple threads enabled and managed execution disabled. Fixed an issue in Snowflake where the deployment of a table would fail if the raw schema was different from the error/warning schema. Fixed a null reference exception when deleting a table referenced in a custom data selection rule across multiple data areas. Fixed an issue where the Metadata Manager did not pick up changes when tables and columns match on an identity other than name. Fixed an issue when execution of a table in Ingest when the storage type is Fabric Lakehouse with schema and the source of the Deliver table is TimeXtender OneLake Finance & Operations Data Source would fail with "name 'PATH' is not defined" and/or "name 'FULL_LOAD' is not defined"

Today, we’ve published a hotfix release of TimeXtender Desktop (v. 200.0.6848.1) that contains the changes listed below. Fixed Fixed an issue where a deadlock could occur for the Ingest Service, when refreshing the authentication and repository connection at the same time. We know this has been a big issue, and would like to thank the partners and customers who helped incrementally test and provide feedback and knowledge so we could solve the issue.  Fixed an issue where starting a windows server in Fast Boot / Hiberboot mode with an Ingest service installed could cause the DNS issue fixed in version 6823.1. This happens as the Fast Boot mode skips the regular windows service startup flow and ignore the ingest service network validation logic. Fixed an issue when transferring data from Ingest to Prepare, where an invalid cast exception would be thrown on a decimal data type. Fixed an issue when executing a Deliver instance when the table is based on a view from a Prepare instance, where the Post Valid Table option is enabled. Fixed issue with a misleading error message when executing a transfer task for PostgreSQL data source, when incremental rules were set up and no new data was present in the source. Fixed an issue where the database cleanup tool would mark the table message functions as objects to drop. Fixed an issue where the system incorrectly attempted to drop a regular SQL table using the syntax for external tables. This led to errors during table deletion operations.

Today, we’ve published a hotfix release of TimeXtender Ingest Service (v. 6823.1) that contains the changes listed below. FixedFixed an issue when importing Metadata in the Ingest when using ADO, OleDB, and CData providers, where it would stop reading meta data if a table without columns was found. Fixed an issue where the Ingest service would cache the DNS host of the authentication and gateway service forever. This caused issues for Ingest services automatically started before a valid internet connection was established where the cached DNS would cause the "The remote name could not be resolved" issue.

Today, we’ve published a hotfix release of TimeXtender Desktop (v. 6822.1) that contains the changes listed below. NewSupport for Fabric SQL Database as Prepare storage. FixedFixed issue with Ingest Incrementally loaded tables that was added to a Prepare instance, which caused errors during deployment and execution. Fixed issue with Database Clean up tool wanting to delete _I tables because of the error above. Fixed issue with wrong syntax when deploying objects in Snowflake. Fixed issue with wrong syntax when deploying objects in SQL Synapse.

We hope you've had time to put the pumpkins away because now it's time for a new major release of TimeXtender (v. 6814.1). The release has a focus on data ingestion with improved synchronization from data source to Ingest instance, new data source providers, and better orchestration and scheduling, but that's not all - check out the list below! NewRedesigned metadata synchronization and table selection: We've completely reimagined how you manage metadata and select tables in the Ingest layer. With these changes, we aim to make it easier to combat schema drifts, e.g. when you change data source providers, and put you in firm control of what goes into your Ingest storage. 'Synchronize Tasks' are now known as 'Metadata Import Tasks' and will no longer do a full synchronization of the data source. Rather, it will import the metadata from the data source and store it in the data storage of the Ingest. The Data Source Explorer has become the Metadata Manager and is now the place for synchronizing data sources - selecting and mapping tables in the data source to tables in the Ingest storage - all based on the metadata imported by the Metadata Import Tasks.  Easier orchestration with synchronization from TDI: Your transfer tasks and execution packages in TimeXtender Data Integration can now be synchronized with TimeXtender Orchestration for more feature-rich orchestration and scheduling than possible with Jobs in TDI. To get started, grab an API key from the TDI portal and use it to create a new "TimeXtender Data Integration" data provider in TimeXtender Orchestration. Redesigned Instances page: We've redecorated the Instances page to make it easier to use. Among the changes are a new list view to complement the card-based view, collapsible cards to help you focus on the environments you're working on, and a consolidated "toolbar" with a Search box and buttons to add instances and manage environments. Prepare instance on Microsoft Fabric Lakehouse: You can now use Fabric Lakehouse as Prepare Instance storage. However, in this first version, the functionality for Prepare instances on Fabric Lakehouse is limited to what's possible with Simple Mode enabled.   New data sources: In our quest to make connecting to data sources easier and more consistent, we're ready with three new TimeXtender-branded data source providers:  Parquet (similar to the existing CSV and Excel providers), OData (similar to the existing REST provider) and Finance & Operations OneLake which supports transferring data to Ingest instances using Azure Data Lake Gen 2 or Fabric storage. If both the Ingest and Prepare instances use Fabric storage, the data will bypass the Ingest storage and be transferred directly into the Prepare storage, leading to better performance and saved storage space. Bring instances back from the dead: Possibly inspired by the recent Halloween spookiness, we've implemented a soft delete feature for instances. You can now restore a deleted instance for up to 30 days after deletion. ImprovementsThe Migrate Instance modal has been restructured into steps, includes a review section, and lets you select the source instance and environment in the modal.  In the top-right corner of the TDI Portal, you'll now find a nine-dot menu for easy navigation to TimeXtender MDM, TimeXtender DQ, and TimeXtender Orchestration. A banner on the Home page will now let you know about upcoming system maintenance. The Upgrade data source page has received a new coat of paint to match the new TDI Portal design. On CSV data sources, you can now define custom null values, such as "N/A" and "-",  in the aptly named "Null Values" field. On SAP Table data sources, we have added a Table name filter that makes it possible to filter out some of the irrelevant tables before you can even see them in TDI. This can make importing metadata from the source much faster and makes it easier to manage the notoriously large amount of tables in SAP. To prevent accidental password leakage, we've applied password protection to more relevant fields in the TimeXtender-branded data source providers. You can now connect to Azure Blob Storage (or ADLS) using principal user credentials. This applies to the TimeXtender-branded CSV, Excel, and Parquet data sources.  We've made the Ingest authentication refresh logic more robust to prevent potential issues. We've changed SQL queries to include a 30-second command timeout, preventing client lockups during cloud database issues, and improved Timextender Data Integration logging for clearer task tracking. When you upgrade TimeXtender Data Integration, you can now see more information about what is being imported from the old version in the first run of the new version. FixedOn the Migrations page in the TDI Portal, cards now accommodate longer instance names. On the Instances page in the TDI Portal, a non-data estate admin user would sometimes get "User not authorized" or "Missing data estate permission" errors. In the TDI Portal, Test Connection would return "successful connection" for non-existing paths in cloud-type locations (AWS, Azure, GCS). In TimeXtender Data Integration, we have improved the visualization of invalid data sources under Ingest instances. They'll now have "(invalid)" postfixed to their name which will be displayed in red. Fixed a "Task was canceled" error when opening TimeXtender Data Integration with over 250 instances and adjusted the HTTP timeout settings to improve loading. Using the integrate existing objects feature in TimeXtender Data Integration would sometimes cause a "duplicate key" error due to unfiltered duplicate keys. Duplicate keys are now properly handled to prevent this error. In TimeXtender Data Integration, we fixed an issue with a radio button that prevented you from switching between the Valid and Raw tables when you created indexes.   In the Filter Rows window in TimeXtender Data Integration, you could click the Preview button even when the data source did not support preview. In TimeXtender Data Integration, we fixed an issue where changes in Edit SQL Snippet Transformation were not being saved. In TimeXtender Data Integration, we have improved the message displayed when an error is thrown on Reports > Errors. In TimeXtender Data Integration, tables with selection rules would fail when dragged from one data area to another on a Prepare instance that uses Snowflake as storage. In TimeXtender Data Integration 6766.1, SAP data sources experienced degraded performance due to the accidental release of a 32-bit version of the TXIntegrationServices component. We updated the stored procedures for executing Prepare instances to sort data by 'DW_ODXBatchNumber' for insertion into the valid table during a full load. If 'DW_ODXBatchNumber' is not available, it will default to sorting by [DW_Id] in ascending order. The execution of execution packages would sometimes fail with the error "terminated unexpectedly". To solve the issue, we made the access token refresh logic more robust.  It now permits refreshes up to 4 hours before expiration, incorporates retries for failed attempts, and includes an automatic refresh when the execution service restarts. The Execution Service would ignore proxy settings when executing packages, which could result in misleading error descriptions for the end-user.  The TimeXtender REST data source provider now handles empty property names, property names that start or end with a colon, and property names with more than one colon.

It’s our pleasure to announce the release 24.3 of TimeXtender Orchestration & Data Quality and TimeXtender Master Data Management, featuring exciting new updates and enhancements.SummaryThis release brings several enhancements to boost usability, flexibility, and user experience across TimeXtender's platforms. Key highlights include improved integration with TDI, new capabilities for optimizing cloud resources, better time zone management, and easier access to previous versions. We have also updated product naming and expanded database permissions for users. These updates demonstrate our commitment to meeting customer needs and delivering a more seamless, intuitive experience. GeneralAccess to Previous VersionsUsers can now easily download executable versions of O&DQ and MDM through the provided links to TimeXtender's SharePoint. These versions don't require installation, allowing for seamless switching between different versions as needed. No special permissions are required to access the links, and further details are available in this support article.Product RenamingWe are excited to announce that we are in the process of renaming our products as part of our ongoing efforts to better align our offerings with the needs of our customers. As part of this transition, you may notice some changes in product names, labels, and documentation across our platform.Please be aware that this renaming is an ongoing process, and while some updates have already been implemented, others will roll out over the coming months. During this time, both old and new product names might appear in certain areas.We appreciate your understanding and patience as we work towards a smoother and more consistent experience. Data Orchestration and Data Quality (DG)TimeXtender Execution OverhaulWith the latest release of TimeXtender Data Integration and TimeXtender Orchestrator and Data Quality(DG), the Orchestrator can now connect directly to Data Integration tasks and execution packages. This update reduces execution overhead, enhances control over execution order and parallelism, and provides a more visually detailed status of each task and execution package.We’ve also added a Sync button in the TimeXtender Data Provider that auto-generates Data Integration tasks and execution packages, along with a default process and process map for each Data Integration environment. This feature reduces repetitive setup across both Data Integration and Orchestrator, allowing you to create tasks in Data Integration and simply Sync in the Orchestrator to generate everything you’ve added.Cloud Optimization packageThe option to create a package to scale, switch on or switch off Azure resources as required before and/or after processes that rely on these resources are run, has been added to TimeXtender Data Orchestration. In order to use this package type an Azure data provider in Data Orchestration with sufficient Azure privileges to update these resources is required. Read more about Cloud Optimization packages in TimeXtender Data Orchestration here. Updated Folder Structure for Improved ClarityAs part of our ongoing efforts to improve usability, we have reorganized the folder structure within our system. To make it clearer which functionalities belong to specific modules, we have created two new parent folders:Orchestration Data QualityAll existing folders have been moved into these parent folders based on their respective functionality. This updated structure will make it easier for users to navigate and find relevant features under the appropriate modules.Please note that while the structure has changed, all existing functionalities remain intact.Supporting Time ZonesWe are excited to announce that users can now change the time zone for their service in Data Orchestration and Data Quality (DG). This update ensures that schedules will run according to the user's selected time zone, making it easier to configure schedules based on their specific location and environment. This feature also accounts for daylight saving time, ensuring that schedules always run at the correct time, without being shifted an hour forward or backward during certain months of the year. Read more about this new feature here.Azure Functions Data ProviderAzure Function packages now use Data Provider for authentication. Additionally, the user interface has been updated to ensure consistency in appearance and functionality with other packages. Master Data Management (DM)Expanded Permissions Options for Database UsersWe have made an update to our database user management capabilities. Previously, users could create a database user and assign various permissions. We are pleased to announce that we have expanded the selection of permissions available.The following permissions have now been added to the selection:View Database State Create Schema References Bug fixes and smaller improvements TurnkeyQuick navigation to rules or datasets directly from exception details. Exception overview now updates URL parameters with filter and search changes, enabling easier linking with specific filters. Gateway Data Providers now supported in Turnkey. "Report Error" button in Turnkey now automatically creates a ticket in the ticketing system. Enhanced email preview functionality. Rule filter preview improvements: hidden columns are now indicated with an icon in the header. Better mapping of rule owners. CC users are now correctly mapped in email notifications. Improved dataset preview functionality. Enhanced error handling for Data Providers creation. Improved overview and management of Data Providers. Browser tab titles now dynamically reflect the current page.Data Orchestration and Quality (DG)Email notifications were empty when a query was moved to another system or duplicated. Updated icons. TimeXtender packages could be created with wrong setup. UI was also updated. Folder could not be deleted. Excel attachment is now only created when configured in Quality & Process configuration. Added error message for Powershell packages. Email notifications were missing from Email Preview. Azure Powershell package failed in on-prem setup. Process could not be deleted. Redis cache logic enhanced to prevent error in compare queries. Moving object groups between folders was not possible. Duplicating a process with execution steps resulted in execution steps not working correctly. Limited TimeXtender version did not have user groups visible. Package parameters extended. Query snippet could not be deleted. Execution of Fabric packages failed on PROD. Limited TimeXtender version showed objects on process maps that are not a part of the light version. UI for Data Providers in Gateway was incorrect.Master Data Management (DM)Flat view in hierarchy was not working as expected. Disabled users were able to login to the portal. Format of number columns for single row editor fixed. Error when a role of a user was changed. Issues when adding new users. Changing a field to a Item list sometimes resulted in an error. Renaming a table using hierarchy resulted in lost data. Added information to user regarding limitation of changing Data type of Item List. Error when adding a new user or new user group. Error when unchecking/checking filter in desktop. How to upgrade?In Master Data Management, users in versions 22.5 and above can complete the upgrade themselves through the Desktop client. See the Guide.Contact help@exmon.com to upgrade from Exmon 22.4 or below. 

Today, we’ve published a hotfix release of TimeXtender Data Integration and TimeXtender Ingest Service (v. 6766.1) that contains the changes listed below. FixedReplaced the lock with a mutex to prevent thread conflicts in the workspace. Fixed a syntax error in the generated Snowflake script caused by an incorrectly placed semicolon in the data cleansing procedure. Fixed an issue where the max degree of delivery instance parallelism reset to 1 after reloading the execution service configuration. Resolved an issue preventing new fields from being added to a DW table with existing mappings. Fixed migration errors between Prepare Instances due to missing extended properties. Updated fiscal week calculation to fix a month comparison issue. Fixed a loading issue with the Custom View Tracing Object when views were split across multiple data warehouses. Updated the instance list order in the Ingest Service Configuration Tool. Fixed an issue in Synchronize with Ingest Instance where fields weren't auto-selected if field names had changed. Fixed a UI issue where the persist view info box was visible by default, and the icon misaligned when resizing the dialog. Resolved an issue where the parameter rename dialog in the custom view script was partially obscured by Windows scaling. Resolved an issue where job statuses failed to update after task completion by implementing retry logic.  We fixed an issue where the dynamic role-level security table was not included in "end-to-end" Dynamic Perspectives Fixed an issue with missing command timeout for Dynamic Security queries against the "Deliver" storage Fixed an issue when adding a private data source (ADO.NET), where an error saying assembly file was not found was thrown.

This release primarily contains important bugfixes, along with some infrastructure changes to how we create and handle instances.NewAdded infrastructure support for handling multiple SQL servers for instances. Once the limit on our existing instance SQL server (sql-instances-prod.database.windows.net) is reached, new instances will be created on a different SQL server (sql-instances-prod-002.database.windows.net). This may require users to add a firewall rule for the new server. It is hosted on the same region as our old server (EU West) and should not require any new IPs to be whitelisted.FixedCloning instances now handles copying passwords and secrets correctly Moving instances to the same environment they're already in no longer creates a backend call Changed data source name limits on the portal to be compliant with our other services Fixed refresh tokens in the portal Fixed issue where the uncategorized environment could be edited Fixed issue where "add user" button disappeared from organization page

Today, we’ve published a hotfix release of TimeXtender (v. 6745.1) that contains the changes listed below. FixedFixed a bug where incorrect schema would be applied to custom views

Today, we’ve published a new release of TimeXtender (v. 6744.1) that contains the changes listed below. NewProduct renaming:TimeXtender desktop is now known as TimeXtender Data Integration (TDI) TimeXtender ODX service is now known as TimeXtender Ingest Service (TIS)ODX is now known as Ingest.MDW is now known as Prepare.SSL is now known as Deliver. String aggregation as an option for aggregation tables. The output will be separated by a comma and will be ordered by the content of the column Added persist view functionality, which will persist a view as a table. Introduced a filter for available data providers to improve data source selection. Added a feature that allows users to clone instances for more efficient management. Added hidden fields support in data source connection forms. In the Execution Service Configuration tool it's now possible to set up how many parallel executions of Deliver instances should be possible at a time. Default is set to 1.ImprovedThe TimeXtender database cleanup tool can now run without the need of a data area to exist. The solution explorer in TDI client will now remember if a node is collapsed when refreshing the solution tree  Changed the error message for opening incompatible instances. Environments page renamed to 'Migrations' page at /migrations and all non-transfer related functionality removed. The Instances page has been merged with the Environments page, now accessible at /instances, featuring drag-and-drop functionality for moving instances between environments. A new design has been implemented for data tables. Improved the loading speed of the organization table.FixedDouble clicking a view field in data lineage would not select the view field node  Shutting down TDI (TimeXtender client) with step in the execution queue would ask you if you wish to exit, but exit would happen if you clicked No instead of Yes Resizing the column width in the TIS (ODX) incremental load dialog was disabled Dragging a table node from the semantic source database browser to the semantic tables node did not work Dragging a field node from the semantic source database browser to a semantic table node did not work The context menu for editing an environment was shown on the default environment in the TDI (TimeXtender client) The buttons for showing schemas on the TIS (ODX) ADO and OLE.DB data source advanced settings were hidden. Null reference error when validating Deliver (SSL) Qlik endpoint of the type Qlik View while using Snowflake as the source Prepare instance (MDW) Wrong label for the table distribution setting for Dedicated SQL Pool Synchronizing the Prepare instance (MDW) with an Ingest instance (ODX) would show tables as missing when the data source had "data on demand" enabled and no execution tasks were added on the data source Searching for tables for the mapping sets in the Prepare instance (MDW) would not find tables where the data source had "data on demand" enabled and no execution tasks were added on the data source Listing constraint suggestions on the Prepare instance (MDW) would not find tables where the data source had "data on demand" enabled and no execution tasks were added on the data source Adding new view fields to a standard view was blocked after selecting a field in the overview pane Some Ingest instance (ODX) execution logs sometimes went missing due to a timing issue in the Ingest instance (ODX) execution logic Potential null reference error when two users concurrently committed a change on an Ingest instance (ODX) data source or Ingest instance (ODX) task  Some Semantic dialogs could only resize horizontally Tabular Security DAX was incorrect when having more than one setup Moving Ingest instance (ODX) data type override rules up and down sometimes caused an index out of bounds exception A circular reference in data lineage with history tables caused the data lineage to run forever.  Label in warning and error reports dialogs shows database instead of data area When adding a private data source (ADO.NET) an error saying assembly file was not found was thrown When right-clicking on a table with a mapping type of the Integration Table, the client sometimes crashed. Updated the layout of the Deliver Instance (SSL) Role Dialog  Fixed an issue where the TIS (ODX service) would get stuck in 'Starting' state if the authentication token could not be renewed. Addressed alignment issues with dropdowns and the search icon in multi select filters. Corrected the incorrect tooltip displayed for the delete instance button. Resolved an issue where the hand cursor appeared on mouse over an instance in the Environment page, but clicking did not trigger any action. Fixed an issue where it was not possible to save a prepare (MDW) instance after previously experiencing an error. Fixed a bug that caused the customer table to not refresh after deleting a customer. Resolve an issue that made it impossible to delete some data source connections because of hidden double spaces in the name. Fixed an issue where important setup properties were accidentally overwritten during updates, and ensured that the connection string is securely encrypted when edited. Fixed an issue to ensure that repository information and related secrets stay properly aligned and consistent. Resolved an issue that caused organization creation to fail due to incorrect data handling. Ensured that comments are now properly added to the activity log when removing a company and removed duplicate comments that appeared when deleting an organization

Hotfix release of TimeXtender Desktop (6718.1) and TimeXtender ODX Server (6718.1) that contains the changes listed below. FixedDesktop21779: Add internet connection check on ODX service and Job Executions startupFixed an issue where the ODX and Execution services would get stuck at the 'Starting' state when there is no internet connection available. It will now retry for 5 minutes and if there is still no internet connection available, then it will shut down the services.21738: Null reference error when adding One-To-Many relations to SSL modelFixed an issue where One-To-Many relations on SSL wasn't created correctly and would cause an error when re-opening the project.21748: Authentication settings changes trigger job execution service restart.Fixed an issue where the execution server would restart when the authentication settings file was modified.

We are excited to announce the latest version of XPilot, packed with significant improvements and new features to enhance your experience. Here are the highlights:5x Faster Responses: With a new and improved Index, XPilot now delivers responses five times faster, ensuring you get the information you need without delay. 10x More Intelligent Responses: Powered by GPT-4o, XPilot's responses are now ten times more intelligent. Additionally, XPilot now has the capability to remember previous interactions, providing more contextually relevant answers. A response not quite hitting the mark? Ask XPilot to clarify or provide a correction. More Knowledgeable: XPilot is now more knowledgeable than ever, incorporating all the latest knowledge base articles and Exmon user guides. And now even YOU! can help make XPilot smarter, as it's also trained on "answered" user community questions.  Improved Usability: The user interface has been completely rebuilt from the ground up, significantly improving usability and making it easier to navigate and find the information you need. Responses now include images and GIFs when needed, making it easier for users to understand complex information. This visual enhancement aims to provide a more intuitive and engaging user experience. Code Generation: XPilot can now accurately generate SQL and DAX code, making it a valuable tool for users who need precise and efficient coding assistance.Try it out for yourself at https://xpilot.timextender.com/ 

 Hotfix release of TimeXtender Desktop (6698.1) that contains the changes listed below.FixedDesktopFixed issue where token expired after 24h and was unable to refresh in the execution engine.

Hotfix release of TimeXtender Desktop (6691.1) that contains the changes listed below. Fixed Desktop 21596: Can't deploy DWH with service principal authentication Fixed an issue where service principal authentication was failing when deploying a SQL data warehouse 21604: SaaS Data Selection Rules - source vs destination fields Fixed issue where the data selection rule pane showed destination field names instead of source field names in table mappings. 21641: Implement 'WITH RECOMPILE' in Direct Read procedures All data movement procedures for moving data between data areas are now created with 'WITH RECOMPILE'. This will be picked up by the differential deployment. 21673: Issue when connecting to MDW SQL Storage when it is a Azure SQL Database This has now been fixed. 21679: Duplicated advanced features on SQL/Azure DWH Fixed and issue where some Advanced DWH features were listed twice 21706: SSL instances upgrade from 1.0.0.0 to 2.0.0.0 are missing extended properties on one table Fixed an issue in the SSL repository which will not copy semantic notifications when using "Copy instance" in the portal. This results in the SSL not being able to open if references to semantic notifications are made in one or more semantic execution packages. 21650: Integrate Existing Objects wizard Fixed an issue which caused the wizard to fail when the MDW used a case-sensitive collation. Fixed an issue where having multiple objects with the same name, but in different schemas would cause errors when running the wizard.  Fixed missing command timeout for the MDW when running queries.

We are excited to bring you the Exmon 24.2 release with new features and improvements. SummaryThis release introduces unified Auth0 login for Exmon and TimeXtender, enhancing user convenience. We've also added custom webhook notifications for seamless data integration and resolved various bugs across Data Quality and Master Data Management.In this article, you will read about:Unified Login across all Products Turnkey & Data Quality (DG) Bug fixes and smaller improvements  Unified Login across all ProductsWe are excited to announce that Exmon and TimeXtender will now use the same authentication methods via Auth0. This means users can utilize their TimeXtender passwords for all new versions of Exmon. This update aims to simplify the login process and enhance user convenience across our products.Highlights:Unified Authentication: Use the same Auth0 credentials for both Exmon and TimeXtender. Enhanced User Experience: Streamline access to multiple products with consistent login credentials. Improved Security: Consistent authentication methods across platforms.Turnkey & Data Quality (DG)Custom Webhook NotificationsWe are excited to introduce a new feature that allows users to create data in external systems through webhooks whenever exceptions occur in our platform. This enhancement aims to provide more flexibility and automation for integrating our system with other tools and services.Key benefits include:Seamless Data Transfer: Automatically send exception data to external applications in real-time. Custom Integrations: Easily connect with various third-party tools and systems that support webhooks. Improved Workflow Automation: Reduce manual intervention by automating responses to exceptions and streamlining processes.For detailed instructions on how to configure Zapier webhooks, please refer to our guide.Instructions on how to configure webhook notifications for Data Quality, please refer to our documentation. For more details on the updated user interface in Turnkey, please visit here. We hope this new feature enhances your experience and look forward to your feedback. Bug fixes and smaller improvements Data Quality and Orchestration (DG)Users are now, not able to select workspaces as Fabric notebook execution item Tab name for user groups now display the correct type of user/user group Emails generated from tests groups/queries/compare queries now include information to the user about maximum row settings in the emails‘ excel attachment When packages are deleted they are now removed from all processes and object groups where they existed Report created through Gateway data provider can now be displayed in the web portal Support links have been updated to support.timextender.com  User interface for creating an Email notification has been slightly updated Error message has been clarified when user selects invalid data provider for TX packages Exception email columns now follow all column settings configured for the testMaster Data Management (DM)User who didn´t exist in Exmon Master Data Management but is a member of AD group in DM could not login to DM WEB and was not created automatically in DM desktop Icons/logos updated in a few places Database user permissions are visible to the user in settings When selecting a DG task for an action in DM, tasks of different types are not confused when they have the same id User can now be successfully added to a newly created manual group Support links have been updated to support.timextender.com  Actions can execute tasks that belong to the new database schema Creating users with emails not existing before is now working Saving AAD groups without Entra Id‘s displays the correct error message Lookup fields using custom display values where data can be empty are now always displayed correctly Lookup dropdown on the web can now be successfully opened with custom value settings Using special Time format, users had issues opening details about users. This has now been fixed. Values are now aligned to the left in dropdown columns Copied text adjusted in How to connect? User interface in user groups has been adjusted Adding a user to a newly created service is now working as expected Recently used on home page has been fixed for individual usersTurnkeyDownload links for Gateway and Desktop client have been fixed Validation has been added for data provider name Revert button for rules that have been published has been fixed Column Settings for dataset and rules have been fixed so switching between tabs will not loose the users setting User can now create rules in the automatically created workspace in a new environment When rules are deleted from Turnkey, they are now also removed from the object explorer in DG Percentage format is now shown in execution preview for rulesHow to upgrade?In Master Data Management, users in versions 22.5 and above can complete the upgrade themselves through the Desktop client. See the Guide.Contact help@exmon.com to upgrade from Exmon 22.4 or below.

Today, we’ve published a new release of TimeXtender Desktop with the following changes: NewRedesigned TimeXtender Portal UI with new layout, colors, dark modeWe've remodeled the Portal and given it a fresh coat of pain to enhance both the look and the user experience. The new design features a collapsible left-side menu for the features related to the data flow, while user account settings, support and admin stuff live in the revamped top menu.In addition to that, the new colors give the Portal an fresh and modern look, and on top of that, we've added a dark mode for those who prefer to turn down the light a bit. The new colors are complimented by new lighter icons and a new more readable font. In our quest for greater consistency across the suite, Exmon Turnkey have been updated to use the same colors, font and icons as the Portal. Shared login for TimeXtender and ExmonYou can now use the same login for TimeXtender and Exmon (web and the desktop DG and DM products). Less hassle, and one less password to remember! However, we haven't centralized company accounts just yet, so if you're not using Exmon already, you'll still have to have an Exmon account created for you. The same applies, of course, if you're using Exmon but not TimeXtender. Keep destination settings when you transfer an instanceYou can now choose if you want to override security, roles and notifications in the destination instance when you transfer an instance in Environments. The first time you transfer between two instances, you must override the destination settings, but on subsequent transfers you decide. Previously, these settings would always be overridden. Map endpoints when you transferring a semantic modelRelated to the improvement listed above, you can now map semantic endpoints when transferring one semantic model instance to another. The endpoints must be of the same type. Previously, the endpoints in the destination instance would have been overridden  Integrate existing data warehouses in TimeXtenderWith the new Integrate existing objects feature, you can easily use data from your old data warehouse even before you've converted it to a TimeXtender data warehouse - or if converting the old data warehouse isn't feasible. Any non-TimeXtender table that happens to be in your data warehouse storage can be integrated into the TimeXtender data warehouse instance. If you're using Xpert BI (acquired by TimeXtender in 2023), you can import additional metadata for the tables in the form of descriptions and tags.  New data source providers for Excel and CSV filesWith the new native data source providers, getting data out of Excel and CSV files just got a lot easier. ImprovedFirewall rules can now be configured on the aptly named Firewall Rules page under Data Estate instead of on the individual instance's details page. This way, it's easier to get an overview of firewall rules across all instances. You no longer need to run the ODX Service Configuration tool on the destination server after transferring an ODX instance under Environments. Instead, you simply need to restart the ODX service. Listing instances in TimeXtender Desktop is now a lot faster. Service requests from user installed software will now include custom headers to ease support cases. When you're using Snowflake as data warehouse storage. aggregate tables, table inserts, and custom table inserts are now supported. When you're using Snowflake as data warehouse storage, deployment is significantly faster. You can now use Windows, Entra Password, Entra Integrated, and Entra Service Principal authentication for ODX SQL storage in addition to the existing SQL Server Authentication. You can now use Entra Service Principal authentication for data warehouse SQL storage connections. Added strict encryption support for ODX and data warehouse SQL storage (SQL Server 2022 and Azure SQL Database). FixedPortalOptimized environment page load times. Optimized customer table load times.DesktopJobs that were not completed did not set their state to 'Failed' after a restart.  Fixed an issue where a Fabric Workspace name containing spaces would make the ODX Fabric Lakehouse unusable. On an ODX, adding an incremental rule with updates and deletes to an empty table resulted in an error. Fixed a performance issue with the CSV semantic endpoint for models that contained tables with lots of rows. Parameters would be removed from custom views created using drag-and-drop between two data areas. In the Performance Recommendations window, the info icons were not properly aligned. In the Selection Rules pane on mapping tables, some fields, including conditional lookup fields and system fields, would be missing for tables from another data area. Fixed and issue where dragging tables from a  ‘TimeXtender Dynamics 365 Business Central - SQL Server’ or ‘TimeXtender Dynamics 365 Finance - SQL Server’ data sources into the ODX’s query areas would result in nothing.

Hotfix release of TimeXtender Desktop (6645.1) that contains the changes listed below.Fixed Desktop 21335: Fixed an issue in the Semantic Layer instance repository which would cause and error when copying the instance in the portal. 21390: Fixed an issue where the Edit MDW Instance dialog was hiding options

We are excited to bring you the Exmon 24.1 release with new features and improvements. SummaryIn this release, we have made several changes including the addition of Fabric Notebook packages in Data Governance (this functionality is in BETA for now, taking advantage of the Preview availability of the Fabric API) and user interface improvements in preparation for custom webhooks for exception notifications. In addition, for both Data Governance and and Data Management we have implemented database schema changes to consolidate and streamline our database operations. In this article, you will read about improvements to:Exmon Data Management Exmon Data Governance  Turnkey & Exmon Data Governance  Bug fixes and smaller improvements  Exmon Data ManagementInfrastructure changesWe have moved both Exmon Data Management and Exmon Data Governance to new database schemas to simplify Exmon integrations with other platforms and allow them to be hosted in the same database.Note that if you are using Exmon system tables for custom scripts, the custom scripts will likely need to be updated. Exmon Data Governance Fabric Package The option to connect to and run Microsoft Fabric Notebook packages from Exmon Data Governance has been added. In order to use this option the user must first create a Fabric Data Provider containing the authentication information for the Fabric item to be run by the package, and then a DG package connecting to and running the Fabric item can be created. Read more about Microsoft Fabric packages in Exmon here. Note that currently this functionality is in BETA, in part because the Fabric API is still in Preview from Microsoft. Turnkey & Exmon Data Governance Email notifications We are working on a new feature related to exception notifications. Until now, we have only offered emails as a means of receiving exception notifications. In addition to emails, we are introducing a new functionality that allows you to choose custom webhooks as an alternative to, or in conjunction with, the regular email notifications. In this release, we have begun preparing for this new functionality. A slightly different user interface has now been implemented for both Exmon Data Governance and Turnkey. For detailed instructions on how to configure email notifications in Exmon Data Governance, please refer to our documentation. For more details on the updated user interface in Turnkey, please visit here. Bug fixes and smaller improvements Data Governance TimeXTender icons were incorrect when packages were added to Object group and other objects  Could not run Azure Synapse package when execution connection was WCF  Could not run query successfully with column names Status and Opened Date  Exception Emails text for excel attachment only visible when lines exceed max row number  Email preview for multiple emails for test groups did not display correct information  Assign to user action in Portal did not work properly with user mapping configured in Exception manager  Azure data factory package did not work correctly when user had access to too many ADF pipelines Data Management Wrong error message when user with no DM access logged into Exmon DM  Wrong number of decimals when default was 3 in Decimal Data type in Columns  DB name is not auto populated when creating an action  Error messages were sometimes not displayed  Column was required option did not work on DM web  Clicking schema names header in database settings changes values to “True” and “False”  Copy table name copies the display name not table name  Hierarchy view had the wrong attributes  Web crashed when new row added and filter used to enter data  Group column is not updated after saving changes  Last login column shows login date of a member of the group  Entra groups in DM are not in alphabetical order Turnkey Columns order in Preview (Execution and Email) were incorrect  Error when creating Dataset with a very long name  Could not create a user with email that was recently deleted  Allow more characters in workspace description   Service email was mandatory in Email settings and should be optional  No warning when only empty saves where entered in workspace name   Run Rule button is enabled when rule is running  Turnkey did not open when company name contained Icelandic letters  Error when removing Workspace name  Buttons were not visible when scrolling down Data Providers  Incorrect data displayed when opening Column Settings in Datasets  Download Gateway and Download Client buttons added to header  Could not run the published rule with multiple filters (Exceptions Criteria)  Sometimes an error was thrown when the process finishes  If a process has not been deployed to prod but the process map has been deployed to prod the process map could not be opened  Execution log showed incorrect information about exceptions 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 help@exmon.com to upgrade from Exmon 22.4 or below.

Hotfix release of TimeXtender Desktop (6626.1) that contains the changes listed below.Fixed Desktop21294: Index out of range when deploying Tabular endpoint when having one or more custom fields with data type Decimal

It's been just one month since our last major release of TimeXtender, but we already have a new release ready for you. This release, however, is all about consolidation. It doesn't contain a lot of new features. Instead, we've been busy improving the existing features and fixing various bugs. ImprovedEasier selection for data source connections: When you set up a new data source connection in the Portal, you can now choose the provider and the version of the provider from separate lists, which makes it much easier to get an overview of the provider list. With the possible exception-to-prove-the-rule, the TimeXtender-branded providers will be the best choice when multiple providers are available for the same data source. For that reason, we've also created a Recommended category in the list for our "homemade" providers.  More complete data lineage with improved UI: Data lineage now traces through aggregate tables, measures, and lookups. We've simplified the UI to give more space to the actual content and a dearly missed feature from the 20.10 branch returns: You can now double-click an object to jump to that object in the main window. To facilitate that, the Data Lineage window is now non-modal, which means that it can be opened and used next to the main window. Links from Desktop to Portal for better integration of the two: In TimeXtender, you sometimes need to go back and forth between the Desktop and the Portal a lot, especially when you set up new data sources. To make the Desktop and the Portal feel more integrated, we've added links in Desktop that open the relevant page in the Portal, e.g. for adding a new data source connecting, managing environments, adding a new instance, and managing semantic model endpoints. REST API table builder: Taking data from a REST API and transforming that into a table structure can be a bit of a hassle unless you really like writing XSLT scripts. Our REST API data source provider now includes a tool that can generate the script for you. You just need to drag-and-drop the structure you'd like. Some data sources that uses a connection string when connecting to a data source (eq. ODBC, OLE DB, TimeXtender SQL, TimeXtender Oracle) now has support for adding additional connection string properties. You can now use the TimeXtender REST data source when you use Data Fabric as your ODX storage.  You can now set the background job timeout in the TimeXtender SAP Table data source. The TimeXtender Oracle data source now supports the ODP.NET provider which has improved performance. It's now possible to change the security filtering direction on semantic relations for Tabular/PowerBI. The character limit on FormatString in a calculation group item on a semantic model has been increased to 1000 characters and is now a multiline textbox. We've improved the Tabular model generated by the Tabular semantic endpoint to have better efficiency and reduce the size of the model. Fixed PortalPassword fields were unmasking incorrectly. Fixed an error that would occur when accepting the license agreement. Fixed an issue where Connection cache was duplicated Data source connections with a null category would fail to render. Error messages for transferring instances have been improved in case of timeout issues. Optimized calls to retrieve instance lists on the Portal frontend. Optimized calls to retrieve data source connections on the Portal frontend. Fixed password field on the Add/Edit Semantic Instance page not showing correct string when unmasked DesktopSSL: Previously decimal fields were being deployed as double. This has been corrected. SSL: Removed the option to include other tables and fields in a Custom Field script, than the table the field is being created on, as it didn't work and would just be empty anyway. MDW: Using an aggregate table on SQL Synapse would fail during execution due to a wrong script. This has been corrected. TimeXtender SAP Table Data Source:  Fixed issue where subtraction settings were not applied on incremental transfers Fixed an issue where deployment would fail when disabling physical tables on Snowflake data warehouse Fixed issue where ODX transfer tasks were blocking other tasks from running concurrently during bulk inserts Desktop proxy settings were not parsed from Execution Service to TimeXtender Fixed issue where open tabs did not refresh on Save and Reload

We have been busy working on exMon 3.9 with most of our focus being on stability and usability improvements.Here are the improvements we made in exMon 3.9:Querying multiple data providersIf you have the same or similar data in multiple databases, for example, a Point of sales database in each of your stores, then creating tests results in lots of duplication.In exMon 3.9 we introduce Data Provider Groups. With Data Provider Groups you can add all your stores into a group and create tests that will validate each data provider in the groupWith this, you can create a single test that monitors that product prices are correct in all your stores.You can read more in our blog post about Data Provider Groups.Process Group ImprovementsexMon 3.8 came with support for more complex process groups with sub-steps and a better way to control what happens on failure in each step.exMon 3.9 improves the editing experience a lot with more intuitive controls for adding steps, moving steps and moving objects between steps. We also added:Drag and drop support between steps Ability to rename steps Execution jobs now use your steps instead of object groups You can select which steps to execute when running the process from the portal You can choose to run the process From the last good known location. The process finds the first object that failed the last time it ran and runs from there.Other ImprovementsexMon PortalBetter error page when a user does not have access to a particular system or feature on the portal Adding and renaming systems does no longer require IIS restartexMon Data GovernanceSchedule groups now display which timezone the server is on if it’s different from the local computer View dependencies for users now look up which Active Directory groups the user belongs to View dependencies for Active Directory groups now look up which users belong in an Active Directory Moving objects to different systems would not work if there were only 2 systems in exMon Warn before saving an illegal email address for usersexMon Execution AgentWhen trying to send emails to illegal email addresses, the email address would not be displayed in the error messageException ManagerexMon now updates changed values for existing exceptions Marking an exception as “Not an exception” on Development would cause it to never open on ProductionexMon InstallerSupport SQL Server instances on a different port than standard

We are excited to release exMon 4.0! This release continues our focus on ease of use but we also introduce preview support to Salesforce and Harvest cloud data providers. Here are our most important changes in exMon 4.0:Actionable and informational exceptionsTests in exMon create two main types of exceptions: actionable and informational.Actionable exceptions can be fixed and the goal should be to fix all actionable exceptions.Examples of actionable exceptions are Discrepancies between prices in the master database and the point of sale system, billing addresses not set for customers and discount rates too high for some products.Informational exceptions are generated from tests monitoring past events.The specific exceptions can not be fixed, but analyzing and monitoring the exceptions can aid in changing behaviour. An example of informational exceptions could be sales with low margins.In this release we have more distinction between those two types of exceptions, making working with those exceptions easier.By default, tests create actionable exceptions but you can configure it to generate informational exceptions with the Severity setting.On the exMon Portal, you can then choose between working with All exceptions, actionable exceptions or informational exceptions.Action propertyIn exMon, the developer of a test and the person working with the exceptions are rarely the same people. Therefore, it is important that each test is well documented and describes both what is being monitored and how to fix the exceptions generated.In this release, we have added an Action property for tests. Developers can then add details on what needs to be done to fix exceptions in that test. These details will be visible on the portal and in all emails generated by the test.Exception email triggersIn previous versions, emails could only be configured to be sent when there were new exceptions.In most cases that is the preferred behaviour but in some cases, you would need to be notified on each execution if there are any open exceptions, or you would need to be notified when exceptions are closed.In this release, we have redesigned how to configure when exception emails are sent, so now you can choose to receive email on new exceptions, whenever there are open exceptions or when exceptions are fixed.Furthermore, you can also choose to include a list of open exceptions and fixed exceptions in the email.For further information, visit Exception emailsCompare Query Value ComparisonWhen comparing two data sources with Compare Queries, we most often want the values we are comparing to be the same, or at least, that the difference is less than a predefined threshold.Imagine a scenario where we are comparing planned costs versus actual costs. It would be an error if actual costs are higher than planned costs, however, it would be fine if the actual costs are lower than the planned costs.In exMon 4.0 we add Value Comparison for Compare Queries. With the value comparison dialog you can choose between error conditions, configuring the test to fail if both data providers are not the same or if a data provider is higher or lower than the other one.You can also define a threshold of how high the difference can be before it’s counted as an error.Data provider parametersWith exMon 3.9 we added Data provider groups, allowing you to create a single query against multiple data providers.The Data Provider groups work great for data providers that are structured exactly the same, however, if there is a slight difference between data providers, it could result in data provider groups not being usable.An example of this can be Navision instances that contain tables that are structured exactly the same, but the table names are prefixed differently. Then we cannot create a single query that works against all Navision providers.To fix this issue, we have added support for data provider parameters. When used, exMon replaces all parameters used in the query before executing it on each provider.This can, for example, be used for table names, schema names, data provider-specific filters, or other data provider-specific constants.You configure parameters in exMon Data Governance under General > Data Provider > Provider > Parameters.Automatic refresh of properties in exMon Data GovernanceIf you have developed in exMon, you have surely added a Data Provider or a user for a test you are developing, and be forced to close and reopen the test before it comes available for use.We finally added automatic refresh of properties in exMon Data Governance so now it “just works”.This should work for all fields in exMon Data Governance; users, Data Providers, systems, email templates and more, and should provide a much better user experience.Salesforce and Harvest data providers – previewIn this release, we add preview support for both Salesforce and Harvest as data providers in Tests.With those data providers, you are able to monitor data quality in your cloud data or to compare it against other data providers you store locally.If you want to test against your Salesforce or Harvest data, please contact us and we can send you some further information about the new providers.Other ImprovementsexMon Data GovernanceObject and Process Groups allow users to select multiple tasks simultaneously. Execution dialog now remembers previously executed settings while the task is open. Execution dialog now warns if you try to execute without saving. Browsing for Active Directory users now works in environments with multiple domains. Production is now the default UAT for schedule groups.exMon PortalBug: Adding or renaming systems no longer force you to restart IIS.FrameworkVariance is now also calculated for key errors. Bug: The schedule “between” issue has been fixed before the schedule would not start in the lower limit of between.