Recently active topics

Hi,TimeXtender Data Integration 7303.1TimeXtender Execution Service Configuration 7303.1Storage Type: Azure Data Lake Gen2 storage  All my mapped data source connections has not connection to the source since friday 27/3 evening. So none are working. None error messages when running....Any clue why?best regards,Bjørn A.

Today, we’ve published a minor release of the TimeXtender Data Integration Ingest Service (v. 7313.1) with a fix that ensures that we support Spark Runtime 1.3 on Fabric Lakehouse as Microsoft is ending support for Spark Runtime 1.2.We recommend that you install this hotfix if you're using, or want to use, Fabric Lakehouse as your Ingest storage.FixedTimestamp columns transferred into Ingest storage on Fabric Lakehouse are now correctly preserved as Int96 when switching workspace to Spark Runtime 1.3.

Couple of questions regardnig the new version:Why does date say November 2025 for the latest release: Download TimeXtender 20.10 – TimeXtender Support. A bit confusing. Is it the latest version, or is the latest version only available in customer portail? Here is says that V25 is TimeXtenders new focus for on-prem solution, but the lasted version on customer portail is 20.10.74.64. Where can v25 be downloaded from? If upgraded to the TimeXtender Data Integration (fully cloud version), how much work is it to migrate everything from 20.10.45.X ?

We have SSO setup for a Client for using O&DQ.We can create individual User Accounts just fine, but if we try to make use of Entra Groups we get 2 issues:The Browse dialog for adding the ENTRA Group does not list all Entra Groups. If we add a Group using the group’s object ID it seems to work correctly but users in the group when singing into login.timextender.com are asked to select the “Company” they want to access once they select “Orchestration and Data Quality”. and the list of companies is blank. We have tried adding in a different group that the user is in that does appear in the browse dialog with the same result.Version of TX O&DQ is 25.2.0.58 Need to understand why this is happening to satisfy the client.

At our client Heijmans, we're experiencing differences in mappings from the same table in the Ingest.We're on TDI 7208.1 and Prepare Instance oDataWareHouse version 3655Using a Salesforce source, we're using the table Object__c where we approximately have 400 fields available. At the moment, we only have about 350 ‘checked’ in the Ingest. However, when adding new fields (of the remaining 50), and transferring and synchronizing the project, the mapping doesn’t update. It's even possible to add the same table as a second source and then, the whole list becomes available. To give another example, the standard field [odx_timestamp] has been checked in the Ingest, but is only visible in the second mapping in the project.   

In this article, you will learn how to install a Power BI refresh package. To be able to do this, in the Azure Portal, you need to create an App registration which you will use to access our Power BI. This is done under the Azure Portal > Azure Active Directory > App RegistrationCreate an App registration Open up the Azure Portal here Search 'App Registration' For this example, name the application 'Test' and click Register at the bottom of the page Click on Certificates & secrets Then, click on New client secret Add a description of your client secret Specify when this key should expire. Then click Add On the next page, copy your secret value Add the following permissions Enable the “Service principals can use Fabric APIs” setting under Tenant settings in the Admin Fabric portal   Open up Power BIIn Power BIGo to your workspace in Power BI and in the upper right corner select Access.  Then search for your app registration and click Add. Next, open up TimeXten

Hi team, I need to audit how many rows were moved by batch on the prepare table. Is there in TX how to audit it?ThanksCarlos

Today, we’ve published a minor release of the TimeXtender Data Integration Ingest Service (v. 7312.1) that makes it possible to download CData data source providers again. Previously, you could only use the CData providers already installed on you machine.We recommend that you install this hotfix if you're using, or want to use, CData data source providers.Note: CData providers are made available as a paid add-on.FixedDownload of CData data source providers has been re-enabled.

Hello,We are seeing an issue with a Enhanced Data Source TimeXtender REST (1.9.0) data source in TimeXtender where decimal values are being interpreted incorrectly during ingestion.We have two datasets based on the same AFAS source: one loaded through a REST connector in TimeXtender one loaded through a PowerShell script that retrieves the same REST data and exports it to CSV, which is then loaded into TimeXtender The CSV route shows the correct values for the field Aantal_FTE, for example: 0.18 0.25 0.55 0.95 1.00 However, the same field loaded directly through the TimeXtender REST connector shows incorrect values such as: 18 25 55 95 375 625 675 It appears that decimal values are already being misinterpreted in REST.rows, before the data reaches the staging table.For example: 0.95 becomes 95 0.375 becomes 375 0.675 becomes 675 This suggests that the decimal separator is being lost during REST parsing.Additional observations: In the REST source preview, the i

This guide will help you get started connecting an AFAS GetConnector to the TX REST data source provider. It assumes you have: Created an app-connector in AFAS Added the GetConnector(s) you would like to load to the app-connector in AFAS Obtained an Afas TokenStep 1: Encode token as base64The AFAS API token takes the following format:<token>{YourTokenHere}<tokenYou must use a base64 encoded token to authenticate the API. There are multiple tools you can use to achieve this; I will be using PowerShell: $token = '<token><version>1</version><data>{YourTokenHere}</data></token>'$encodedToken = [System.Convert]::ToBase64String([System.Text.Encoding]::ASCII.GetBytes($token))$authValue = "AfasToken $encodedToken"echo $authValue The result will look something like: AfasToken PHR{EnCoDeDtOkEnHeRe}This entire output should be passed through the authorization parameter, which will be discussed in the next section. Step 2: Create a new data connection i

Note: To help keep your TimeXtender environment secure, we highly recommend enabling Multi-Factor Authentication (MFA) for your organization. MFA adds an extra verification step when signing in, which greatly reduces the risk of unauthorized access to your data.Ensuring the security of your TimeXtender account is essential. Multi-Factor Authentication (MFA) provides an extra layer of protection by requiring an additional verification step beyond just a password. This guide will walk you through the process of setting up MFA, including prerequisites and how to disable it if necessary.What is MFA?Multi-Factor Authentication requires you to confirm your identity with something more than just your password. In TimeXtender, this means entering a time-based one-time password (TOTP) from an authenticator app on your phone or device when you sign in.If someone gets your password, they still cannot access your TimeXtender Portal without the code from your authenticator app, which helps protect

This option is used for demonstration, development, or testing purposes when the client and MCP server run on the same machine. Alternatively, when you want the MCP Server to act as a shared, production endpoint for AI clients on your network use Connect to MCP using HTTP mode.Prerequisites Instructions TroubleshootingPrerequisitesConfigure MCP Server Configure MCP Semantic EndpointInstructionsConnect to ClaudeClick the Claude Desktop Config tab in the TimeXtender MCP Configurator Select the MCP service to export Click Export to Claude Desktop to configure the stdio connection Launch Claude Desktop application on the same machine If Claude was previously running, you must click File > Exit to full exit and reopen Claude desktop. Verify the TimeXtender semantic model appears as an available data sourceConnect to LM StudioClick the Claude Desktop Config tab in the TimeXtender MCP Configurator Select the MCP service to export Click Preview Config Copy to ClipboardOpen LM StudioClick C

Today, we’ve published a minor release of TimeXtender Data Integration (v. 7303.1) that includes a fix for an issue with incremental load and mapping sets as well as a handful of fixes for Fabric Lakehouse as instance storage. We recommend that you install this hotfix if you're affected by the issues we’ve fixed.FixedAfter upgrading to 7257.1, tables with incremental load configured in Ingest that was brough into Prepare though a mapping set were ignoring their incremental rules and running full loads on every execution. In Ingest instances on Lakehouse storage, if running with a user account that lacked access to certain objects, the entire table listing operation would fail. In Ingest instances on Lakehouse storage, no table is created when the table in the data source is empty. This would cause a “path not found” error when copying data to Prepare since the logic expected a table to be present even if there was no data. In Prepare instances on Lakehouse storage with multiple data ar

Hi there,Is it possible to add a button in a Power BI report that triggers an orchestration process map?If yes, what are the steps to get this working?The idea is that users of that specific report can refresh the data by clicking on a button in that report. Christian

This guide explains how to configure Snowflake as the storage backend for a TimeXtender Data Integration Ingest instance. With native Snowflake ingest storage, you can run a fully Snowflake-based architecture without landing data in Azure Data Lake first.Note: This feature was introduced in TimeXtender Data Integration 7257.1.PrerequisitesBefore configuring Snowflake ingest storage, ensure you have the following:A Snowflake account hosted on Microsoft Azure. TimeXtender currently only supports Azure-based Snowflake accounts for ingest storage. AWS and GCP-hosted Snowflake accounts are not supported.  A Snowflake warehouse for running queries and data ingestion A Snowflake user account with key-pair authentication configured (recommended) or username/password authentication. See the Use Snowflake for Prepare Instance Storage article for detailed instructions on setting up key-pair authentication A TimeXtender Standard, Premium, or Enterprise packageImportant: The following features are

This article describes how to add a Qlik Endpoint to a Deliver instance. For Qlik endpoints, the end product is a QVD file for each table in the model. QVD is a proprietary data format that stores data in a way that gives the best performance in Qlik apps. Since only Qlik applications can create QVD files, deployment and execution of Qlik endpoints create apps or scripts that a Qlik application can use to create QVD files.Note: If you are using SQL Server 19 or newer, though not the SQL Server 2025 version, ensure that version 18 (i.e. 18.x.x) of the Microsoft OLE DB Driver for SQL Server is installed on the Qlik Server (instead of version 19.x.x). Also if you have Qlik installed on a separate machine, and not on your application VM, then please ensure you have installed the Microsoft OLE DB Driver for SQL Server version 18.x.x on both the Qlik server and the application VM. If you are using SQL server 2025, then you need to be sure that you use version 19 of the Microsoft OLE DB Drive

Hi,i want to retrieve ActivityEvents from PowerBI Admin using then TimeXtender REST API.configure the base URL as: https://api.powerbi.com/v1.0/myorg/admin/Endpoint configured as: activityevents?StartDateTime=%27{BDAT}%27&EndDateTime=%27{EDAT}%27&filter=Activity%20eq%20%27ViewReport%27{BDAT} and {EDAT} are populated using a SQL Query: DECLARE @i int = 0WHILE @i > -5BEGIN    select CONCAT(FORMAT(dateadd(day,@i,GETDATE()), 'yyyy-MM-dd'),'T00%3A05%3A00.000') as [BDAT],    CONCAT(FORMAT(dateadd(day,@i,GETDATE()), 'yyyy-MM-dd'),'T23%3A55%3A00.000') as [EDAT]    SET @i = @i - 1ENDi hoped it will loop for the past 5 days but unfortunately this doesn't work.Setting the BDAT 5 days in the past doesn't work either. Any ideas how to solve this?by the way we are using TX Classic V 20.10.66.64 and TimeXtender REST API v16.4.23.0 (also tested with 16.4.21.0)Kind regards,Hans 

Hi Team, Hope you are well!!We have received CVE-2024-21907 Kenna Vulnerability in SUN ODX Servers to upgrade SSIS from version 15.0.4440.1 to version 15.0.4455.2. Could you please confirm whether we can update this to the latest version? The SSIS package used for integration, I am not really sure if this will affect the existing integration.?

Hi, Within TimeXtender O&DQ I am wondering if it is possible to setup “Email on failure” on processes instead of a singe Packages. Untill now I always add email on failure on every single package, but in the end it would be much faster to be able to add this on a higher, hence on the Prosess level. Is this possible?Kinds regards,Devin

We are migrating from CData data sources to the TimeXtender REST API data source.For Microsoft Graph API (used to retrieve calendars for multiple meeting rooms), the connection works correctly, but we are running into a major performance issue. While we retrieve the same amount of data.Performance comparison:Using CData:Ingest task: ~4 minutes Execute task per table: ~10 secondsUsing TimeXtender REST API data source:Ingest Full Load: 1.5 – 2 hours Execute task per table: 10–15 minutesWe have over 30 tables, so the execution time increases dramatically when using the TimeXtender REST API connector. Question:Are there any recommended ways to improve the performance of the TimeXtender REST API data source, both for the ingest phase and for execution runtime?For example: configuration tips, concurrency settings, pagination options, or known limitations compared to CData?Any guidance or best practices would be greatly appreciated.

Hello,My current employer uses TX 20.10.45 (ODX and other services). We sometimes experience some bugs and want to ugprade to the latest version. I was told that it is better to have the ODX and the other services on the same version. So i was thinking about ODX 20.10.73 and the same version for other services. Now the main question: Is it possible to upgrade from 20.10.45 directly to 20.10.73 without any installation issues? Or do we need to upgrade in phases?Thanks for your help and anwsers.Kind regards, Tim

Hi,Is there some documentation available for the metadata in the exmon database, on how the DB model works? We would like to create some useful queries for troubleshooting purposes, to find problems in the run.(I found this old thread where the last post asked the same question: Exmon run stats into PowerBI | Community. Don't know if it was answered somewhere else) Thanks! Willem

Hi, yesterday we deleted multiple tmx objects(tables/ views) from our current project. When we try to open the project we get this error: “Error loading project 'RvA TX':Index was outside the bounds of the array.Details:Index was outside the bounds of the array.Module: timeXtenderSystem.IndexOutOfRangeException   at TimeXtender.DataManager.Project.InitProject(Int32 version, DsProject loadDsProject, DataSet adaptersDataSet, ProjectsRow projectRow)   at TimeXtender.DataManager.Project.LoadProject(DsProject _dsProject)   at TimeXtender.DataManager.Project.<>c__DisplayClass136_0.<LoadProject>b__0()   at TimeXtender.DataManager.ConnectingThread.ExecuteConnectingThread(Object dummy)Index was outside the bounds of the array.Module: timeXtenderTimeXtender.DataManager.ExceptionWrapperException   at TimeXtender.DataManager.ConnectingThread.HandleError()   at TimeXtender.DataManager.ConnectingThread.Execute(String title, Int32 progressSteps, List`1 actions)   at TimeXtender.DataManage

Hi,After getting a new phone the two-factor authentication doesnt work anymore when login to TimeXtender Data Integration 7278.1Need support for further assistance :-)regards,Bjørn A.