TimeXtender Desktop Q&A

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?  

I’m currently working with TX Enhanced Data Connectors and have noticed that there doesn’t seem to be a built‑in way to handle HTTP 404 errors. Heres is a senario:I have en endpoint which is:/api/{referenceA}/{referenceB}referenceA are office-location IDsreferenceB are values like [sales, procurement, operations]I can do this either by GET, this way: or, by POST, this way: { "referenceA": {officeLocations}, "controlCurves": [ "sales", "procurement", "operations" ]}If an office location (referenceA) has all three departments (referenceB), i get a responseIf an office location (referenceA) has one or more departents (eferenceB) missing, the extraction stops.I have also tried it with a GET method in TX Enhanced ConnectorsI dont want the extraction to stop, i want it to skip and go to next value. Something like this (log from a python script): Fetched sales for LOC1Fetched operations for LOC1Failed for LOC1, procurement, status 404Response: {"description":"Procurement' does not exist

Hello,We recently upgraded from TX destkop 20.10.45 to 20.10.80 (Both ODX and App). After migrating the ODX from the Db022 to the Db026, the CDATA Microsoft Active Directory 2025 connector succesfly completed all its taks, but tables in the ODX are still empty. I already tried:Switching to older version (2021) Installed another test connector Reinstalling ODXAnyone an idea how this is possible. Below some (blured) screens.    

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.  

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

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? 

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.

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

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 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.

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

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,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, We've setup a REST API web server according to the manual. On the resulting endpoints fieldnames always seem to start lowercase. The original fieldnames in the deliver instance start with a uppercase letter. Now, I know that there should be a way to edit this in the configuration of the web server.Is this something we can edit ourselves? I've tried looking up directions, but web servers are not my expertise and I am unsure if the source code for the web servers is available locally or only in the cloud repository? Vilsen, Luuk Bouman

I am having some issues with the transfer step when loading incremental using direct read. The problem seems to be that the generated procedures do not utilize indices on the underlying tables, resulting in full PK scans for every run.I was especially having problems when running on azure general compute. Switching to hyperscale helped some, but the transfer step still uses approx 40sec scanning ~90m rows causing bottlenecks. When using ADO.NET I could set an index on the incremental rule-field speeding up the search to <1sec.The execution-plan generated by TX looks like this: Here we get a PK index-scan even when there is an index on dw-timestamp.Testing on a subset of the data (~10mill rows): Adding the option(recompile) to the procedure results in the procedure using the dw-timestamp index: Is there a good reason for why these procedures are generated without the recompile flag?Is it something that could be added in a later release?And is there a way to work around this other tha

I have 3 big fact tables in the source which i load incrementally. Primary keys are CompanyID and EntryNo (applicable for each table separately, incrementing), the records in these fact tables are never deleted.I need to merge these tables to a single table in DSA layer also incrementally. I think of following setup:Make the DSA table also incremental, check “Don’t handle deletes” (as the records are never deleted in source) Include both CompanyID and EntryNo as primary keys in the table; Incremental Selection Rule → EntryNo > (Last max value); Map all tables from source in this single DSA table The result which i expect is every time DSA table is executed - it incrementally loads data from 3 related fact tables - based on EntryNo for each separate CompanyID (one CompanyID per one source table). This way i have one huge table containing all the records for all 3 “Companies”. Am i correct to assume this is the setup i need? Are there any risks with possibly missing or overwriting the

Hello,What’s currently the recommended alternative for the CData Googlesheets provider when we switch to TimeXtender Enhanced providers?Kind Regards,Hendrik

Hi teamI have created this Schedule Groups,  The ingestion process packages are working fine, but the prepared packages are not working. the message log is:Logfile output: 5:01:53 AM UTC now: 2/20/2026 5:01:53 AM5:01:53 AM TimeXtender Version 25.2.0.57 built 11/10/2025 2:15:00 PM. Running on vm-orc-prod-0075:01:56 AM PID: 42376  - Started with arguments: --startschedulegroup 9 --execute_uat PROD --schedule_group 9 --customerkey uim --use-saas-queue true --token ece94e91-e0af-4588-9844-80e5e7f952cd --is-saas-local true 5:01:56 AM Connected at 2/20/2026 5:01:56 AM5:01:56 AM 5:01:56 AM *** Executing schedule group 165:01:56 AM Running schedule group CortexPolicy on PROD with 4 tasks.5:01:57 AM 2/20/2026 5:01:57 AM Starting: GWPCProd Load Data (Incremental Load) (CortexIngestServiceDLSProd) - (28) Extra Param: 5:01:57 AM (28) Command : epcmd --uat PROD --startpkg 28 --parentexecid 31 --use-saas-queue true --execute_uat PROD --token ece94e91-e0af-4588-9844-80e5e7f952cd --is-saas-local true

Hello,I am connecting to an external blob storage using a private endpoint. The blob storage is structured as follows:parquet/ 2025-12-29/ Acquisition.parquet Asset.parquet AssetBalanceSheet.parquet … User.parquet ValuationAssumption.parquet 2025-12-30/ Acquisition.parquet Asset.parquet … Etc. I am using the TimeXtender Parquet Data Source provider. The connection works, but the results I get from the Metadata Manager are not what I expect.Current settings Path: parquet/ Include subfolders: Yes Included file types: parquet File aggregation pattern: Asset.parquet Expected behaviorI expect the Metadata Manager to return a single table called “Asset”, aggregated across all available date folders.Actual behaviorInstead, all files/tables are returned, with what appears to be an "_<number>" suffix added for each additional date folder (e.g. Asset, Asset_1, Asset_2, etc.).I tried many setting combinations:Test 1: Exact filename, no wildcardsPath: parquet/ Inc

Hello, Technical: 20.10.67 using ODX (Updated: SQL Database not data lake)Connector: Cdata Ado.net provider for Json (2024)Settings: Source: Azure blob Data Model=FlattenedDocuments;Flatten Row Limit=1000000I have a situation with a odx transfer task failing and crashing the ODX due to memory.I need to jump in and help in a project where they need to get a very large json (85gb) into TX, because any previous attempts to ingest it fails. I ran a sample size to test (49mb) which resulted in roughly 550k rows and took 60s to run with a transfer task. One page (5000) takes around 200-300ms from looking at logs.If it is linear it would mean upwards of 900 million rows (we do not know the actual row amount) and it could take upwards of 30h if we assume linear scaling here. One easy problem was timeout time, which I fixed by increasing the ODX timeout from 2 hours to 24 hours during testing.Currently I can get it to run to around 6-7 hours but then it fails due to the ODX crashing with the fo

Hi, I am adding a mapping set (4 tables) to my table and then I get the “Source Table” column. After a deploy and execute the column “Source Table” have only a single dot in the column. I am expecting a table name from the mapping set as before... Whats wrong? Any suggestion? regards,Bjørn A.

Is the new TX Enhanced REST source slower than the old CData REST source?When we tested simple REST endpoints we saw the new TX source using 10x longer for the same identical job.Anyone have any experience with this?For reference we are running on TX 20.10.72.64.

I have been trying to sort out something out,My JSON looks like this:addendumGroupName occurs multiple times. Here, its 4 times but in other cases it occurs between 1 to 50.columns can be one or multiple I am trying to list all addendumGroupName and all columns under each addendumGroupName without doing this:json/addendumValues/addendumGroups[2]/addendumGroupName[0]json/addendumValues/addendumGroups[2]/rows[0]/columns/fremdrift_group[0] json/addendumValues/addendumGroups[2]/rows[1]/columns/fremdrift_group[0]json/addendumValues/addendumGroups[2]/rows[2]/columns/fremdrift_group[0]  So i tried this (with an without [*] at the end of column name): <attr name="addendumGroupName" xs:type="string" readonly="false" other:xPath="/json/addendumValues/addendumGroups[*]/addendumGroupName[*]" /> <attr name="fremdrift_group" xs:type="string" readonly="false" other:xPath="/json/addendumValues/addendumGroups[*]/rows[*]/columns/fremdrift_group[*]and for JSONpath:<api:set attr="detai

In the new version 7257.1 What’s mean this symbol in some tables and fields?