Unanswered questions

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 

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  

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,

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

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.

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