Recently active topics

Hi, I'm trying to consume REST API with limit/offset paginationhttps://<>.rest.afas.online/ProfitRestServices/connectors/<connector>?skip=250&take=250&orderbyfieldids=Medewerkerskip = Offset. in the example above skip the first 250 rows take = limit. take 250 rows seems to work in Postman My approach was to use 'override pagination’In combination with endpoint's 'query parameters’  using the following expression:SELECT ({TX_NextPage} - 1) * 150 AS skipValueWhen running the ODX tasks it seems to ingest only the first page. What am i'm doing wrong? 

 Date & Time: 22 April 2026 • 15:30 (Copenhagen)Register: Sign up on Zoom AI is raising the stakes for data quality and exposing just how broken many data foundations really are. From invoices that don’t add up, to inconsistent logistics data, to finance numbers that refuse to reconcile, the cracks are becoming impossible to ignore. Traditional “cleanup projects” and Excel workarounds simply can’t keep up in an AI-driven world. In this session, we’ll explore what a modern, always-on approach to data quality looks like, and why continuous monitoring is the only way forward. This won’t be a typical one-way presentation. Instead, join a dynamic, conversational session where real-world challenges meet live product insights:Stefan and Melanie will walk through common (and painfully familiar) data quality issues across billing, logistics, and finance Along the way, we’ll jump in with live discoveries from the TimeXtender Data Quality product and roadmap, showing how these exact problems

A couple of questions:Table builderTo build i a table, i extract data steam first in POSTMAN.I can either copy it into a flatfile and use input method Local File I find it a bit strange that there no browser option:  Or if the response is not too large, i can just copy it into Table Builder[ { "_recno": 0, "ID": "1", "Topic": "TX Enhanced Data Connectors", "valid_upto": "2099-12-31T00:00:00+01:00", "attr": "Data Connectors", "related_attr": "TX", "status": "N", "date_from": "1900-01-01T00:00:00+01:00" }]This is the table builder, with copied respose: The issue is that, when i click OK, go out and go back in, the space where i have pasted the respose is empty and so is the ‘Nodes in the table’ window ! Table Builder - errorIf i some how makes a mistake (lets say that i have forgot the closing brackets): instead of a pop-up error, TableBuilder throws me out and the changes are lost: Show XMLAlso, what is Show XML tab at the bo

I have now installed a new version on a new server.I have downloaded Enhanced datasources.Now i want to Replcate one of my CData Sources so that i can use TX REST ot TX JSON datasource. The Cata Source i want to replicate is a REST source:DataModel : FlattenedDocumentsI have my RSD files at: C\RSD\DataSourceConection requires that i send a bearer token.  

Hi there. Currently we get the long error messages when something fails in Orchestration executions, which tends to need some encryption at times to understand. However, in the new Portal I get this gloriously understandable error message:  Is there any chance as of now to get these new error mesages as the email notifications? Best regards,Darri 

In 20.10, is there a way to remove a data source but keep the tables with the data that were created from it? I’m trying to eliminate my last CData data source that pulled legacy data in from an old MS Access database. I tried to remove the data source, but in doing so, it attempts to delete the loaded tables in the Business Unit. I still need to be able to use and reference the legacy data that was loaded but I no longer have access to the legacy MS Access database to re-load it with a non-CData connector.

I have a large table with about 50 columns. There is column called projectNumber. This column, i am unable to override.This column is varchar. However in TX with Enhanced Drivers it shows Int32.I have overridden it to Text It even says so in Data type overrides on the DataSource I have even tried adding and removing it in Table builder  

Hi All, Hopefully you can help me with this one. We have a source table from our POS systems containing sales transactions. There are a few value columns we transfer that are stored as a money data type and we see some weird things happening with the values of the columns. Differences of 0.01 up to 0.0001 are appearing from nowhere in the transfer from ODX to DWH and i don't know how this i happening.The columns that have money data type are called ‘Bedrag', ’Korting’ and ‘NettoBedrag’ Take transaction 52. In the source the values are like this: After transfer with ODX, i looked in the parquet file using ParquetViewer and that looks like this: Still the same, nothing wrong here.I imported the table without any modifications in TimeXtender and it looks like this: After a transfer the data looks like this: If you look closely we lost 0.0001 on the first record ‘NettoBedrag’. Also wel lost 0.0001 on the Bedrag of the second record.I've tried a few things to mitigate this. Different numeri

Overview When setting up a Data Integration data provider, you need to map your TimeXtender instances to the three environments used in the platform: Development, Testing, and Production. This tells the system which TDI instance to use when executing packages in each environment.  Step 1 - Enter your API Key Enter your TimeXtender API key in the API Key field. This key is used to authenticate against the TimeXtender API when fetching your available instances.  Step 2 - Fetch Instances Click the Fetch Instances button. The platform will connect to the TimeXtender API and retrieve all available instances across your Ingest, Prepare, and Deliver packages.  While fetching, the button shows Fetching… and is temporarily disabled.  Once complete, the instance table appears below.  If you have already fetched it before, the button reads Re-fetch Instances and will refresh the list.   Step 3 - Assign Instances The instance table shows one row per instance group. For each row, use the three dr

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 ?

Incremental Load Strategy for Data Warehouse Layer (Prepare Views → DW Hi everyone,We’re working on a project for a TPA that provides property and casualty services to smaller P&C companies. The architecture connects to multiple disparate sources that ultimately feed into a standardized data warehouse.Here’s our current setup:Architecture:We’re creating a raw schema in Prepare for each data source, then using views to abstract the transformation logic. The DW maps from those views. So the flow is: Source → Ingest → Prepare (raw) → Prepare (views) → DW.What’s working:Incremental loads are running well from Source to Ingest and from Ingest to Prepare raw — no issues there.The challenge:The DW layer currently runs as a full load every time. We’re moving roughly 200M rows per company. Load times are about 1:45 hours, which is manageable, but we’d like to bring that down with incremental loads. It would also reduce the vCore demand — we’re currently on 8 vCores Premium Series with memor

Hi everyone,I need to use the import and export functionality to migrate between different environments (dev/test/prod). I have run multiple tests (including database objects, excluding database objects, multiple tables, single tables, etc.).However, during every import attempt, I receive the following error: > "Error importing project. This sqlTransaction has completed; it is no longer usable."Does anyone know what this means and what I can do to achieve a successful import? Any suggestions or shared experiences with the import/export feature would be greatly appreciated! Thanks in advance,

Projects and other objects created within Data Enrichment can be migrated between environments with the Export/Import feature. In order for an export/import to work both services need to have the same Data Enrichment version.Note: Anyone can export a project but only admins can import a new project.Export a ProjectRight-click a project and select Export Project A popup will open where you can select what you want to export, this can be both tables and database objects such as functions and stored procedures. Destination: Select where the zip folder will be saved Export:  Table Structure and Data: Includes both structure of the tables and their data Table Structure only: Includes only the structure of the tables Import a ProjectClick Edit projects in the bottom left corner of the application Click the Add dropdown and select Import Project Select the zip folder that was created when you exported the project and give your project a new name. Then click Import Project. Your

We are experiencing an issue with Generic ODBC Data Sources in TimeXtender 20.10.74.64 on SQLTX01.EnvironmentTimeXtender version: 20.10.74.64 Repository/Application: 20.10.74.64 Server: SQLTX01 OS: Windows Server 2019 Datacenter SQL Server: Microsoft SQL Server 14.0.3520.4 NT x64 TX build: 64 bitInitial situationWe originally noticed the issue on a PostgreSQL source that is accessed through an SSH tunnel.The PostgreSQL ODBC connection itself works correctly when tested directly in the ODBC Data Source Administrator.Example:server: 127.0.0.1 port: 5433 ODBC test from Windows ODBC Administrator: successfulAt first we suspected a PostgreSQL / tunnel issue, but further testing suggests this is not the case.What happens in TimeXtenderThe issue occurs inside the Edit Generic ODBC Data Source dialog.There are two scenarios:1. Opening the DSN dropdownWhen we open the Generic ODBC Data Source dialog and click the dropdown to show available System DSNs, TimeXtender immediately fails.So the failu

I configured a REST API endpoint. It woks as expected as long as I only add tables from my MDW to the endpoint. However, any views I add to the instance in TX are not visible through the API. They do not show up in the /swagger nor can I query data from them nor can I find any mention of then in the webserver configuration. Why is that?

Hi,TimeXtender Data Integration 7303.1TimeXtender Ingest Service 7313.1  We are connected to our Azure Datalake Gen2 storagecontainer (tested OK through TDI) We are having problems with our ingestserver trying to connect to all our data sources. All of them are timing out when running and they fails with no log The only log we kan find are from TimeXtender O&DQ Desktop (see att.)We have been trough https://support.timextender.com/initial-setup-start-here-115/configure-your-firewall-700 and done the tests,  all OKTest-NetConnection sql-instances-prod.database.windows.net -port 20000Test-NetConnection sql-instances-prod-002.database.windows.net -port 20000Test-NetConnection traws.timextender.com -Port 443Test-NetConnection gateway.timextender.com -Port 443Test-NetConnection gateway.timextender.com -Port 80Test-NetConnection sbns-customer-prod-001.servicebus.windows.net -port 5671Test-NetConnection sbns-customer-prod-001.servicebus.windows.net -port 5672Test-NetConnection auth0.com -P

Hi everyone,We are currently using TimeXtender 20.10.45. After performing a multiple environment transfer from our dev to our test environment, some tables disappear (physical tables, not R or RT tables). I had to create these tables manualy. How is this possible, and could it be related to the version?  

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.

TimeXtender 20.10 will only be supported until February 2027. It will be replaced by TimeXtender Classic (TimeXtender Classic).TimeXtender Classic does not support ODX. If you are using ODX, it has to be replaced by Business Units (BU).This guide describes how to do this. Create the Business Unit and Data Sources Step 1 – Create the Business Unit Create the BUFollow the steps to create the storage for the BU.  Step 2 – Add Datasources Recreate all Data Sources existing in the ODX in the BU  To create a Data Source, right-click on the created BU.  Choose the wanted Data Source or Adapter and fill in the necessary information. Please include:   All data sources (in use)  All tables and columns (in use) for each Data Source  Constraints  Incremental Load Settings  Repeat for all your data sources.  Mapping Tables and Columns  This is the starting point. Tables are mapped to the ODX.  Step 1 – Map the BU table Locate the equivalent table in the BU.  You can use Ctrl-F to search for a sp

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.

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.