Product Updates

Today, we released a hotfix of TimeXtender Data Quality & Orchestration (v. 25.2.0.55).FixedAuth0 users could not log in builds 25.2.0.53 and 25.2.0.54 In some cases, the ‘Open Portal as user’ button would try to direct users to turnkey instead of the old portal. Exception links used ‘.exmon.com’ instead of ‘.odq.timextender.com’ If DataTransfer was using execution connection that had been deleted, the user could not open the DataTransfer package to fix it.

Today, we’ve released an updated data source provider for Excel. See the changes below.ExcelVersion: 23.19.2.0 (TDI) / 1.8.0 (20.10 BU) / 16.4.20.0 (20.10 ODX)Fixed issue where culture and decimal separator could not be used together. Fixed issue where "Date formats" would not apply when loading data. Fixed issue with nvarchar length for the ‘_ResourceURI’ column not being long enough. Updated core Excel library (Sylvan) to include a bug fix related to reading numbers with culture.

We’ve published three minor releases of TimeXtender Data Integration as follow-ups to the last major release. To give you a better overview of the changes included if you upgrade today, we’ve listed them all below. We recommend that you upgrade if you’re affected by any of the issues that have been fixed.7158.122 Oct 2025Fixed an issue where the direct read stored procedure would be wrong when the source mapping is a view.7157.121 Oct 2025On Fabric Lakehouse Prepare instance storage, the execution timeout per cell was fixed at 600 seconds which was too short in some cases. You can now configure the cell execution timeout by changing the command timeout for the storage in the Portal. Fixed a long-standing issue present since the initial release, where records with negative DW_Id values (e.g., -999, -998) were not transferred correctly between tables. This fix ensures all valid rows, including those with negative identifiers, are now properly processed during data warehouse transfers. 7150.115 Oct 2025Fixed an issue where data of the Sql Decimal type containing null values would fail for transfers to the Ingest Storage when using Parquet files as the output.  Fixed an issue where Selection Rules didn't work as expected on a Prepare Lakehouse. Fixed an issue where re-deploying measures and hierarchies in Qlik would time out. Fixed an issue where deploying a Tabular model to Azure Analysis Services would fail with a message saying a dll was missing. Fixed an issue where a sub query was used to get primary keys for incremental load when sub query is disabled for query tables. Fix primary key upload during incremental load with "handle deletes" enabled for data lake.

Today, we’ve released updated data source providers. See the changes below.CSVVersion: 23.18.5.0 (TDI) / 1.7.4 (20.10 BU) / 16.4.20.0 (20.10 ODX)Fixed issue where decimal columns were detected as int, then failing during data load stage. Fixed issue when overriding data type to float failed if there were null values present. Fixed issue determining correct precision for decimal data types.Oracle / Oracle ADFVersion: 23.4.4.0 (TDI) / 1.2.0 (20.10 BU) / 16.4.4.0 (20.10 ODX)Version: 17.6.1.0 (TDI ADF) / 10.4.6.0 (20.10 ODX ADF)Improved the statement for extracting meta data by changing ROWNUM check to left join in the query

Today, we’ve started the rollout of the next release of TimeXtender Data Enrichment, v. 25.2, that contains the changes listed below.NewTimeXtender Master Data Management has been renamed to TimeXtender Data Enrichment Web URLs have been updated to use “timextender” instead of “exmon”. To access the web application, users will now go to {customer}.de.timextender.com instead of {customer}.exmon.com. Our login page login.exmon.com has been replaced with login.timextender.com, and even though login.exmon.com will continue to work we encourage you to use login.timextender.com from now on.ImprovedThe overview in User Configuration now shows the email of the users Better error message when app registrations for SSO did not have ‘Group.Read.All’ permission and user tried to search for Entra Groups in user configuration. Added support for more data types when importing a table from a database.  When clicking save after opening Database User Configuration, all users get Select permission to ‘exmondm’ schema and Execute permission to ‘exmondm.GetHierarchyValue’ function. Emails use ‘TimeXtender Data Enrichment’ instead of ‘Master Data Management’. Install file has updated name ‘TimeXtenderDESetup’ Use const string variable for "[None]" and "[Fixed Value]" instead of manual written string around the codebase. Using new icons and graphics.FixedFixed a bug where the Portal skipped the "Is Required" check when doing validation. If a table had Lookup columns with custom setup they could not be displayed in the web application User could not import into a table with a Large number column in the web application Fixed a bug where importing data into a table with a "Large Number" data type did not work.  More support for Availability Group connection Small fixes to the New User UI for on premise users Saved View did not work in the web application if it was filtering on a blank item list value During Import, Primary Key has Unique Key Action, Read Only has Ignore Action, else Update Action. During Import, Action column is no longer text editable and works as drop down selector. While DE is open and network connection is lost (i.e., during Windows supension) sql connection error is logged with log4net in install-folder\Log4NetDataEnrichment.txt Fixed a few bugs affecting percentage formatted decimal columns: Min/Max value for constraints was not always saved properly, importing data into a column did not always work and comparisons sometimes used wrong values.  On Table import, the column action selection functions the same way in web and desktop and on web it’s no longer possible the edit combobox value. All previous failing unit tests For lookup column, switching from Popup Window – ‘Custom Visible Columns’ to ‘Use Display Value’ re-adds ‘Custom Display Value’ to visible columns so that combobox can display the values (and not data type). Fixed a bug where the Project, Lookup Table and Key Column values were not always saved correctly for Hierarchy Lookup Attributes.  Fixed a bug where the scrollbar was not visible when giving permissions/privileges to a user.  When logging in the Microsoft and Google icons were cropped User was unable to authorize Fivetran connection Better error message when there is an error with finding Entra Groups Adding new user/group in User Configuration while having a filter does not cause any errors. Changing column name and then changing column type from normal to item list in table designer does not cause any issues.

It's almost like you cannot say fall without Fabric. At least this October release of TimeXtender Data Integration (Desktop v. 7142.1) has Microsoft Fabric features as the headliner along with a new logging system for Ingest and a bunch of big and small fixes and improvements. Dive in below! New and improvedFabric Lakehouse on Prepare gets views, shortcut tables and much moreWith this release, we're taking a major step towards full support for Microsoft Fabric Lakehouse as Prepare instance storage. Validations, history tables, table inserts, custom data, custom hash fields and junk dimensions are now supported on Fabric.On the programmability side of things, you can now add Notebook views, a new type of custom views that are deployed on a Fabric notebook and can be referenced and used in custom scripts. Regular custom views are also supported through the Fabric storage's SQL endpoint.Utilizing the OneLake shortcut feature, the Fabric flavor of the enable/disable physical valid table option is now available. Disabling the valid table creates a shortcut table where data is loaded directly from the Ingest instance. This saves execution time and storage space, but on the flipside, the table in Prepare must be 100% identical to the source table in Ingest - no transformations allowed.As a final improvement, Fabric instances now support service principal authentication, so a non MFA-user is no longer required.Redesigned Ingest loggingWe've taken a fresh look at logging in the Ingest instance in order to make it more useful and more robust. It includes more thorough logs, more options, an improved UI and, last but not least, file-based logging.Logs are now stored in the local file system and not in the Ingest instance, which is handy when you're investigating, e.g., issues with connecting to the instance in the cloud. It also makes them immediately available if you want to use them for analysis purposes. To aid in that, we're using the open W3C Extended Log File Format for the logs.When setting up the Ingest service, you can configure the log retention in days, as well as the maximum file size of the logs to keep the logs from hoarding to much storage space. You can also select the minimum severity level for logs to the log file as well as the Windows event log.The old logging system has been deprecated, but is still available for the time being when Show Deprecated Features is enabled in the View menu.PowerBI endpoints now support Direct LakeThe Power BI endpoint in Deliver now supports Direct Lake on SQL and Direct Lake on OneLake which facilitates much faster data access. This is especially useful when you have really large amounts of data.Control access to instance blueprintsBased on partner feedback, we've updated the access controls for instance blueprints. Partners can now control which customers are granted access to specific shared blueprints. The initial implementation worked more like a "shared folder" where all blueprints were available to all customers.Note: As a partner, you must update your existing blueprints to grant access to the customers that should have access, since the new default is no access. And much moreIn addition to the headliners, the release also includes a bunch of smaller improvements:Snowflake storage now supports key-pair authentication in preparation for Snowflake's requirement for multi-factor authentication for all users that kicks in by November. In the Ingest instance, we've changed the name of the default transfer task to "Load Data" and added a second default task called "Load Data (Full Load)". Previously, the default task was called "Full Load", but would actually used incremental load if it was available. The Ingest Service Configuration can now import the configuration of a previously installed version, making upgrading a bit easier. In the Portal, we've made deleting data source connections easier. You'll now see what instances the data source is mapped to and those mappings will be deleted along with the connection. Previously, you'd have to delete all mappings before you could delete the data source connection. We've tuned the data lineage queries to get you better performance when you want to view data lineage for an object. REST data sources now makes URL encoding of query parameters optional. ODATA discovery now includes certificates (PFX/PEM) for authentication.FixedDesktopFixed freezing UI and missing feedback when generating End-to-End Tasks and Packages. Fixed an issue in the Deploy and Execute dialog which could cause out of memory exception when having deployment and/or execution steps. Fixed an issue causing an 'Unauthorized' error. Fixed an issue where very large error messages could cause TDI to not correctly communicate with Orchestration Zoom in/out should now behave correctly in the data lineage window. Fixed an issue where data lineage would find old relation and potentially make the search very large. Changed some misleading labels in the Primary Keys and Synchronize windows. Added option to disable "windowed incremental load" for ADO and OleDB data sources to make incremental load work for specific ODBC sources. Fixed an issue in the remapping dialog in the Metadata Manager where sorting the columns would cause an "Index out of range" error and close the dialog. Fixed issue with installing new data source versions in a multi threaded environment. Fixed issue where ODBC/Ansi syntax for ADO/OleDB ignores incremental subtract value. Search & replace in REST now saves empty replace values as empty strings instead of null. Fixed errors with data type conversions on data area transfers using Fabric prepare. Fixed an issue with custom transformations and transformations on lookup fields returning null on Fabric prepare. Fixed an issue with empty date tables when working with multiple schemas on Prepare instances with Fabric storage. Fixed an issue with selection rules not working after renaming a field on Prepare instances with Fabric storage. Fixed an issue where the stored procedure used for direct read between data areas could become too long. Fixed an issue where adding and deleting a table mapping in a data area could crash the application. Fixed an issue where the SQL endpoint in a Prepare instance could cause slow UI updates. Fixed an issue where renaming a table where a field is used as a lookup field on a conditional lookup field would not mark the table where the conditional lookup field belongs as modified. Fixed an issue where deploying a history table with a dot in the table name would fail. Custom selection rules in Deliver instances would loose variables when closing the project. Fixed an issue where the order of the columns from Prepare instance would change. Made sure the Add Calculation Group and Edit Column Description dialogs have a minimum height and only vertical scrollbars. Fixed an issue where the semantic endpoint would resolve the Endpoint Name parameter incorrectly on execution. Fixed an issue where Power BI endpoint deployment with RLS fails with error AD Service Principal Authentication is not supported with this SQL Server version. Fixed an issue where deploying a Prepare instance could crash the application. Fixed an issue with parsing SqlDecimal data in Parquet files in Ingest. Fixed an issue where fields on Deliver instances could not be deleted if they contained a custom data selection rule.PortalFixed a duplicate/incorrect log entry on user (contact person) deletion Fixed an issue where activity logs required a refresh to show new entries Fixed issue where users were added despite invitation failure; failures return proper error messages now. Fixed activity log order for data source creation with simultaneous ingest mapping. Standardized table design across most of the Portal. Fixed issue where Double value types were not correctly interpreted in data source connection forms, leading to a failure to save. Fixed issue where the "Use Microsoft Entra members in Ingest instance security roles" checkbox would automatically reselect itself after being deselected and saved on Ingest instances with Azure SQL storage.

Today, we’ve released updated data source providers. See the changes below. Azure Data Factory - OracleVersion: 17.5.1.0 (TDI) / 10.4.5.0 (20.10 ODX)Switched to use v2 connector in ADF, since the previous one is being deprecated.Azure Data Factory - PostgreSQLVersion: 17.2.0.0 (TDI) / 10.4.5.0 (20.10 ODX)Switched to use v2 connector in ADF, since the previous one is being deprecated.CSVVersion: 23.15.4.0 (TDI) / 1.7.0 (20.10 BU) / 16.4.16.0 (20.10 ODX)Added support for handling multiple metadata URIs. Added trimming of long column names. Added culture settings when parsing numbers for metadata. Added support for FTPS location. Changed pattern matching for files to be case insensitive. Fixed issue with numbers parsed incorrectly with one decimal digit in some cases. Fixed issue with metadata URI handling for Sharepoint location.Dynamics 365 Business Central - OnlineVersion: 23.1.0.0 (TDI)Fixed an issue where the subtract value was not applied during incremental load.Exact OnlineVersion: 11.2.0.0 (TDI)Added support for incremental loading (TDI only). Added better handling of JSON edge cases. Added support for Azure App Registration with certificate. Added a fallback strategy to handle invalid characters in XML if it fails to read it. Added option to not URL encode query parameters. Added handling for non-standard Authorization header value. Fixed error message for timeout, it now shows text indicating that the request timed out. Fixed issue when data type is overridden in TDI. Fixed some scaling issues in the REST dialog for BU/ODX. Fixed issue with table builder when 'Only list flattened tables' is enabled where it would not return the correct schema.ExcelVersion: 23.16.1.0 (TDI) / 1.6.1 (20.10 BU) / 16.4.17.0 (20.10 ODX)Added support for handling multiple metadata URIs. Added trimming of long column names. Added support for FTPS location. Changed pattern matching for files to be case insensitive. Improved file aggregation logic. Fixed excel engine to allow for more files in metadata uri. Fixed issue with 'Treat Empty as Null' for table definitions. Fixed issue with metadata URI handling for Sharepoint location. Removed duplicate file aggregation pattern settings.HubspotVersion: 11.2.0.0 (TDI)Added support for incremental loading (TDI only). Added better handling of JSON edge cases. Added support for Azure App Registration with certificate. Added a fallback strategy to handle invalid characters in XML if it fails to read it. Added option to not URL encode query parameters. Added handling for non-standard Authorization header value. Fixed error message for timeout, it now shows text indicating that the request timed out. Fixed issue when data type is overridden in TDI. Fixed some scaling issues in the REST dialog for BU/ODX. Fixed issue with table builder when 'Only list flattened tables' is enabled where it would not return the correct schema.Infor SunSystemsVersion: 23.2.0.0 (TDI)Added support for the force Unicode optionODATAVersion: 11.2.0.0 (TDI) / 1.3.0 (20.10 BU) / 16.4.7.0 (20.10 ODX)Added support for certificates in metadata discovery. Added support for incremental loading (TDI only). Added better handling of JSON edge cases. Added support for Azure App Registration with certificate. Added a fallback strategy to handle invalid characters in XML if it fails to read it. Added option to not URL encode query parameters. Added handling for non-standard Authorization header value. Fixed error message for timeout, it now shows text indicating that the request timed out. Fixed issue when data type is overridden in TDI. Fixed some scaling issues in the REST dialog for BU/ODX. Fixed issue with table builder when 'Only list flattened tables' is enabled where it would not return the correct schema.OneLake Delta ParquetVersion: 23.4.0.0 (TDI)Fixed an error ingesting metadata when the Lakehouse doesn't support schemas.OneLake Finance & OperationsVersion: 23.5.0.0 (TDI)Fixed an error ingesting metadata when the Lakehouse doesn't support schemas.ParquetVersion: 23.13.1.0 (TDI) / 1.5.0 (20.10 BU) / 16.4.12.0 (20.10 ODX)Added logging of file names. Added support for handling multiple metadata URIs. Added trimming of long column names. Added support for FTPS location. Changed pattern matching for files to be case insensitive. Fixed issue with metadata URI handling for Sharepoint location.RESTVersion: 11.2.0.0 (TDI) / 1.9.0 (20.10 BU) / 16.4.21.0 (20.10 ODX)Added support for incremental loading (TDI only). Added better handling of JSON edge cases. Added support for Azure App Registration with certificate. Added a fallback strategy to handle invalid characters in XML if it fails to read it. Added option to not URL encode query parameters. Added handling for non-standard Authorization header value. Fixed error message for timeout, it now shows text indicating that the request timed out. Fixed issue when data type is overridden in TDI. Fixed some scaling issues in the REST dialog for BU/ODX. Fixed issue with table builder when 'Only list flattened tables' is enabled where it would not return the correct schema.SQL ServerVersion: 23.1.0.0 (TDI) / 1.1.0 (20.10 BU) / 16.4.2.0 (20.10 ODX)Added support for the force Unicode optionXML/JSONVersion: 23.12.0.0 (TDI) / 1.6.0 (20.10 BU) / 16.4.13.0 (20.10 ODX)Added support for FTPS location.

Today, we’ve started the rollout of the next release of TimeXtender Orchestration & Data Quality that contains the changes listed below.NewAdded support for setting the number of times a failed package should retry.  New schedule type - ‘Continuous’ - that starts a new execution right after previous execution finishesImprovedRedesigned the start page and fixed a bug where buttons/links did not always work.  Improved user experience and execution for Data Transfer merge. Added clearer error messages for the execution of Azure package types. Improved an error message shown when running an invalid Data Factory package. Removed the Subscription field from the Power BI Refresh package type UI, as it is no longer required. Web URLs have been updated to use ‘timextender’ instead of ‘exmon’ (i.e., https://dev.odq.timextender.dev/cmdservice/ExpectusCommandService.svc). In the Gateway desktop client, some paths in ‘ExmonClientConfig’ file is changed to ‘timextender’ (from ‘exmon’) during service startup. Increased the length of the data fields in Azure Data Providers so that Tenant Ids and App Ids will be fully visible The flow for sending emails from ODQ has been simplified. The default timeout for TDI package type is 6 hours and is now properly indicated in the TDI package UI in the Desktop client.FixedFixed a bug where compare query previews sometimes showed the wrong number of variance errors.  Fixed bug in the Initializing database step in On-Premise install Fixed bug where upgrading the Command Service failed when upgrading On-Premise Fixed an issue where Schedule Groups would show an incorrect icon for the Databricks package type Fixed an issue where Active Directory queries in ORC would not work if they returned 0 rows Fixed an issue where Azure Function packages would not check for the validity of credentials before starting execution Fixed an issue with the duplication and renaming of packages Fixed an issue with the duplication of Ingest packages Fixed an issue with VM names disappearing and not being saved in Cloud Optimization packages Fixed an issue where trying to create a Fabric package without any Fabric Data Providers present resulted in an "index out of range" error Fixed an issue with saving Properties changes in packages Improved error messages when Azure packages fail without any further information about the problem being sent from Azure In ODQ Portal, the ETA in the process popup now handles time zone differences between local machine and time zone setting in ODQ Desktop. Fixed an issue where images were not displayed correctly in emails Fixed an issue where pressing sync for TDI Data provider in Turnkey would timeout Better error message when there is an issue finding Entra Groups Fixed an issue where TDI packages would not sync correctly to object groups Fixed an issue with creating Entra groups and new users in ODQ Desktop Fixed an issue where execution of Databricks packages would not work Fixed an issue with duplication of Azure Cloud Optimizer packages where the Capacity option would be disabled in the duplicated package Fixed issue for Gateway trying to log control characters like esc via xml serialization.

Today, we’ve released updated data source providers for TDI. See the changes below.OneLake Delta ParquetVersion: 23.3.0.0 (TDI)Added support for service principal authentication (remove non-MFA user). Fixed an error when workspace contains special characters. Fixed some performance issues on metadata extraction. Fixed the use of INT96 Timestamps for backwards compatibility. Removed: Authentication command and user/password settings.OneLake Finance & OperationsVersion: 23.4.0.0 (TDI)Added support for service principal authentication (remove non-MFA user). Fixed an issue when workspace contains special characters. Fixed an issue when company WHERE clause is empty. Fixed some performance issues on metadata extraction. Fixed the use of INT96 Timestamps for backwards compatibility. Removed: Authentication command and user/password settings.

Today, we’ve published a minor release of TimeXtender Data Integration (v. 7135.1) in preparation for Microsoft's upcoming requirement for mandatory multi-factor authentication for Azure that begins rolling out on 1 October.We recommend that you install this hotfix if you’re using Microsoft Fabric storage and have not postponed the enforcement of the new policy, but otherwise wait for the next major release.ImprovementsService principal authentication is now supported for Fabric instance storage. A user account without multi-factor authentication enabled is thus no longer required to connect. We’ve added three new input fields for service principal authentication on PowerBI endpoints in the TDI Portal. PowerBI endpoints are affected by the new policy, but already support user principal authentication using the workaround described below. If you've upgraded TDI to v. 7135, you can begin using the new fields. If you haven't upgraded TDI to v. 7135, you can enter the service principal credentials in the Username and Password fields as follows:Username: app:<Application ID>@<Tenant ID>Password: <Secret>

Today, we’ve released an updated XML/JSON data source provider.XML/JSONVersion: 23.10.0.0 (TDI) / 1.4.2 (20.10 BU) / 16.4.11.0 (20.10 ODX)Added logging of file names. Added support for handling multiple metadata URIs. Added trimming of long column names. Changed pattern matching for files to be case insensitive. Fixed issue with same table names being used in different schemas. Fixed issue with metadata URI handling for Sharepoint locations.

Today, we’ve released updated data source providers. See the changes below.OracleVersion: 23.3.4.0 (TDI) / 1.1.1 (20.10 BU) / 16.4.3.0 (20.10 ODX)Improved handling of ‘raw’ fields.Oracle - Azure Data FactoryVersion: 17.3.1.0 (TDI) / 10.4.3.0 (20.10 ODX)Added schema and table filtering. Improved handling of ‘raw’ fields.TimeXtender Business Central 365 Data SourceVersion: 23.1.0.0 (TDI)Fixed bug where the batch number column was added multiple times.

Today, we’ve released a version of our OData data source provider for TimeXtender 20.10. The provider was previously only available for TDI.If you’re using the ODX and cannot see the new data source provider in the list, try restarting your ODX server service.ODataVersion: 1.1.1 (20.10 BU) / 16.4.2.0 (20.10 ODX)Initial release

Today, we released a minor version of TimeXtender Data Integration (v. 7047.1) with the changes listed below. We recommend that you upgrade if you’re affected by any of the issues fixed.FixedFixed an issue for Prepare instances using Snowflake storage where Snowflake would throw an error on deployment when using differential deployment. Deployment would fail on Prepare instances using Snowflake or Data Fabric storage if custom data was present. Custom data is only supported on SQL storage, so this issue would appear when changing storage from a SQL Server storage with custom data. It’s now possible to delete custom data when it is not supported by the storage type. For Prepare instances, fixed an issue where the ‘DW_SourceCode’ field was missing in the primary key check. For Deliver instances, updated the logic for the PowerBI endpoint connection string, so you can now use the Gateway in the PowerBI portal.

Today, we’ve released an updated CSV data source to fulfil a customer request for the updated S3 feature.CSVVersion: 23.7.3.0 (TDI) / 1.3.0 (20.10 BU) / 16.4.8.0 (20.10 ODX)Added support multiple delimiters. Added support for general S3 bucket connection.

Today, we've released a new version of the TimeXtender Data Integration Portal with the changes listed below.Fixed Fixed an issue preventing the page 'REST API web servers' from loading in some cases. Fixed an issue preventing blueprints from being shown. Fixed an issue preventing data source details to be loaded. The migration modal will now correctly remember your saved config.

On 4 June, we made a hotfix release with the changes listed below.CSVVersion: 23.5.3.0 (TDI) / 1.1.5 (20.10 BU) / 16.4.6.0 (20.10 ODX)Fixed issue with SharePoint when reading more than one file (Cannot access disposed object).Exact OnlineVersion: 10.2.0.0 (TDI)Fixed an issue with the ‘Set empty fields as null’ feature where it was applying the null on the wrong dataset. Fixed an issue where datetime was parsed into local time format instead of UTC.ExcelVersion: 23.7.0.0 (TDI) / 1.1.5 (20.10 BU) / 16.4.7.0 (20.10 ODX)Fixed issue with SharePoint when reading more than one file (“Cannot access disposed object”). Fixed issue where Excel was now trying to process unrelated files and failing.HubspotVersion: 10.2.0.0 (TDI)Fixed an issue with the ‘Set empty fields as null’ feature where it was applying the null on the wrong dataset. Fixed an issue where datetime was parsed into local time format instead of UTC.ODATAVersion: 10.2.0.0 (TDI)Fixed an issue with the ‘Set empty fields as null’ feature where it was applying the null on the wrong dataset. Fixed an issue where datetime was parsed into local time format instead of UTC.ParquetVersion: 23.6.1.0 (TDI) / 1.0.5 (20.10 BU) / 16.4.5.0 (20.10 ODX)Fixed issue with SharePoint when reading more than one file (“Cannot access disposed object”).RESTVersion: 10.2.0.0 (TDI) / 1.2.4 (20.10 BU) / 16.4.8.0 (20.10 ODX)Fixed an issue with the ‘Set empty fields as null’ feature where it was applying the null on the wrong dataset. Fixed an issue where datetime was parsed into local time format instead of UTC.XML/JSONVersion: 23.4.0.0 (TDI) / 1.0.5 (20.10 BU) / 16.4.5.0 (20.10 ODX)Fixed issue with SharePoint when reading more than one file (“Cannot access disposed object”).

Today, we’ve published a minor release of TimeXtender Data Integration (v. 7026.1) that contains the changes listed below. We recommend that you upgrade if you’re affected by the issues that have been fixed.FixedFixed an issue that caused intermittent failures when transferring tables to a Prepare instance with ADF transfer enabled. Fixed a problem affecting selection rules on Fabric Prepare instances. 

Today, we’ve published a hotfix of TimeXtender Data Integration (v. 7020.1) that contains the changes listed below. FixedFixed an issue where tables failed to run with multiple threads on a Prepare instance with ADF transfer enabled. Fixed an issue where date tables would fail to execute when run from a perspective on Fabric Prepare.

Spring has turned to summer and we’re celebrating with a new release of TimeXtender Data Integration (desktop v. 7017.1). When you open the desktop application, you'll notice a new refreshed look, but we've also implemented a ton of improvements under the hood. See all the news below. NewRefreshed desktop UIWe've refreshed the design of the desktop UI with refined theme colors, and a new, but less prominent, blue accent color. As another UI improvement, we've streamlined the names and order of the show/hide options - 'show data types', 'highlight descriptions', etc. - in the View menu. We've also saved many users a few regular clicks by enabling them all by default.Choose where in the world your metadata is storedYou can now choose a metadata storage region for your organization that specifies where in the world your new instances will be created. Current options are West Europe (default), Central US & South East Asia. Choose the region closest to you for the best TDI experience.ImprovedOne-step Fabric executionIntroduced one-step executions for Prepare instances on Microsoft Fabric, where executions are now automatically added to an execution plan and processed in a single step.Warning: If you're using Microsoft Fabric for Ingest or Prepare storage, make sure the Spark Runtime Version is set to 1.2 in your Fabric Workspace settings. We're working on support for Runtime version 1.3, which is the new default in Fabric.Performance improvements for Ingest instancesWe've improved the indexes on the tables in the Ingest instance repository database for better query performance, and improved and optimized various Ingest repository database queries to reduce data load and increase speed.Updated data sourcesAlong with this release of TDI, we’ve released new updated versions of our data source providers. Among the changes for the REST-based providers - Exact online, HubSpot, etc. - are support for certificates as authentication and global table flattening. For providers for static files - CSV, Excel, etc. - we’ve fixed a few bugs, including an issue with connecting to Azure Blob Storage.  For more information, see the full release notes.Copy scripts between Tabular and PowerBIYou can now copy all custom measure scripts in a Deliver instance from Tabular to PowerBI and vice versa. For context, custom measures have a script for each endpoint type, but PowerBI and Tabular share the same DAX syntax with few exceptions. For that reason, migrating from Tabular to PowerBI endpoints could entail copy-pasting hundreds of scripts. Since that’s no fun, we implemented this little shortcut.Improved Ingest Service Configuration tool The Ingest Service Configuration tool now automatically imports deprecated 'Managed ADO.NET' data source providers from the default component folder used in previous installations of the Ingest service (known as ‘ODX SaaS’ before v. 6744.1). This change eliminates manual steps in the upgrade process for users of these data source providers as they are no longer available for download from our repository. FixedTDI PortalIn the Portal, the Instances page now loads significantly faster if you have a lot of instances. ‘Send sign-in invitation’ would sometimes fail due to password restrictions. Adding a Microsoft or Google account as a login option would fail. Fixed a bug on the Deliver Qlik endpoint causing the wrong settings to be shown in the Authentication section.TDI DesktopWhen an execution task in an Ingest instance completes with no tables included, it will now set the state to 'Complete with Warnings'. Fixed an issue where executing an execution task in the Ingest while using a case-sensitive SQL Storage database would fail when listing existing SQL objects. Fixed an issue where executing an execution task in an Ingest instance while using a case-insensitive SQL Storage database would fail for a schema where an unused version of the schema with the same name in different casing exists. Fixed a memory leak in the metadata manager. Improved the UI performance of the metadata manager. Fixed an issue where a REST data source where a renamed table would not get mapped to the old name properly. Fixed an issue with synchronizing a Prepare instance with an Ingest instance where the loading animation would disappear before the synchronization logic had applied all the changes causing the UI to freeze. Fixed various issues with Prepare instances on Fabric storage, including: errors when capacity is turned off, problems with conditional lookups, issues when transferring tables from a TimeXtender F&O data source and notebook syntax errors with some aggregate functions. Data Cleansing Procedure includes NULL checks on underlying fields on SuperNatural key - this has now been fixed including no null check on Custom Hash fields. In some cases, the repository would block execution of execution package because of a deadlock issue. This could happen when multiple execution packages were scheduled to run at the same time. Fixed an issue with the Integrate Existing Objects feature where the simple mode option on newly created data areas would have invalid settings. Fixed a miss aligned information icon in the Table Settings window. Fixed a bug that prevented column values exceeding 43,679 characters from being displayed in the table preview, and also caused the query tool to throw an exception when result values exceeded 32,000 characters. Fixed an issue where Synchronization with Remapping on Deliver instances would show an error. Resolved an issue with Qlik endpoints using certificate authentication, where specifying a non-existent certificate would result in a null reference exception. Upgraded Qlik SDK to version 16.9 to ensure compatibility with the latest Qlik Sense release. Fixed an issue where adding fields to a table in the Deliver instance by dragging them from the Data Movement Pane would position them below the Relations node. Fixed an issue where Generate End-to-End Tasks and Packages would fail if the flow included an Ingest and the Ingest was not open in TDI. Fixed an issue that would cause the error "Execution package [name] is already running" when executing a migrated package in multiple environments at the same time

Today, we’ve released updated data source providers. See the changes below.CSVVersion: 23.4.3.0 (TDI) / 1.1.4 (20.10 BU) / 16.4.5.0 (20.10 ODX)Fixed a bug where connecting to Azure Blob storage did not work. Fixed a bug where Skip Top would not apply to all aggregated files.Exact OnlineVersion: 10.0.0.0 + 9.5.0.0 (TDI)Added support for certificates. Added support for setting a culture when interpreting data types. Added support for global table flattening. Changed override headers behavior. It will now not remove all headers, it will instead replace the headers that are defined in the list. To remove a header, add it with empty value. Fixed a bug where running in parallel could produce duplicate headers for authentication.ExcelVersion: 23.5.0.0 (TDI) / 1.1.3 (20.10 BU) / 16.4.5.0 (20.10 ODX)Improved logging when reading files, making it easier to track down problematic files. Fixed a bug where connecting to Azure Blob storage did not work. Fixed a bug where having a . in a folder name would cause it to try and read it as a file.HubspotVersion: 10.0.0.0 + 9.5.0.0 (TDI)Added support for certificates. Added support for setting a culture when interpreting data types. Added support for global table flattening. Changed override headers behavior. It will now not remove all headers, it will instead replace the headers that are defined in the list. To remove a header, add it with empty value. Fixed a bug where running in parallel could produce duplicate headers for authentication.ODATAVersion: 10.0.0.0 + 9.5.0.0 (TDI)Added support for certificates. Added support for setting a culture when interpreting data types. Added support for global table flattening. Changed override headers behavior. It will now not remove all headers, it will instead replace the headers that are defined in the list. To remove a header, add it with empty value. Fixed a bug where running in parallel could produce duplicate headers for authentication.ParquetVersion: 23.5.1.0 (TDI) / 1.0.4 (20.10 BU) / 16.4.4.0 (20.10 ODX)Fixed a bug where connecting to Azure Blob storage did not work. Fixed a bug where loading data from a file with multiple row groups would not work.RESTVersion: 10.0.0.0 + 9.5.0.0 (TDI) / 1.2.2.0 (20.10 BU) / 16.4.6.0 (20.10 ODX)Added support for certificates. Added support for setting a culture when interpreting data types. Added support for global table flattening. Changed override headers behavior. It will now not remove all headers, it will instead replace the headers that are defined in the list. To remove a header, add it with empty value. Fixed a bug where running in parallel could produce duplicate headers for authentication. Fixed bug with preview table not working in Business Unit.XML/JSONVersion: 23.3.0.0 (TDI) / 1.0.4 (20.10 BU) / 16.4.4.0 (20.10 ODX)Fixed a bug where connecting to Azure Blob storage did not work.

Today, we've released updated data source providers. See the changes below.CSVVersion: 23.3.30 (TDI) / 1.1.3 (20.10 BU) / 16.4.4.0 (20.10 ODX)Added default file types. Fixed bug where parallel execution could lock files. Fixed missing root path handling for test connection when using SharePoint connection. Fixed a bug where the ordinals of the columns were not preserved when there are no headers.Exact Online Version: 9.2.0.0 (TDI)Fixed a bug where an empty header name could cause an issue.ExcelVersion: 23.3.0.0 (TDI) / 1.1.1 (20.10 BU) / 16.4.3.0 (20.10 ODX)Added default file types. Fixed bug where parallel execution could lock files. Fixed missing root path handling for test connection when using SharePoint connection. Fixed bug where all columns had to be selected in order to load data into Azure Data Lake.HubspotVersion: 9.2.0.0 (TDI)Fixed a bug where an empty header name could cause an issue.ODataVersion: 9.2.0.0 (TDI)Fixed a bug where an empty header name could cause an issue.OracleVersion: 23.1.4.0 (TDI) / 17.1.0.0 (TDI ADF) / 1.0.1 (20.10 BU) / 16.4.1.0 (20.10 ODX) / 10.4.1.0 (20.10 ODX ADF)Added support for ‘RAW’ and ‘LONG RAW’ data types. ‘RAW’ will be translated to a ‘varbinary(2000)’, and ‘LONG RAW’ will be translated to ‘varbinary(max)’. Fixed an issue where data types not recognized by the Oracle data source would throw an exception instead of marking them as ‘Unknown’.ParquetVersion: 23.4.1.0 (TDI) / 1.0.3 (20.10 BU) / 16.4.3.0 (20.10 ODX)Added default files types. Fixed bug where parallel execution could lock files. Fixed missing root path handling for test connection when using SharePoint connection. Updated Parquet library to support the latest Parquet metadata standards.RESTVersion: 9.2.0.0 (TDI) / 1.0.2 (20.10 BU) / 16.4.2.0 (20.10 ODX)Fixed a bug where an empty header name could cause an issue.XML/JSONVersion: 23.2.0.0 (TDI) / 1.0.3 (20.10 BU) / 16.4.3.0 (20.10 ODX)Added default file types. Fixed bug where parallel execution could lock files. Fixed missing root path handling for test connection when using SharePoint connection. Fixed issue where table flattening could not execute in the BU and ODX versions.

Today, we’ve released an updated data source provider for Excel. Note: Today’s release contains the TDI version only. 20.10 BU and 20.10 ODX versions will follow.ExcelVersion: 23.2.0.0 (TDI)Added ‘_ResourceURI’ column as an available metadata column. This column is automatically populated with the filename of the Excel file for that row. Added default file types. Changed some file management behavior to avoid locking files. Fixed a bug related to aggregation of files and sheets and infer data types.

Today, we’ve published a minor release of TimeXtender Data Integration (v. 6963.1) that contains the changes listed below.ImprovedImproved the Ingest logic that manages data source providers to no longer try to download deprecated providers which caused confusing error messages. Renamed display names to no longer include "Semantic" Removed the limitation of reserved words for custom field validations and custom conditionsFixedFixed a wrong icon for super natural key fields in data lineage and Perpare table selection. Fixed various typos in the TDI application. Fixed an issue where the Metadata Manager in Ingest would produce a change notification for columns without the ‘original data type’ metadata. Fixed an issue with deploying Hierarchy tables with ‘Null check approach’ set to ‘Record Based’ Fixed an issue in Ingest on Fabric Lakehouse storage where tables were not transferred correctly  if they contained ancient dates. Fixed an issue where the ‘StepODXDataFactoryExecute’ was not cleaned up when the last table was removed from an execution package that allowed that step to exist. Fixed an issue where Convert to Mapping Set was incorrect for fields with custom transformations. Fixed an issue where Integrate Existing Objects was affecting existing views. 23785: Primary key check is getting skipped when a table has no mappings This issue was corrected - It affected tables with no mappings but having custom data, table inserts, and/or related records.

Today, we’ve released updated data source providers. See the changes below. CDATA Added a CData Placeholder Data Source (only valid for TimeXtender 20.10.57 and earlier)CSVVersion: 23.2.3.0 (TDI) / 1.0.1.0 (20.10 BU) / 16.4.2.0 (20.10 ODX)Added support for different character encodings. Updated labels of settings related to null value handling. Updated data type detection. Fixed issue with columns when doing file aggregation. Updated root folder logic for all cloud location connectors. SharePoint: Updated error message handling. Azure Data Lake: Updated to skip empty files when reading metadata.Excel, XML/JSONVersion: 9.1.0.0 (TDI) / 1.0.1.0 (20.10 BU) / 16.4.1.0 (20.10 ODX)Updated root folder logic for all cloud location connectors. SharePoint: Updated error message handling. Azure Data Lake: Updated to skip empty files when reading metadata.ODATAVersion: 9.1.0.0 (TDI)Fixed small issue with metadata discovery.ParquetVersion: 9.1.1.0 (TDI) / 1.0.1.0 (20.10 BU) / 16.4.1.0 (20.10 ODX)Updated root folder logic for all cloud location connectors. SharePoint: Updated error message handling. Azure Data Lake: Updated to skip empty files when reading metadata.REST, Exact Online, HubspotVersion: 9.1.0.0 (TDI) / 1.0.1.0 (20.10 BU) / 16.4.1.0 (20.10 ODX)Fixed issue with SQLite being unavailable in some cases. Fixed bug in Table Builder when using current endpoint.