Ingest

Hello,After Snowflake enabled behavior change bundle 2026_04 on our production account, our execution packages began failing. TimeXtender generates the "SCD Surrogate Hash Key" column as a virtual (computed) column with a NOT NULL constraint.As of bundle 2026_04, Snowflake rejects NOT NULL/CHECK constraints on virtual columns at DDL time, so the CREATE TABLE statement for the TX-generated temporary staging table now fails. The same project ran fine until the bundle was enabled, and runs fine again after we temporarily disabled the bundle.The failures occur only on tables that have History (SCD) settings enabled. Tables without history are unaffected, which is consistent with the surrogate hash key being generated specifically for the history/SCD code path.Environment- TimeXtender Data Integration, product/portal version: 7158.1- Data storage: SnowflakeError messageJavaScript execution error: Uncaught Execution of multiple statements failed on statement "CREATE TABLE ...#<temp>...

I believe I have read the documentation, in case I missed something. My bad. Im trying to load csv files from the root of a S3 bucket. The 'test connection’ in the portal turns green but when trying to synchronize in timextender it tells me I have to enter a value for ‘path’.I have tried these so far: /.mybucketname/inbound/s3://mybucketname/inbound/But timextender keeps throwing errors saying the directory does not exist. I can succesfully connect to it and download the csv's via Python so Im quite sure the setup is correct.  Does anyone know what to fill in for ‘path’?

I have en endpint with multiple parameters:CaseHandling/External/Cases/GetCases?exportFields=CaseID&exportFields=Closed&exportFields=Position&exportFields=ProjectLevel&exportFields=Anonymous&Key is always exportFields Values are differentIn CData i have no issues getting values in the columns.In TX Enhanced Connection, when i define multiple parametes with key-anme exportFields and different value, only the last is shown: This is how i have defined in TX Endpoint I have tried the whole endoint in Path, which gived empty table  

Dear sir,How can I remap tables to a different ODX instance automatically, instead remapping tables manually for a 100+ tables (V7303.1).Any suggestion is welcome.Thanx.Regards,Arthur

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

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

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

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

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 a TimeXtender REST connection to SalesForce. This specific REST API is a file api. This means that you have to send a request (in the form of a query) to an endpoint, after which the API starts to generate an export. When the export is finished, it can be downloaded via a separate endpoint as CSV.To extract this data with TX REST, I have set up a method with three endpoints per ‘endpoint’, this works as following:The first endpoint called _query sends a query via a POST request to a specific endpoint The second endpoint called _waitForComplete uses a dynamic value from the _query endpoint so that the _query endpoint gets executed first. The _waitForComplete endpoint uses pagination with a 1-minute delay to send requests to an endpoint that returns the status of the generation of the CSV file. Once the generation is complete, the _waitForComplete endpoint will return a JobComplete response which will stop the pagination. The third endpoint uses a dynamic value from the _waitForCo

Is there any documenation on how to get this set up?  I cannot find anything on the support site besides that the functionality is available.  I have set up things in my Snowflake account but TimeXtender refuses to create storage.  I have created the stage in Snowflake and point TX towards it and get this: Object reference not set to an instance of an object. I have triple checked all RBAC settings and the role assigned to my TX service account has what it needs. I can even see that after running import meta data it has created some folders in the stage.  But will not create storage or load data from my source data connections

Hi, I’m running TimeXtender Data Integration 7158.1.When integrating an existing object I accidentally got a few extra tables, or MDW schemas, into my project that I didn’t intend to integrate.Now I’m having a hard time removing them from the project. Going through the ‘integrate existing objects’ window without having those schemas selected does not help. In two cases could drop the tables and remove them that way but I don’t want to remove txdsa.ODX_TEMP tables (while running). I thought of simply reverting my version but as of now it seems that the open folder is disabled. I do see version notes though but no way to revert to that version.Any ideas? 

Hi Everyone, In the Ingest instance activity log I see a lot of messages. It happens when populating a table in the DSA (execute). We are using Datalake as storage and TDI version 7158.1Execution takes a loooooong time also. What goes wrong here???  

Hello,I use TimeXtender CSV Data Source (version 23.18.5.0). I'm trying to read about 15 csv's from an sftp server, but since january 15th 2026 we get an error. This server is hosted by an external supplier which has it's settings limited to max 1 session (no concurrent sessions).In TDI I've configured the max concurrent threads on 1, so max 1 thread at a time. My transfer still crashes because I use too many threads.I tried to put max concurrent threads on 0. This resulted in a never ending transfer task. Didn't work.After this the supplier increased it's max threads temporarily for testing purposes. I configured the connector on 1 thread again. If I look in the log, I can see that the first 2 tables start on the same timestamp. This occurs a couple of times more. Is the connector using 2 threads now?Is this advanced max thread setting working correctly for the TX csv connector? Supplier claims we're not using 1 thread. I'm not sure how I can check and prove this. Do you have any advi

Hello,Since the TimeXtender Classic (V25) was announced to be released by the end of Q2 2025, i would like to ask if there is a clarified date when the release is planned. To my knowledge it has not been released as of yet? Also the more important question to me is the upgrade process. Currently we are using TimeXtender classic together with ODX server and we have couple of questions:Will there be a detailed guide released on upgrading older TimeXtender platforms (20.10.52 in our case) to Classic V25? What will happen with all the data sources in our ODX instance? Since we are using quite some CDATA providers - does it mean we will have to manually recreate the data sources? Or ODX will be deprecated and we need to move to using BusinessUnits? Thanks for the information

I have a source table in ODX. The source only keeps record for the last 3 months. UUID ColumnA ColumnB ColumnC Date 1234 Xiaomi Mobile phone 125 GB 01.01.2025 5678 Apple iPad 1 TB 01.02.2025 9101 Samsung Mobile phone 256 GB 01.03.2025  When i am in month 4, the forst row is unavailable in the sourceUUID ColumnA ColumnB ColumnC Date 5678 Apple iPad 1 TB 01.02.2025 9101 Samsung Mobile phone 256 GB 01.03.2025 11121 Google Pixel Mobile phone 256 GB 01.04.2025  I want to keep the history in DSA forever.I know that if i create a history table and use UUID as unique key, i will be able to keep the history.The question is: what if i accedently execute the table on 01.04.2025! Will i lose everything before 01.02.2025? Or will executing the table keep the history intact !What if there are changes in the source and there is either a new column or the column name changes? I need to then deply the table. Will that keep th

Hello, we have upgraded to 20.10.74 TimeXtender with 20.10.73 ODX server from older version. Since ODX server is getting removed in the future and CData connectors have their distribution stopped, i am looking to migrate the existing connectors to future supported ones and  switching from using ODX server to using Business Unit. Could you advice me which connectors i should start using instead of the following ones?:CData ADO.NET Provider for Microsoft Excel Online 2024; CData ADO.NET Provider for Databricks 2024; CData ADO.NET Provider for SAP HANA 2023; CData ADO.NET Provider for REST 2023I does not look that there are direct alternatives to these, at least in current TX version. Are there also any guides of migrating these specific ones to new alternatives? Thank you