Good day,I am afraid I have lost the MFA on my phone and I can no longer login in the TimeXtender App.Is it possible to have this reset? Kind regards,René
As your project gets larger and more data, transformations, and lookups are added, it is natural for deployment and execution times to increase.The Performance Recommendations Tool can be used to leverage a set of performance improving features that are available in the TimeXtender Classic Desktop. The Performance Recommendations Tool will analyze your project and recommend changes that may improve your project's performance. After running its analysis, the tool will present you with a menu of recommendations that you can then select to apply or not. These recommendations include the following:Merge all conditional lookups in a table: Sets the Merge conditional lookupsoption on tables to Merge all if possible (fastest). This can improve performance on tables with many conditional lookups with 20% or more. Use lookup operator None with joins other than Equal: Changes Operator option on lookup fields to None if the join on the lookup field does not use the Equal operator. This can improv
I am having issues with decimal numbers in my Power BI model created with TimeXtender XMLA endpoint (version 7026.1).No matter the precision of my datatype on SQL server it seems like all values are forced into a rounded 4 decimal size. Is there a setting hiding somewhere to prevent this behavior?Below are examples or test data to demonstrate the behavior.Inspecting the model with tabular editor it seems all decimal fields are stored as fixed decimal rather than the expected double Test data Result in Power BI
As projects grow, the increasing complexity can make it hard to keep track of all objects and their dependencies. To help you with this, TimeXtender contains four visualization features:Data lineage Impact Analysis Relation Diagram Data FlowThe relation diagram is only available on tables, while the other types can be used on most objects in TimeXtender.The purpose of data lineage is to show how objects gets their data, while the impact analysis feature clarifies how data is used. The relation diagram displays the relations that have been established to and from the table in question.Data Lineage Customizing the Display Impact Analysis Relation Diagram Data FlowData LineageRight click on an object, click Visualizations and the select the desired type of visualization. Selecting Data Lineage from the Visualization menu will provide a diagram similar to the following that traces the objects and their mapping from the beginning to the end of the project. Customizing the DisplayThe vi
Audits, regulatory compliance and similar purposes can require printable documentation of your project. Fortunately, TimeXtender lets you create full documentation of a data warehouse, a business unit or an entire project with a few clicks.The documentation comes in two flavors:Full documentation: Documents everything in the project so you would, in principle, be able to recreate the project from the documentation. This includes names, settings and descriptions for every object - databases, tables, fields, security roles, etc. - in the project as well as code where applicable. Data Impact documentation: Documents the impact of fields with a specific tag, i.e. where data from the fields are used in the project.You can customize the documentation in different ways. Content options - type of documentation, title, subtitle, logo - are saved in templates in the repository. Style options - colors, font, page orientation - are saved in the repository to be used for all templates.Adding or Ed
We have configured the orchestrion with Timextender Integration .all ingest task are running successfully.the prepared tasks are failing with the following error message. TimeXtender Data Integration failed to run taskLogfile output: 1:55:43 PM Selected timezone: W. Europe Standard Time (02:00:00)1:55:43 PM UTC now: 8/27/2025 11:55:43 AM1:55:43 PM TimeXtender Version 25.1.0.72 built 8/11/2025 9:50:00 AM. Running on vm-orc-prod-0061:55:43 PM PID: 40956 - Started with arguments: --startpkg 1261 --1:55:43 PM Connected at 8/27/2025 1:55:43 PM1:55:43 PM Flushing jobs in job queue that are not running on system1:55:43 PM 1:55:43 PM ** Executing package ExePkg_JC_Manual1:55:43 PM 1:55:43 PM Package finished in under a minute on last successful run1:55:43 PM 1:55:43 PM Adding task to job queue with PID 40956, UAT PROD, TaskId 1261 and TaskType EBI_PACKAGE1:55:43 PM Starting to execute the prepare package 'ExePkg_JC_Manual'1:56:05 PM Execution package completed with errors1:56:05 PM ### TimeXt
This adapter simplifies extraction of data from Infor M3, an ERP system previously known as Movex.Adding a Movex/M3 adapterOpen a business unit, right click Data Sources, click Adapter Data Sources and then click Add Movex/M3 Adapter. The Add Movex/M3 Adapter window opens. Click the database type of your M3 installation. You have the following options: DB2 Oracle Microsoft SQL Server Click OK. The standard window for adding a data source of the type you chose opens. Enter the connection details. See Adding a DB2 Data Source, Adding a Oracle Data Source and Adding a SQL Server Data Source for more information. Right click the M3 data source you just added and click Change Environment Schema. The Setup Environment Schema window opens. Type the environment schema name in the Name box. In the Available Objects list, click None to make no tables available for use in the project, Company Tables Only to make only tables from the chosen company available or All Tables and Views to make
Hi,I need to add authorization basic auth (username, password) to every endpoint in my rest api(Tripletex).I have added dynamic values from the endpoint “TokenSessionCreate Create” creating a session token.This token is my password and using a fixed username to every endpoint.In my endpoint “LedgerPosting” am using the section “Override Headers” to add the token to the “Authorization” and the value equal “Basic user:pwd”. Well, I cant get this to work.I proberly nedd to convert usr:pwd to base64 encoding….Does anyone have any suggestion?best regards,Bjørn A.
Database schemas allow you to apply a certain schema to a table or a group of tables. You can use schemas to e.g. restrict access to tables that report designers do not need, thereby making reporting off of the data warehouse easier.Schemas can be set on staging databases and data warehouses as well as data sources and individual tables. The schema settings are applied as follows: Table level settings take precedence over data source settings, which in turn take precedence over business unit/data warehouse settings.Adding a Database Schema to a Data Warehouse or Business UnitTo create a database schema, follow the steps below.On a data warehouse or business unit, right-click Database Schemas and click Add Database Schema. In the Name box, enter a name for the new schema. In the Owner box, you can enter the owning role for the schema. The default is "dbo". Click OK to create the schema. Assign a Schema Behavior by right-clicking on the newly created schema. You have the following option
Hi, I’m trying to connect to a API using Timextender REST version 7.1.0.0 but my result is only one row of data. In Postman I get much more data. It might be because the API returns JSONL and TX tries to handle it as JSON. I’m trying to convert it to Text but it still doesn’t work. Earlier I managed to complete the goal in Power Query even with pagination. Now I’ve hit a brick wall and I need your help to proceed. My result in ODX: My result in Postman:Here’s my connection profile:{ "Name": "MixPanel", "Description": "", "Provider": { "TemplateId": "d4aa4001-fd7b-4c65-b76d-f9710d551c1e", "DisplayName": "TimeXtender REST", "ProviderVersion": "7.1.0.0", "X64BitVersion": true, "ProviderType": 6 }, "RestProperties": { "Pills": [ { "Name": "Authentication", "Description": "Configure authentication settings to securely access the API using tokens, keys, or other credentials.", "Id": "rest-general-authentication", "IsSelected": true
SymptomsError while executing a PowerShell script via TimeXtender Orchestration. The script does not recognize exit codes correctly, leading to incorrect execution status.Error: PowerShell script exit code not recognized.CauseThe issue arises because TimeXtender Orchestration does not correctly interpret exit codes (exit 0 for success and exit 1 for failure) in PowerShell scripts.ResolutionTo ensure that the PowerShell script fails correctly, use the following syntax to trigger a failure:Replace exit 1 with throw "ErrorText"Steps:Modify your PowerShell script to use throw "ErrorText" instead of exit 1. This will ensure that TimeXtender Orchestration recognizes the script as failed when an error occurs.Reference Ticket33847Reference LinksExmon DG 5.8
Hi,i have a gen2 storage account with a blob container with multiple parquet files. when i do a sync with odx it’s succesfull, the transfer gives me for 4 files the message “ is used by another table”. all other files in the same map go ok. have tried to recreate the blob container, and recreate the parquet files again, same results.Exact message:The table folder 'parquet_taak_status' is used by another table with the id 9a510177-a130-4bcc-aaaa-5abefd42c1b9 how to solve / find the other table that is referenced to? thanks!
Customized Code and Custom Scripting can be incorporated into your Data Warehouse as needed, but should only be used when other TimeXtender Classic functionality is unable to accomplish your data sourcing and transformation tasks. Depending on how it is used, customized code may impact TimeXtender Classic’s ability to perform the following:Managed execution based on object dependencies. Code maintenance. Documentation. Data lineage.Custom Scripting supports User Defined Functions, Stored Procedures, Script Actions, Code Snippets, and Custom Code. Global Project Variables can also be created for use in custom scripts. The following is an outline of the functionalities that incorporates custom coding and scripts, listed out in the order of those that are relatively simple and easy to deploy, and ending with a more advanced section that explains how to add custom coding to the stored procedures and transformation views that create and comprise a data area table.Add a Custom View as a Tabl
Today, we’ve released updated data source providers. See the changes below.OracleVersion: 23.3.4.0 (TDI) / 1.1.1 (20.10 BU) / 16.4.3.0 (20.10 ODX)Improved handling of ‘raw’ fields.Oracle - Azure Data FactoryVersion: 17.3.1.0 (TDI) / 10.4.3.0 (20.10 ODX)Added schema and table filtering. Improved handling of ‘raw’ fields.TimeXtender Business Central 365 Data SourceVersion: 23.1.0.0 (TDI)Fixed bug where the batch number column was added multiple times.
Hi,I obtain a deployment error when I try to make my table historic. Computed column 'SCD Surrogate Hash Key' in table ' <mytable>' cannot be persisted because the column is non-deterministic. I think this has to do with the excessive amount of columns in the table: 695 columns, all varchar(2000). What confuses me is that when I set the hashing algorithms to debug, I still get the same error I don't have any transformations on this table, its a straight copy from to ODX. Is there a limit on the amount of fields a History table can have?
This article clarifies the concepts of slowly changing dimensions and explains how to implement a History table in TimeXtender Classic. What is SCD? SCD Types History Fields Example Instructions Enable History Configure Fields Additional Settings Surrogate Keys What is SCD?A Slowly Changing Dimension or SCD is a complex data warehouse pattern that maintains historical data for reporting even when this data is no longer available in the source. Consider this example scenario: You report on customer shipments. Unfortunately, your data source only supports a primary address for each customer and previous versions are not available. Subsequently, a customer moves to a new location and the account manager updates the customer address in the source system. The Data Warehouse is updated, but now the historical shipping records are pointing to the row in the customer table which has the new address, instead of the original address they were shipped to. By implementing a slowly changing d
To achieve the optimal performance on your data warehouse, it is important to have the right indexes on your tables. TimeXtender can generate the necessary indexes automatically or assist you in creating indexes manually. You can also choose to use a legacy approach to indexes instead.With the Index Automation feature, you can let TimeXtender handle all index creation and maintenance. Index Automation considers the following when designing indexes for the project:Relations between tables with relationship type set to Error or Warning Joins on conditional lookup fields Primary key fields (on the raw instance of the table) Selection rules on the data warehouse Incremental selection rules on the data warehouse Partitioning fields (DW_Partitionkey, DW_TimeStamp)Index Automation will try to minimize the number of indexes. If two lookups can use the same index, TimeXtender will take advantage of that. In addition to that, TimeXtender takes any manually created indexes into consideration. It
I am struggling with Circular References.Finished executing project 'Discovery_Hub' Execution Package 'Report Booking' Execution failed Start Time : 8/21/2025 11:52:42 AM End Time : 8/21/2025 11:52:42 AM on server: TX-SERVER-DEV -Execute Execution Package Report Booking 'Failed' 'Execute DSA DSA_F.Management Data Cleansing Rules' has a circular relation with the following steps: 'Execute DSA DSA_TX.sub_agrDIM_RentContract Data Cleansing Rules' 'Fill Aggregate Table DSA_TX.sub_agrDIM_RentContract' 'Execute DSA DSA_F.RentContract Data Cleansing Rules'The execution job Report Booking uses DSA_F.Management, but not DSA_TX.sub_agrDim_RentContracts.I have also tried excluding DSA_TX.sub_agrDim_RentContracts from the execution job, but it still fails. What i find strange is that when i run the following tables individually, i do not get any errors:DSA_F.Management DSA_TX.sub_agrDIM_RentContract Also, DSA_TX.sub_agrDIM_RentContract is not the part of Report Booking prespective Only when i ru
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
With the Any Source Adapter, you can connect to any data source that you have an OLE DB or ADO.NET provider installed on your server. Instead of waiting for us to create an adapter that enables you to connect to a specific system, you can now acquire a provider from the system developer or a third-party vendor.Adding a Any Source OLE DB or ADO.NET Data Source Specific guides for Any Source OLE DB/Any Source ADOAdding an Any Source OLE DB or ADO.NET Data SourceThe setup for the Any Source adapter is similar for the OLE DB and ADO.NET-based adapter. To add an Any Source OLE DB or ADO.NET data source, follow the steps below.Open a business unit, right-click Data Sources, click Data Sources, and then click Add Any Source OLE DB/ Add Any Source ADO.NET. The Any Source OLE DB/Any Source ADO.NET window opens. Any Source OLE DB Any Source ADO.NET In the Name box, type a name for the data source. In the Provider list, click the provider you want to use. In the property sheet, edit the set
If you need to connect to a text file or a CSV file, we have three options. Ideally, you would choose the enhanced option, but all three will be explained below.Adding a CSV data source Connection Settings Culture Setup Data Type Handling Header Setup Incomplete row handling Null value handling Adding a Text File Data Source Setup Columns Adding a CSV data sourceWe have released a CSV data source for the Enhanced data provider type. So this can be updated independently of TX classic. You can read about enhanced data types here.Once you have added an Enhanced Data source, choose the CSV provider from the list.Connection SettingsThis area is generally the same for all of the file-based providers, as the connection method is generally the same.You have this list of options to choose from.You can point at a file or a folder, but if it is a file, it needs to end in one of the included file types if you want to point at a specific file. Pointing at just the folder will make it attempt
Today, we’ve released a version of our OData data source provider for TimeXtender 20.10. The provider was previously only available for TDI.If you’re using the ODX and cannot see the new data source provider in the list, try restarting your ODX server service.ODataVersion: 1.1.1 (20.10 BU) / 16.4.2.0 (20.10 ODX)Initial release
I recently updated the connection provider version on Hubspot, also for ODX/TX, and I have a problem getting the custom objects in. I checked, they still exist, postman can access them without issues, but I get errors when trying to get them to TimeXtender. Error messages as below:
A view is a virtual table in your data warehouse or in your staging database where you can group together information from two or more tables in your data source. Views can, for example, be used to provide a user with a simplified view of a table or to limit access to sensitive data.In TimeXtender, you can add 'regular' views with code generated by the software or custom views where you write the SQL that creates the view yourself.Creating a View by dragging a table onto the Views node.A quick way to create a view is to simply drag a table from your data warehouse onto the Views node. After dropping the table on the Views node, a dialog box will appear where the View Name should be entered.After entering the name and clicking OK, the Create View dialog will appear with the SQL Code already prepopulated and all of the fields and tables in that code already paramterized.At this point, you can continue to amend the SQL code and add parameters as is appropriate. For example, you can create
Important information regarding TimeXtender 20.10 (V20), TimeXtender Data Integration (TDI), and TimeXtender Classic (V25 / Classic)This post gives you the what's and when's and how's.Announcing TimeXtender Classic (V25): A Focused Solution for On-Premises Data WarehousingWe are excited to announce the upcoming release of TimeXtender Classic (V25), the next phase in our journey to provide world-class data solutions. This release reflects our commitment to providing a reliable product for organizations prioritizing traditional, SQL-based, data warehousing. We will continue to provide support as well as feature improvements for this product designed to work either on On-Prem SQL Server or Azure SQL Database environments. TimeXtender Classic (V25) will be released by the end of Q2 2025.Streamlined Data IngestionTo align with TimeXtender Classic's focus on simplifying operations for on-prem environments we have made the decision to deprecate the Operational Data Exchange (ODX) from this ed
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
