Recently active topics

Hi, TimeXtender Data Integration 7303.1I got this error when opening instance An error occurred while fetching data from the database.Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.Location: Table: TableInsertSelectionRuleFieldsForeignKeyConstraint TableInsertSelectionRules_TableInsertSelectionRuleFields requires the child key values (881d81f2-2ee7-4716-8eb8-d9da2332b33d) to exist in the parent table..  How to solve this? best regards,Bjørn A.

The use of PBI semantic models require to use XMLA endpoint, that’s mean that we need a Power Bi PPU license. That it’s ok.The question it’s why not use the deployment pipelines feature in PBI PPU?The principal problem that I found it’s that it’s not possible to parametrize the data source conections to use correctly this feature.Somebody has experience in this topic?

Hi,I recently upgraded to the latest available versions of TDI and TIS:TDI: 7303.1 TIS: 7313.1After the upgrade, one of my data sources in the TX Portal is now showing "Applied provider version: Incompatible".Data source details:Provider type: TimeXtender Enhanced Current provider version: 23.16.1.0 Available upgrade: 24.3.2.0 Ingest instance service version: 200.0.7313.1The portal offers an upgrade to v24.3.2.0, but shows this warning:"If the version of TimeXtender Data Integration you're using is not compatible with the new data source provider, the data source will stop working. Please make sure you're on the latest version of TimeXtender Data Integration before upgrading the provider."I thought I upgraded to the latest TDI, but it will not support the new version of the provider?How do I resolve this?

Test Groups from template are an easier way of creating multiple tests on one table. This feature has been made available in version 23.3 or newer of TimeXtender Data Quality.What is a Test Group from Template?Test groups allow users to add and configure multiple tests on a specific table in one editor.  Currently, there are test groups for three types of data sources:SQL Tests From Template: Allows users to use a table in a SQL database as the source TimeXtender Tests From Template: Users can configure a table in a TimeXtender database as the source. TimeXtender MDM Tests From Template: Allows users to connect to a table in their Data Enrichment service.Types of tests availableColumn NULL Check: Allows you to select columns that should not be NULL. The test fails and notifies the user if one or more of the columns have a NULL value. Read more about this type of test here. Table is Empty: Checks whether the table is empty or not. Custom SQL: Allows the user to add a WHERE script to the

Hi,I did renew my solutions architect certificate today. Is there any expire date for certificates granted nowadays? When i got certified in 2023 it was valid for two years. Best regards,Markus

Planned Maintenance – login.timextender.comWe have a scheduled maintenance window for login.timextender.com to ensure continued stability and performance.Maintenance window:May 5, 2026, from 18:00 to 19:00 CESTAffected servicesDuring this period, the following services may be unavailable or experience interruptions:Orchestration (web portal and desktop client) Data Quality (web portal and desktop client) Data Enrichment (web portal and desktop client)Expected impactUsers who are not already logged in, may experience login issues or be unable to access the affected services during the maintenance window. Scheduled Orchestration executions are expected to continue running and should not be impacted.What you need to doNo action is required. We recommend avoiding login attempts during the maintenance window to prevent disruption.If you continue to experience issues after the maintenance window, please contact TimeXtender Support

Hello,At the moment we are onboarding a new REST API data source that uses PEM certificates in combination with a key file.We are using a legacy version of TimeXtender (20.10.80); where can I specify the PEM certificate (or its path) and likewise the key file?I have currently configured it as follows:1. Pem file2. KeyThe REST API endpoints are working in POSTman, so technically it works fine. Thanks for your anwser.

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,Recently we updated our TimeXtender application and ODX, and as part of this process we moved our ODX from our development server to the production server.We are now reconfiguring the scheduler and are running into issues. Our test environment, which runs on the same server as our development environment, is being picked up by the scheduler correctly. However, the development environment is not being picked up by the scheduler.We have one scheduler running on the dev/test server.What I have already tried:Installing a second scheduler service specifically for the Dev environment, using "Dev" as the Environment field value — this did not work.  I used multiple values for env (Dev, Repo name, Servername)Could you advise on how to configure the scheduler so that it also picks up the development environment? We have multiple SA accounts available. Thank you in advance.  

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

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

Data source providers from CData are available in TimeXtender Data Integration as a paid add-on. If you do not want to pay the associated fee, you simply have to not use the providers.However, to prevent a user from accidentally incurring the fee by adding a data source using a CData provider, we have provided a toggle for company admins to active or deactivate the add-on. When the toggle is off, no new data source connections using CData providers can be created. Existing data source connections using CData are not changed when you deactivate access to CData providers. You must manually change any data sources connections using CData providers to use an alternative to avoid the fee.Activate or deactivate the Cdata Providers add-onTo enable or disable access to CData providers, login to the TDI portal with a user account that has the ‘company admin’ permission and go to Admin > Basic Info. Locate the CData Providers card and click the toggle button.  If the setting is off, you will

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?  

Hi all,Our TimeXtender is currently growing and growing, which is a good thing. However, I’m experiencing performance issues during TimeXtender execution and would appreciate guidance on both technical optimization and cost-efficient scaling.As my execution packages become unpredictable regarding execution times, i’m running into issues with PowerBI starting it’s refresh without TX being finished.TimeXtender Version: 7158.1 TX O&DQ Version: 26.1.0.23 ODX: Azure Data Lake Gen2 Execution VM: OS: Windows Server 2022 Datacenter Azure Edition Size: Standard D8s v5 (8 vCPUs, 32 GB RAM) Production Instance: SQL Server Storage Azure SQL Database: Tier: General Purpose (Provisioned) Compute: 2 vCores Storage: 65 GB I’m currently integrating data from about 15 sources, distributed across 5 ERP systems.I played around with execution package threads some time ago and i’m using 12 parallel threads for a while now. This package as a total task count of 540. During execution (mainly data load

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.

I have read through the guide(s) and posts, but still not able to solve the issue.The pagination info is on the top of the API response I am on page 2, reteriving only 1 record. I can reterieve max 100.This the API endpoint i am using: /api/result?pageNumber=2&pageSize=1{ "pagination": { "total": 29486, "pages": 14743, "page": 2, "pagesize": 1 }, "data": { "cases": [ { "index": 1, "id": 1, "subject": "Hidden", "description": "Hidden", "plaintext": "Hidden", "solution": "Hidden", "status": "Hidden", "priority": null, "impact": "Hidden"} ], "total": 1 }}I have overridden pagination - because not all endpoints are paginated.I dont want to reterieve all pages (which are 30 if i reterieve 1000 records per pageSize) before i know i can reterieve first 5This setting should be 500 recor

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  

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

Hi,I started working with the PowerBI refresh functionality in Timextender O&DQ 26.1.0.23. After following the steps in Power BI Refresh Package in TimeXtender Orchestration | Community,the first tests were really promising, but after adding it to my Processes it seems like i keep getting unexcepted errors and PowerBI isn’t refreshing reliable. The first refresh of the day succeeded, but after that I only get errors.Yesterday is successfully ran multiple times, but at the end it kept giving the same errors. I’m not getting any info as far I can see in the logfile output. The dataset has only refreshed one time today through scheduled/API refreshes, so I haven’t hit the limit for today yet. I see the 429 “Too many requests” error coming back, which indicates throttling because API rate limits are exceeded, often due to high-frequency refreshes, parallel queries, or concurrent refresh plans.However, as the test schedule was just once per hour I don’t think I’m at my limit yet?Any hel

Hi, I have server, database, username and password for postgreSQL DB.with pgAdmin no issue it connects immediatelly. (no additional settings)In TX I tried CData ADO.NET Provider for PostreSQL 2022 (tried 2018 also, same result)Set SSL False - got error no encryptionSet SSL True - [500] System error: server certificate verification failed. Connection aborted. should I need any additional configuration, maybe different provider, any ideas? thanks in advance,Jakub

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

For reporting and troubleshooting purposes, taking a deep dive into the logs and other metadata in your instances can be useful. With the meta collection feature, you can access TimeXtender metadata in TimeXtender Data Integration.To not put unnecessary load on the underlying databases, metadata is exported to a data lake once every 24 hours. From the data lake, you can copy the data to your own Ingest instance through a standard TimeXtender data source connection. Each load to the data lake overwrites yesterday’s files, so setting up incremental load to your own Ingest instance will usually be the way to go. Enabling metadata collection for selected instancesFollow the steps below to select the instances you want to collect metadata from.In the menu, go to Data Estate > Meta collection On the Meta collection page, click Add metadata collection In the Add meta collection instances modal, select the instances you want to export metadata from under Instances. (Optional) Add a Comme

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?