Recently active topics

Hi community,I created a role in the MDW and added Grant permission on one specific database schema. This schema contains some tables and some Stored Procedures. This role need to be able to select data in the tables and execute the stored procedures. I created my Object Security Setup using these settings:  When I login using SSMS (using the user in the role), I see the correct tables and I'm able to select data in the tables. But I'm not able to see the stored procedures. When I check the permissions on the ‘ExcelAddin’ database schema. Only the ‘select’ permission in granted. Is it possible to grant permission for ‘execute’ as well? Using TimeXtender?

Hi, I had scheduled a examination on the TDI today at 13:00 (swedish time).The only message i recieved was a message when click on the button as shown on the picture below.How will I be informed so I can begin the excercise today  at 13:00 (swedish time)? Best regards, Michael  Michael MüllerSenior ConsultantDirect: +46 31 710 41 23michael.muller@atea.seAtea Sverige ABMölndals Bro 5431 30 MölndalSwitchboard: +46 8 477 47 00atea.se   

The TimeXtender Gateway allows users to connect to their on-premise servers and data sources in the TimeXtender Orchestration and Data Quality cloud environment. By using TimeXtender Gateway you circumvent the need to open firewalls ensuring your intranet continues to be protected from outside traffic.Video TutorialA detailed tutorial into setting up the TimeXtender Gateway on client's infrastructure.Setting up TimeXtender GatewayOpen the TimeXtender portal URL in your machine environment browser. From the upper right corner, click your name and select Download TimeXtender Gateway Click the file you installed, called TimeXtender Gateway Installer.msi Now, open TimeXtender Gateway Right-click on the Execution Connection folder. Select New Execution Connection. Give the execution connection a descriptive name for the server you are installing the gateway on and click OK Note: Only one execution connection can be set up on each machine. Now your execution connection has been s

Today, we’ve published a minor release of the TimeXtender Data Integration that contains the changes listed below. We recommend that you upgrade if you’re affected by the issues that have been fixed.  FixedFixed an issue where data of the Sql Decimal type containing null values would fail for transfers to the Ingest Storage when using Parquet files as the output.  Fixed an issue where Selection Rules didn't work as expected on a Prepare Lakehouse. Fixed an issue where re-deploying measures and hierarchies in Qlik would time out. Fixed an issue where deploying a Tabular model to Azure Analysis Services would fail with a message saying a dll was missing. Fixed an issue where a sub query was used to get primary keys for incremental load when sub query is disabled for query tables. Fix primary key upload during incremental load with "handle deletes" enabled for data lake.

I’m getting a Lakehouse notebook execution timeout in v7142.1 after exactly 10 minutes.My connection and command timeouts in the TX portal are 1200 and 7200 seconds, respectively, for both Ingest and Prepare so that’s not the setting I need to change … and the workspace’s Spark timeout setting is 20 minutes so that’s also not the one.I’ve copied the relevant part of the error message below.Does anyone know how and where to increase the notebook timeout setting?(the Microsoft links aren’t that useful from a TDI perspective, I think) Start Time : 10/15/2025 2:23:08 PM End Time : 10/15/2025 2:37:01 PM on server: V171D008S -Execute Execution Package Default 'Failed'      An error occurred while calling o5570.throwExceptionIfHave.: com.microsoft.spark.notebook.msutils.NotebookExecutionException: Timeout when exe cell - 15 in notebook TimeXtender_PrepareKOMBI_TABLE_dsa_INVENTTRANS, code length = 39808 and it costs 600.001s. You can set timeout parameter to mitigate the issue. Please check th

In what version of Timextender is the existing Easy Connect provider replaced by the new TNS provider? We are running the older classic version 20.10.52.64   

Hello Community! Me and our developing team are getting pretty annoyedat the fact that it does not seem to be possible to duplicate process maps. Hence, when we want to create a process map similar to another one we will have to start copy-and-pasting elements from a process map into another, then start doing all the necessary adjustments, etc - which takes time.It would be much efficient to simply duplicate a process map and take it from there.Do any of you know how make this button clickable?What does enable it?Let me know if you have any advice or quick tricks!  TX O&DQ ‘duplication button’ I am referring to 

Today, we’ve started the rollout of the next release of TimeXtender Data Enrichment, v. 25.2, that contains the changes listed below.NewTimeXtender Master Data Management has been renamed to TimeXtender Data Enrichment Web URLs have been updated to use “timextender” instead of “exmon”. To access the web application, users will now go to {customer}.de.timextender.com instead of {customer}.exmon.com. Our login page login.exmon.com has been replaced with login.timextender.com, and even though login.exmon.com will continue to work we encourage you to use login.timextender.com from now on.ImprovedThe overview in User Configuration now shows the email of the users Better error message when app registrations for SSO did not have ‘Group.Read.All’ permission and user tried to search for Entra Groups in user configuration. Added support for more data types when importing a table from a database.  When clicking save after opening Database User Configuration, all users get Select permission to ‘ex

When working with cubes in TimeXtender, restricting access for certain users is a common security implementation. For example, salespersons might only need to see their own data and not the data of their colleagues. This guide explains how to setup security on cubes in TimeXtender ClassicContentsAdding Roles Dimension Security Multiple Environments Using background Processing Common IssueAdding rolesImportant: Security will not apply to any user that has Administrator rights on the OLAP server. These admin users will have full access to the data, even if you add them to security configuration. For TimeXtender Classic users, they must have admin rights to the OLAP Server in order to be able deploy and execute the cubes. Before security can be configured, the cube must first be deployed and executed. Afterwards, begin by right-clicking on the OLAP Server and go to Advanced → Access Control.In the dialogue that opens, rights can be setup for every object and value in the cubes.The first s

Today, we’ve released updated data source providers. See the changes below. Azure Data Factory - OracleVersion: 17.5.1.0 (TDI) / 10.4.5.0 (20.10 ODX)Switched to use v2 connector in ADF, since the previous one is being deprecated.Azure Data Factory - PostgreSQLVersion: 17.2.0.0 (TDI) / 10.4.5.0 (20.10 ODX)Switched to use v2 connector in ADF, since the previous one is being deprecated.CSVVersion: 23.15.4.0 (TDI) / 1.7.0 (20.10 BU) / 16.4.16.0 (20.10 ODX)Added support for handling multiple metadata URIs. Added trimming of long column names. Added culture settings when parsing numbers for metadata. Added support for FTPS location. Changed pattern matching for files to be case insensitive. Fixed issue with numbers parsed incorrectly with one decimal digit in some cases. Fixed issue with metadata URI handling for Sharepoint location.Dynamics 365 Business Central - OnlineVersion: 23.1.0.0 (TDI)Fixed an issue where the subtract value was not applied during incremental load.Exact OnlineVersion:

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 

In my TimeXtender Data Integration (Ingest) instance, data sources seem to be listed alphabetically. I’d like to set a custom order instead. I tried drag-and-drop, but it didn’t work, and I don’t see any option in the portal to reorder them.Is there a way to change the display order (e.g. sort settings, or another workaround)?If this isn’t supported, a confirmation would also be helpful. Thanks! 😊 

Need help with TimeXtender data transformation issue. We're pulling sales data from SQL Server but getting errors during the transform step. The source has decimal values but TimeXtender seems to be reading them as text.Also need to set up a simple incremental load based on ModifiedDate field. Should be 2-3 hours remote work to fix the data types and configure the incremental logic.Need working by Tuesday for our weekly data refresh.Please Contact Me Asap.

Hello,Is it possible to Extract data from an existing Lakehouse into a Prepare instance without needing to move it into the TimeXtender Ingest instance? The use case is to avoid replicating the data again, if the customer has already ingested data into a data lake or Lakehouse.Thanks in advanceTim

This article describes how to add a Qlik Endpoint to a Semantic model. For Qlik endpoints, the end product is a QVD file for each table in the model. QVD is a proprietary data format that stores data in a way that gives the best performance in Qlik apps. Since only Qlik applications can create QVD files, deployment and execution of Qlik endpoints will then create apps or scripts that a Qlik application can use to create QVD files.Note: If you are using SQL Server 19, ensure that version 18 (i.e. 18.x.x) of the Microsoft OLE DB Driver for SQL Server is installed on the Qlik Server (instead of version 19.x.x). Also if you have Qlik installed on a separate machine, and not on your application VM, then please ensure you have installed the Microsoft OLE DB Driver for SQL Server version 18.x.x on both the Qlik server and the application VM.Adding a Qlick EndpointTimeXtender Classic Semantic Models can include different types of endpoints. When creating a new Semantic Model, then you are prom

This adapter simplifies the extraction of data from Microsoft Dynamics GP.Suppose you connect to a Dynamics GP database as a regular data source. In that case, you will have to apply and maintain selection rules on all tables because different companies are stored in separate databases. With the TimeXtender Dynamics GP Adapter, you can select company accounts at a global level and apply a single set of selection rules. It is, however, also possible to overrule this behavior on a table-by-table basis.To Add a Dynamics GP Adapter To Set Up Dynamics GP Companies To Load and Select Data from Dynamics GP Data SourcesTo Add a Dynamics GP AdapterUse the Dynamics GP Adapter to load data from separate Dynamics company account databases into a single table.Open a business unit, right-click Data Sources, click Adapter Data Sources, and then click Add Dynamics GP Adapter. Enter a name for the adapter. In the Server name field, enter the location of the server where Dynamics GP resides. In the Dat

Hi, When trying to replicate the use of “Importing OpenAPI” from this TimeXtender Tuesdays video i get bellow Time Out error:  I am wondering if i am doing something wrong, or one could replicate this issue aswell.Regards,Devin

Today, we’ve started the rollout of the next release of TimeXtender Orchestration & Data Quality that contains the changes listed below.NewAdded support for setting the number of times a failed package should retry.  New schedule type - ‘Continuous’ - that starts a new execution right after previous execution finishesImprovedRedesigned the start page and fixed a bug where buttons/links did not always work.  Improved user experience and execution for Data Transfer merge. Added clearer error messages for the execution of Azure package types. Improved an error message shown when running an invalid Data Factory package. Removed the Subscription field from the Power BI Refresh package type UI, as it is no longer required. Web URLs have been updated to use ‘timextender’ instead of ‘exmon’ (i.e., https://dev.odq.timextender.dev/cmdservice/ExpectusCommandService.svc). In the Gateway desktop client, some paths in ‘ExmonClientConfig’ file is changed to ‘timextender’ (from ‘exmon’) during ser

This adapter simplifies the extraction of data from Microsoft Dynamics AX.AX is now called Finance & Operations by Microsoft and offers both an Online version and an SQL version for TDI.This is the Business Unit version of the SQL version of the Finance data source.If you connect to a Dynamics AX database as a regular data source, you will have to apply and maintain selection rules on all tables. With the TimeXtender Dynamics AX adapter, you can select company accounts at a global level. The adapter also extracts any virtual company accounts, including table collections, and tables that are set up in the source database. The information can then be used in dimensions and cubes.Furthermore, the adapter extracts all Base Enumerations and their associated labels and supports synchronization with the back-end application.Importing XPO Files into Dynamics AX Adding a Dynamics AX Adapter Adding a Microsoft SQL Server Provider Adding a Dynamics AX OData Provider Adding an Oracle Provide

I'm trying to connect to MongoDB and load data  into Timextender I have a ODBC driver setup, and test connection works. In Timextender I have ODBC Generic Data setup, and test connection works and to Synchronize Data Source works as well.But when I try to execute the data transfer from MongoDB into Timextender then I get an error.  

Today, we’ve released updated data source providers for TDI. See the changes below.OneLake Delta ParquetVersion: 23.3.0.0 (TDI)Added support for service principal authentication (remove non-MFA user). Fixed an error when workspace contains special characters. Fixed some performance issues on metadata extraction. Fixed the use of INT96 Timestamps for backwards compatibility. Removed: Authentication command and user/password settings.OneLake Finance & OperationsVersion: 23.4.0.0 (TDI)Added support for service principal authentication (remove non-MFA user). Fixed an issue when workspace contains special characters. Fixed an issue when company WHERE clause is empty. Fixed some performance issues on metadata extraction. Fixed the use of INT96 Timestamps for backwards compatibility. Removed: Authentication command and user/password settings.

Hi,TDI ver 7026.1TimeXtender Ingest Service Configuration 7017.1 We are using Azure Datalake Gen2 Storage Container as our Ingest instance. I have set a load job (incr_load) from a sql server database to the ingest instance.This works fine during the day. When get into the next day the same job does a full load on my tables in the database. Why is this happening?  I really need to solve this asap :-) regards,Bjørn A. 

PrerequisitesCreate an Azure App RegistrationThe App Registration should use the Microsoft Graph API with the following permissions:Finding the List IDUse Postman to find the Site ID. Use the Site ID to find the List ID. You can find these by using Postman and by looking at the Graph API collection Graph Fork. You can use the app to connect to this and locate the SharePoint folder under Application. In there you have two requests, https://graph.microsoft.com/v1.0/sites and https://graph.microsoft.com/v1.0/sites/{{SiteID}}/lists. Use sites to find the site ID and use the SiteID to find the List ID. You can also find the ListID by navigating to the SharePoint  list and then clicking List settings and then copying the ListID from the URL Use the TimeXtender REST data source connectionConnection SettingsUse the following Base URL (where {{SiteID}} is the Site ID found in Postman):https://graph.microsoft.com/v1.0/sites/{{SiteID}}/listsEndpointsCreate the endpoint using the following path (w