Recently active topics

Does anyone know if there’s a way to export all open and closed tickets for an organization? If not, is it possible to easily set up an automated Python process (e.g., by doing web scraping) to save them to an Excel spreadsheet?

Is there Swagger import support for the new TimeXtender REST data source?

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

Hi team,I have to set the incremental load best practice in my proyect, I need to know if the steps that I do are correct.First I set up the PK on ingest area.after that I set up the incremental Load Them in my Prepear area, I set on the tables incremental load. To finish I set add Incremental Selection Rule   Are thes steps correct? Is this the way to set incremental load?  Thanks for your support

Last Updated: 18th December 2025Effective Date: 5 March 20261. Relationship to the TimeXtender EULAThis CData Add-On Addendum (“Addendum”) is a supplement to, and forms an integral part of, the TimeXtender End User License Agreement (“EULA”) entered into between TimeXtender A/S (“TimeXtender”) and the customer (“the customer”).By: accessing, enabling, or continuing to usethe CData Add-Ons (as defined below), Customer confirms that it has accepted the TimeXtender EULA, and agrees that this Addendum is incorporated by reference into the EULA as if fully set out therein.If Customer does not accept the EULA and this Addendum, Customer must not access or use the CData Add-Ons.In the event of any conflict between this Addendum and the EULA, this Addendum shall prevail solely with respect to the CData Add-Ons.2. Scope and DefinitionsFor purposes of this Addendum: “CData Add-Ons” means third-party data connectivity components provided by CData Software, Inc., made available for use solely as e

By using the TimeXtender software, you accept our privacy policy and the below end-user license agreement.  Last Updated: 18th December 2025This User License Agreement contains the terms and conditions under which you (the “Licensee”) agrees to license the Software from TimeXtender. Please read and agree to the terms of this agreement before you start using the Software and setup your user account. 1. DEFINITIONS. The following terms shall have the meanings set forth below:"Documentation" means all and any electronic and written aids and specifications developed by TimeXtender in relation to the Software, for which the Licensee has acquired the right of use from time to time, and any descriptions developed by TimeXtender in relation to the Software."Education Materials" means all existing TimeXtender manuals, books, presentations, computer based training and tools in relation to the Software and all revisions thereof."Software" means both the SaaS portal of TimeXtender and the desktop

Hi All,My current employer uses TimeXtender Desktop and two separate servers (dev/test + prod).The previous administrator installed the ODX server on the dev/test server. This causes issues when a datasource is modified, as it also affects the production environment.At my previous employer, we had an ODX server per environment: Dev ODX, Test ODX, and Prod ODX.My question is: what does the community recommend regarding having an ODX server on the dev/test environment?My ideas:Install the ODX Server on the production environment. Rename the VM.Thanks in advance for your help and input!Kind regards,Tim

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

We are loading data from a SQL Server (onprem) to a Datalake (ingest instance). Data is stored as parquet, but TX is creating a huge parquet file for each table.  We are using ADF to ingest the data into the ingest instance.  Is there a way to load the data in such a way that when it gets into the Datalake the parquet can be divided in parts?  table_xxx_0001.parquet, table_xxx_0002.parquet, etc. (I know this is not the parquet format it is just an example).  Is this possible? We are having performance issues reading from parquet to AZURE SQL DB prepare instance.  We are using ADO.NET from ingest to prepare.

Note: allow access for *.timextender.com on Port 443 when using DNS.These are the IP addresses for mp77op1ebc.database.windows.net that require opening the firewall against:104.40.169.32/29 13.69.112.168/29 52.236.184.32/29 20.61.99.192/27For sql-exmon-prod-001.database.windows.net these are the addresses:104.40.169.32 13.69.112.168 52.236.184.32 20.61.99.192 20.61.99.193 20.61.99.197 20.61.99.194For login.timextender.com and other TimeXtender application webs, these IP addresses must be opened:List:51.144.255.199 23.97.164.251 51.144.177.38 104.46.50.208 52.232.109.41 13.69.68.16For Auth0 which is used for Authentication:18.197.9.11 18.198.229.148 3.125.185.137 3.65.249.224 3.67.233.131 3.68.125.137 3.72.27.152 3.74.90.247 34.246.118.27 35.157.198.116 35.157.221.52 52.17.111.199 52.19.3.147 52.208.95.174 52.210.121.45 52.210.122.50 52.28.184.187 52.30.153.34 52.57.230.214 54.228.204.106 54.228.86.224 54.73.137.216 54.75.208.179 54.76.184.103 Preferably all of these should be opened to

Hi,I have a question regarding history-enabled tables and slowly changing dimensions (SCDs). In my case, I have a specific store that recently changed its store name. In the transaction table, I want to keep the old store name for all transactions prior to 01.01.2023.The best solution is probably to introduce a history table with a Slowly Changing Dimension on the store dimension, right?Currently, my table is incremental, but once a week we perform a full load back to 2021 (a large amount of data). According to the article I read, I should add an additional join similar to the one shown in the picture below. However, in my experience, adding such lookups often makes the execution significantly slower.What do you think? Do you have any suggestions for a better approach, or is this perhaps already the best solution?I’m also wondering whether it would help to convert the transaction table (the fact table) to a proper history table instead of keeping it as an incremental table? The dimensi

Hi,i've got a couple of spreadsheets in a sharepoint folder that is would like to merge into one table in TX.I’m running TX V20.10.66.64i've setup a connection to the folder using provider TimeXtender Excel Data Source (16.4.20.0) and can see the files when i choose None for the aggragation option.When i select Files or Files & Sheets, no files are shown after running the sync or Transfer job.All files have just on sheet called 'Blad1’, the same amount of columns with identical names across the files. No tables are defined.What's misconfigured or going wrong?kind regards,Hans Zuijderwijk

Hi, I am trying to conect to an endpoint using a dynamic query parameter from a simple SQL query: SELECT       [CODE_ID] as codeId  FROM [dsa].[Products]I use {codeId} as value in the query parameter. When deploying, I get the following error: Format of the initialization string does not conform to specification starting at index 0.  When I hard-code the codeId, it works. Using this query does not work. There are around 600 codeId's in the query. Even when i limit it to 2 id's, it gives me the same error. My API documentation does not mention anything about extra parameters. Also, the logs do not give me much more information, other than the error I mentioned. Anyone has experience with this error and has a possible solution? Kind regards,René 

Hi,We are trying to access ODX execution history (backlog / queue / duration / errors) for log analytics purposes.We understand from documentation and release notes that the local ODX backlog (Backlog.sqlite) has been removed / moved in newer ODX versions, and that execution metadata is now handled differently.However, we are currently unable to locate where this information can be accessed programmatically.Additionally, in the TimeXtender Portal, we do not see the menu optionAdmin → Security / Permissions, so we are unable to: verify roles/permissions access or inspect the API for execution data Could you please help clarify: Where ODX execution history (status, start/end time, duration, errors) is stored in newer ODX versions Whether this data is accessible via: the TimeXtender Repository database, and if so, which tables/views are recommended the TimeXtender API, and what permissions are required Why Admin → Security / Permissions is not visible in our portal, and wha

In this article you will learn to make a Fabric Notebook accessible via the Fabric API, and run it through a Fabric Notebook package in TimeXtender Orchestration.In the Azure Portal, we need to create an App registration which we will use to access the Fabric Workspace. This is done under the Azure Portal -> Azure Active Directory -> App RegistrationGo to the Azure Portal Open App Registrations Select New Registrations Name your app and click Register The next window presents some key information that TimeXtender Orchestration will use to authenticate for later execution In the left panel, click Certificates & Secrets Then select New Client Secret Add an appropriate description and click Add at the bottom of the window Copy the secret value by clicking the Copy to Clipboard buttonAdd App Registration and user access to Fabric WorkspaceWith a Notebook already created under your Fabric Workspace you will need to grant at least Contributor access to the Workspace to a user that

When you have files in SharePoint, whether CSV, Excel, or similar, you can connect to them with our file-based Enhanced data sources.General connection settingsTo connect to SharePoint, you need to fill out the following options.SharePoint/OneDrive Client ID: Client ID of the service principal. SharePoint/OneDrive Client Secret: Client secret of the service principal. SharePoint/OneDrive Tenant ID: Tenant ID of the service principal. SharePoint/OneDrive Drive ID: Drive ID of the file location.To help locate this, I use Postman. I also use a collection. I attached it, but I can’t upload JSON files, so you will need to edit it to become a JSON file before you can import it.To import a collection, click the Import button in the upper left corner and locate the file.Once you have imported the collection to your workspace, you can set up the known variables.The SiteId and DriveId aren’t known at this time, so you can keep them empty for now.Regarding the Service Principal App. It is importa

Hi All,My current employer uses a DWH with a lot of views (with unions and so on), which leads to slow execution packages. I would like to enhance the performance (rebuilding the views is one thing). But i woud also like to enhance the performance with indexing. So i have setup up one of our Dimension tables as seen below:Is our SupernaturalKey (SNK) Are our PK'sWhat would you guys recommend? Which type of indexing for SNK (nonclustered, unique index, Columnstore Index, Clusttered ColumnStore Index)?Which type of index do you recommend for PK's (nonclustered, unique index, Columnstore Index, Clusttered ColumnStore Index) ? Which type of indexing SNK and PK in fact tables?  

Hello, Three of my collegueas where developing in our dev enviroment. And when trying to save the project, we got the error:An error occurred while saving the project to the database.An item with the same key has already been added.Detailed error:An error occurred while saving the project to the database.Er is al een item met dezelfde sleutel toegevoegd.Details:Er is al een item met dezelfde sleutel toegevoegd.Module: mscorlibSystem.ArgumentExceptionbij System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)bij System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)bij TimeXtender.DataManager.ProjectPerspective.AddProjectPerspectiveItem(ProjectPerspectiveItemsRow itemRow)bij TimeXtender.DataManager.Project.InitProject(Int32 version, DsProject loadDsProject, DataSet adaptersDataSet, ProjectsRow projectRow)bij TimeXtender.DataManager.Project.LoadProject(DsProject _dsProject)bij TimeXtender.DataManager.Project.<>c__DisplayClass136_0.<Load

Hi All,In TX 20.10.45.64 we would like to work with Work Items to prefent Project Locks. There is no option to Release the work item and make it green. I already tried:Deploy Execut Save and Reload the projectWe only have the option to update, edit or delete the workitem.  How do we release these items and make them green?