Unanswered questions

Hello, We have currently set up a hybrid environment for our TX deployments. A DEV environment in on premise MSSQL database and test and prod in Snowflake. I have already come across situations like hashing where the built in functionality is not usable in Snowflake and if you create a custom field with a hashing algorithm it is not possible to deploy from MSSQL to Snowflake becuase of the different language required to create the hash. I have also com across this when writing custom scripts. In those cases so far i have been able to create code that works in both environments. Is there any way to handle this more effeciently when running a hybrid set up like this? We are trying to reduce unneccessary costs in Snowflake during development hence the hybrid set up. I have read some things about Instance variables but it would be great if there is some kind of best practice in a set up like this.

Hi all, Does anyone have experience with or managed to do a “dynamic” kind of flexi multi key join in TimeXteder? Example like this --- a.[BUYER_GROUP_CD], b.[BUYER_GROUP] FROM [DSA].[SYNAPSE_SILVER] a LEFT JOIN [DSA].[XLS_PURCHASING_GRP] b ON a.[BUYERGRP] = b.[BUYER_GROUP] OR ON a.[BUYER_GROUP_DESC] = b.[BUYER_GROUP_ID] OR ON a.[BUYER = b.[BUYER_GROUP_WORKSPACE_ID]

Hello, We have a case in TimeXtender Classic where we need to read more than 256 Columns from the Excel connector. My understanding is that the underlying driver does support it, but by default it will only Return the first 256 Columns, and thus that is all we see when reading objects from the DataSource. Does anyone know if there is a way to expose more columns beyond the 256 already shown? Thanks Tim

Hello, Our data source owner team needs to close their Synapses behind the firewall to close the Prisma Clouds alerts. Therefore they are collecting all the IP ranges needed for different access scenarios, like Zscaler IP ranges for getting access from VPN/Zscaler. TimeXtender is the only solution outside Azure resources in their eyes that needs to access the data.So we need to listed those ranges. Do you know where to get these ranges for TXD cloud portal,? Or I was understanding it wrong, it is just the IP that hosts Ingestion server connection? Thank you in advance.

Hi everyone, I’m working with TimeXtender Data Integration version 6848.1 and my ODX storage is an Azure Data Lake using Parquet format. When I trigger a new reload from the source to the ODX (which should create a new incremental file in the background), I get the following error: The table folder 'x' is used by another table with the id 'y' I found this article that describes the issue: The table folder is used by another table The suggested solution there is to delete the existing folder in the data lake. Unfortunately, that’s not an option in my case because the source system only holds two weeks of data, while I have built up historical data in the data lake that I cannot afford to lose. This means every time I run a reload, the process fails as it tries to create a new incremental file for that table. Has anyone encountered this scenario and found a workaround that does not involve deleting the existing folder? Is it possible to remap the table or adjust the configuration so the

I just upgraded TimeXtender to the latest versions for a client. (7017 and 7047). In doing so most of the datasource stopped working unless I upgraded the datasources to the latest versions. I decided that I should just do them all to be consistent. This has broken my CData Rest sources because the new drivers are not installed! This is a massive issue, and i was not warned in any significant way about this particular issue in the upgrade. I need to get the new CData drivers, I am not in a position where I can transition multiple CData Rest sources as part of an upgrade! This is a production issue and I need to resolve it ASAP!

Hi, We're observing strange behavior with the new enhanced REST data source provider. When we do the call on this endpoint in the old connector or in Postman, we get a return of 197 records. This is a single payload, 1 page, with fully filled rows, including a populated PK field. Now, when we do the same call with the enhanced REST data source provider we receive 589 records. 392 of these have null values on all records except for one field, a descriptive but not otherwise important. Importantly the PK field of these records is also null. Now we have two questions: Why is the new REST provider delivering more records than other providers/tools? How can we effectively filter out these records in the actual call? As it seems we are now only able to successfully filter out these almost empty records at the DSA. Best, Luuk

Hi In an effort to resolve intermittent ODX errors whilst retrieving data back from Oracle JDE tables I am trying to understand whether reducing the ‘concurrent execution threads’ setting in the Oracle data source connections could be a potential solution. I have multiple Oracle connections set up in TX, with each connection pulling a subset of tables (e.g. all the JDE master file tables in one connection, all the transaction-related GL tables in another etc). All these connection transfer tasks are then wrapped up in a TX job scheduled to run each evening. The ‘concurrent execution threads’ default value across all the Oracle data connections I had set up for this was ‘8’. My thinking was that if TimeXtender is running multiple data pulls simultaneously then this could be causing resource contention issues on the source Oracle server, and thereby intermittently triggering data pull failures with generic error messages that don’t precisely indicate root cause. I have since changed the

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

Dear All, We have a “Dynamics Business Central (NAV)” data source with multiple adapters (multiple ERPs). We recently needed to “synchronize” the object to get the last BC evolution (new fields, ...). Unfortunately, the “Display name” of some tables/fields changed. 😒 Ex: -“Lot” “Lot No_ Information” table is now named “Lot No. Information” -“Demand Forecast” “Production Forecast Entry” table is now named “Demand Forecast Entry” Our default was to use “Display Name” (instead of Database Name) in the data selection and staging deployment. Our main concern is our significant number of sql views associated to these selected tables/fields with “hardcoded” name. We know that is recommended to use parameters to avoid problem with renaming but we didn’t implement the params in this case missing time and practicality with the sql code. 😥 Do we have an alternative solution without significant adjustments in our tables/fields selections and associated staging sql custom views ? TXT version: OnP

Hi, I've got a couple of installations with customers using CDATA for AD/Entra integration, with the upgrade I found an article to advise moving them to REST. I am however a bit lost on how to connect a REST API to Entra, and I couldn't find good documentation to fill it in. Could someone assist us for a moment or maybe point us toward more complete documentation specifically on using the Enhanced Data Source to connect to Entra? Thanks in advance, Jan DD

Hi Over the weekend one on our ODX jobs failed with the following error; Executing table [PRODDTA].[F0101]:failed with error:Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-50000: Connection request timed out at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPassw, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch, Boolean bAsync) at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassw, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch, Boolean bAsync) at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, OracleOpaqueString securedPassw, OracleOpaqueString securedProxyPassw, OracleConnection connRefForCriteria, Boolean bAsync) at Oracle.ManagedDataAccess.Client.OracleConnectionInternal.OpenInternal(Boolean bAsync) at Oracle.Managed

Hi! recently I helped a customer who was changing IT providers with installing their TimeXtender in the new environment. At this moment when executing a table they get an error message saying the following: Cannot find the object "O_BAE_BTW_CODES_R" because it does not exist or you do not have permissions. Details: SQL Server: 'ohs-sql1' SQL Procedure: '' SQL Line Number: 2 SQL Error Number: 1088 This concerns a table in the DSA layer of their TX environment. And is a table that does actually exist when we check the database in SSMS. The error message appears on the following step: Execute DSA dbo.O_BAE_BTW_CODES ODX transfers Permissions have been checked multiple times, the concerned user accounts have db_datareader & db_datawriter privileges at the very least.

I’m looking for a TimeXtender Fabric Lakehouse (pyspark.sql) expert 😀 I’ve got a SQL transformation that selects the maximum value of 10 columns: (select max(val) from (values ([Column_1]), ([Column_2]), ..., ([Column_10])) as [Values](val)) How do I achieve this in a Prepare Lakehouse custom transformation?I could build the mother/father of all massive case statements, but I’d prefer something simpler and more elegant … if possible!?

I'm using dynamic values function in the TX REST connector 9.1.0.0. I use id's from another endpoint to loop through in my second endpoint path. This works well when I use “From Endpoint Table” but now I want to add a filter to only get the id's with a flag “hasresponse=true”. I've read the page but I still get an error with my Endpoint query. “No such table” the error message says. I've tried several things like adding a schema. But all with the same response. Is there something wrong with my syntax? Error:

I have a client that wants to explore a significant rework of their Prepare instance. They want to duplicate their existing Prepare instance in Dev to create a sandbox instance. Is there a recommended approach to achieve this? They are using version 6898.1