Skip to main content
To homepage To homepage

    Filter by idea status

    Filter by product

    863 Ideas

    peter.jensen
    TimeXtender Xpert
    peter.jensenTimeXtender Xpert

    Enable notification mails for object groups and processes in Process OrchestrationSUBMITTED

    Hi,In Process Orchestration it would be nice to have the option to setup notification mails (success and failure) on Object Groups and Processes.Now this is only supported on Package level.It might also be useful to have this option on each step / object of the object group.Gr.Peter

    0
    peter.jensen
    TimeXtender Xpert
    Forum|Forum|10 months ago
    wouter.goslinga
    TimeXtender Xpert
    wouter.goslingaTimeXtender Xpert

    Add incremental load option to TimeXtender REST APIIMPLEMENTED

    Currently, there is no option for incremental loading in the TimeXtender REST API. Most API's support partial loading with filters in URL params. We have multiple customers that are facing very long load times because all dat has to be fully loaded every day, while this is not necessary because most of the data has not changed.So, it would be very helpful if we could set up incremental loading the same way that this is done on rdbms data sources, so pass a date(time) or numeric value for incremental loading using REST parameters.

    10
    Forum|Forum|10 months ago
    Contributor
    KajEmergoContributor

    Service Principal access to (DWH) Azure SQL db with ADFSUBMITTED

    Hi,One of the latest features is that we can use Azure Entra ID Service Principals in order for TX to authenticate with DWH storage such as Azure SQL db. Last week I tried to use this but encountered this issue when deploying one of the data areas:  We will use ADF for data transfer from ODX (data lake) to DWH. Is this by design and will this be made possible in the future? The version of the TX implementation is 6675.2

    2
    Christian Hauggaard
    Forum|Forum|11 months ago
    MartinMemelink
    Contributor
    MartinMemelinkContributor

    Change Power BI Semantic Model deployment checkSUBMITTED

    Given that is now possible to edit Semantic Models in the Power BI service, I would suggest to change the differential deployment check that TDI performs on these endpoints, so the data structure of the model is compared against Power BI instead of (or next to) the repository.Currently, some issues arise through the following steps:A Semantic Model is changed by some business user in the Power BI service (tables, relationships or measures are changed, added or deleted) Differential deploy in TDI will then compare the endpoint against the repository to determine if changes were made. There are no changes detected (because they were made in Power BI and not TDI) so we get the ‘No changes to deploy’ window. Going through with execution in TDI is subsequently ‘succesful’ even though entire tables can still be missing in Power BI, and we would have no way of knowing this is the case.The workaround currently is to always force deploy an endpoint as this re-creates the Semantic Model in Power BI conforming to the definition in TDI. And of course making sure that Power BI workspace members never edit the semantic models. But I still believe TDI should handle the possibility with more clarity.So the idea is to change the differential deployment check, so the semantic model definition is compared against the actual target model in Power BI alongside the repository.Secondly there should be a failure notification when executing a model with missing tables in Power BI.

    0
    MartinMemelink
    Contributor
    Forum|Forum|11 months ago
    MartinMemelink
    Contributor
    MartinMemelinkContributor

    Add DAX User Defined Functions to Power BI Semantic ModelsSUBMITTED

    User Defined Functions were recently added as a feature of Power BI Semantic Models.UDF's can be created at Semantic Model level and reused in Measures and Calculation Groups.Adding this in TDI SSL's would be helpful in defining logic and calculations in a single place.Additionally it may be useful to have DAX snippets for these UDF's so a companies’ definitions can be re-used across SSL's in the same project.

    0
    MartinMemelink
    Contributor
    Forum|Forum|11 months ago
    Participant
    r.miltenburgParticipant

    Unique filename CSV endpointSUBMITTED

    Instead of using PowerShell script to create a new file for each execution, it would be nice to append a unique identifier (like timestamp) to the filename using the CSV endpoint.

    0
    Participant
    Forum|Forum|11 months ago
    andrew.gebhard
    TimeXtender Xpert
    andrew.gebhardTimeXtender Xpert

    Toggle ingest tasks on 'Generate End-to-End Tasks and Execution PackagesSUBMITTED

    Hi team, The tool for generating end-to-end perspectives and packages dynamically works well, but would be more powerful if the option to exclude creating ingest tasks when generating for a deliver instance. Use Case:Several delivery instances need tables dynamically included in a process Most delivery instances use many of the same dimensions Solution: create an execution package at Prepare with include steps of the ‘Dynamic’ end-to-end perspectives generated from the delivery instances.  Then generate ingest tasks from the consolidated, merged prepare packageAlways creating a separate ingest tasks for each delivery is cumbersome, and makes many tasks containing the same tables.  

    0
    andrew.gebhard
    TimeXtender Xpert
    Forum|Forum|11 months ago
    rvgfox
    Problem Solver
    rvgfoxProblem Solver

    Custom data selection rules on tables based on Parquet filesSUBMITTED

    What it’s the reason to this message:It would very useful to be able to do it.

    1
    Thomas Lind
    Forum|Forum|11 months ago
    devin.tiemens
    TimeXtender Xpert
    devin.tiemensTimeXtender Xpert

    Default deploy only modifiedSUBMITTED

    Hi,I was surprised that I couldn’t find this suggested as an idea yet, but it would be very helpful to have “Deploy only modified” selected by default, or at least to have the option to set this as the default at an instance/project level.I think most of us have forgotten to enable it at least once, resulting in every table deploying and executing.Kind regards,Devin

    1
    rory.smith
    TimeXtender Xpert
    Forum|Forum|11 months ago
    MartinMemelink
    Contributor
    MartinMemelinkContributor

    Merge/combine Prepare instancesSUBMITTED

    It would be very useful and time-saving if we were able to merge/combine two Perpare instances in the Portal.We are in the process of re-structuring Prepare instances for a client, and two of their subidiary companies’ data need to be put in the same database, which means two instances need to be combined into one. Both have the same data area names, which have the same schema names. For now we're unfortunately stuck with cloning one instance and integrating the other by completely rebuilding it. This will take a lot of time in an already time-consuming rework of the client's data estate.For this idea, the most basic version would allow us to merge instances with matching area's and schema's, where the objects within them could (hopefully) simply be put together.Maybe a more advanced workflow could even be possible, allowing us to map and rename the areas and schemas while performing the merge, like this: Object Source Instance Source Area Source Schema Target Area Target Schema 1 Prepare A Staging st DSA dsa 2 Prepare B Staging st DSA dsa 3 Prepare A Report rp MDW mdw 4 Prepare B Report rp MDW mdw  

    0
    MartinMemelink
    Contributor
    Forum|Forum|11 months ago
    Contributor
    wynkoopContributor

    Tabular Object-Level SecuritySUBMITTED

    Object-level security was introduced in the launch of Tabular 2017. This feature allows you to hide tables and columns from the end user.   The ability to hide columns and tables is vital if you need to do something like allow a salesperson to see their total sales, but hide the cost of the sale, which would also exist in the sales fact. Another critical example would be to restrict access to tables or columns that contain PII to managers or HR. In fact, I do not know how you can make a Tabular model GDPR or CCPA compliant without this feature, unless you exclude all PII entirely. There are hacky workarounds to get a similar effect with row-based security, but they only work with simple, small models. I think anyone who's building a serious enterprise solution with stringent compliance requirements is going to really want this feature.

    12
    rvgfox
    Problem Solver
    Forum|Forum|1 year ago
    andri
    Contributor
    andriContributor

    Change source table of a semantic tableSUBMITTED

    I've encountered this a few times where I need to change an underlying source fact table because of a design change in the development of a semantic model. Currently, you have to add a new table, configure all relationship again and create all measures again. This requires a lot of manual work that is prone to errors. Being able to substitute a source table with another table or a view with the same field names could be very useful.

    4
    Forum|Forum|1 year ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Automatically limit execution logging displays to the limits set in instancesSUBMITTED

    In the Ingest you can look at execution logging and specify in which timerange this can be done. Your Ingest instance will be limited to 90 days or less of logging but the calendar picker used allows you to go back much further.It would be better to limit this to the range of data available in the repo.

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    peter.jensen
    TimeXtender Xpert
    peter.jensenTimeXtender Xpert

    Autocreate a folder for each instance when syncing TDI in Process OrchestrationSUBMITTED

    It would be very helpful to auto-create a folder for each instance when syncing TDI in the TimeXtender Orchestration tool.  Certainly in a multi-environment setup (dev, uat, prd), where objects with the same name will appear multiple times in TX Orchestration.

    0
    peter.jensen
    TimeXtender Xpert
    Forum|Forum|1 year ago
    Visitor
    v.vanvendelooVisitor

    Feature Request: Bulk Changes for Duplicate Tables in Exmon MDMSUBMITTED

    Hi TimeXtender Team, I'd like to propose a new feature for Exmon MDM that would be more time efficient when working with large amounts of duplicate tables.Currently, when the same table is duplicated across multiple projects and categories, any structural or configuration changes (such as adding/removing columns) must be made individually in each instance. This is time-consuming, increases the risk of inconsistencies and is less thorough. Feature Request:Introduce the ability to apply changes to all duplicates of a table simultaneously or some kind of tool that realizes which tables are duplicates and can make changes to the tables.Benefits: Saves time and manual effort. Ensures consistency across MDM environments. Reduces human error and improves maintainability. We believe this could be a valuable improvement for many organizations using Exmon MDM at scale.Short term workaround:We'd like to know if there is a possible workaround to make the implementation of changes less time consuming or if a workaround can be made available in a short timespan.Thanks for considering this request, and please let me know if more details would be helpful. Best regards,Vincent van VendelooAccordis

    0
    Visitor
    Forum|Forum|1 year ago
    Contributor
    luuk.boumanContributor

    Handling JSON arrays in the table builderSUBMITTED

    Hi team, We've encountered that JSON with a nested array inside takes the lowest node of the XSLT generated by the table builder down to the level of said array, instead of keeping it at the desired base node. When running the generated XSLT in a table flattening endpoint the output does not reflect the actual data structure and number of rows of the input. Is it possible to implement a change in the table builder so that a nested array no longer "breaks” the data and keeps the base node at the "original” level? See the related for more detailed information. Best, Luuk Bouman

    1
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    Contributor
    emily.wynkoopContributor

    Add Automap to "Map Custom View Fields"IMPLEMENTED

    Most of the time, a field in a view will be called the same thing as the field it pulls from in the source table.  Adding an automatic map feature based on Name would make using Map Custom View Fields a lot easier and more friendly. 

    4
    devin.tiemens
    TimeXtender Xpert
    Forum|Forum|1 year ago
    Starter
    GiovannascStarter

    Global Parameter for PowerBI refresh packageSUBMITTED

    It would be a great idea of having the option to add a global parameter to the client secret in PowerBI refresh packages in TimeXtender DG. It is a lot of manual work to change it in every package when the secret client expires. 

    0
    Starter
    Forum|Forum|1 year ago
    devin.tiemens
    TimeXtender Xpert
    devin.tiemensTimeXtender Xpert

    Data Enrichment Projects dropdown button doesn't workSUBMITTED

    Hi, It seems not possible to close the below projects with the dropdown button. Looks like a bug, would be nice if this will be fixed.  

    0
    devin.tiemens
    TimeXtender Xpert
    Forum|Forum|1 year ago
    Explorer
    svaExplorer

    Fix issue "The table folder is used by another table" in ODX Data Lake (Azure, Parquet)SUBMITTED

    Hi everyone,I’m working with TimeXtender Data Integration version 6848.1 and my ODX storage is an Azure Data Lake using Parquet format. When I trigger a new reload from the source to the ODX (which should create a new incremental file in the background), I get the following error:The table folder 'x' is used by another table with the id 'y'I found this article that describes the issue:The table folder is used by another table The suggested solution there is to delete the existing folder in the data lake. Unfortunately, that’s not an option in my case because the source system only holds two weeks of data, while I have built up historical data in the data lake that I cannot afford to lose.This means every time I run a reload, the process fails as it tries to create a new incremental file for that table.Has anyone encountered this scenario and found a workaround that does not involve deleting the existing folder? Is it possible to remap the table or adjust the configuration so the historical data can remain and incremental loads can continue without conflict?Any advice or best practices would be greatly appreciated.Thanks in advance!

    2
    Christian Hauggaard
    Forum|Forum|1 year ago
    devin.tiemens
    TimeXtender Xpert
    devin.tiemensTimeXtender Xpert

    Improve Orchestrator - Error message in emailSUBMITTED

    Hi, It would be helpful to improve the error message of TX Orchestration in the email when a Package fails, mainly for PowerShell scripts. For example when a Powershell script fails, we receive an email from a package that failed, with an error message:"ERROR: Databricks job encountered an internal error” However, when we look in the portal log information, it provides a lot more information for debugging. Including this already in the email saves time and would greatly assist in debugging and identifying the source of the issue. Regards,Devin

    0
    devin.tiemens
    TimeXtender Xpert
    Forum|Forum|1 year ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Add an option to include a row number field in file-based data sourcesSUBMITTED

    CData connectors can generate a row number in their sources which can be extracted as a field. If you are converting from CData to TX native sources, this can be an issue if that field has been used as a primary key. It would be nice to have the option of including this kind of metadata as a field:row number path + filename of source file (useful for aggregating sources)

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    rvgfox
    Problem Solver
    rvgfoxProblem Solver

    Sort the list "Insert from table" in the Add Table Insert screenSUBMITTED

    As you can see in the image it’s crazy to find the table. It must be sorted: 

    0
    rvgfox
    Problem Solver
    Forum|Forum|1 year ago
    rvgfox
    Problem Solver
    rvgfoxProblem Solver

    View the include field in the Index Settings principal screenSUBMITTED

    It would be usefull to see the include fields in the screen:  

    0
    rvgfox
    Problem Solver
    Forum|Forum|1 year ago
    bas.hopstaken
    TimeXtender Xpert
    bas.hopstakenTimeXtender Xpert

    TimeXtender Business Central – SQL Server Connector: Azure Data Factory and Integration Runtime SupportSUBMITTED

    Currently, when using the TimeXtender Dynamics 365 Business Central – SQL Server connector, it is not possible to leverage Azure Data Factory (ADF) and Integration Runtime (IR) for connecting to this data source.This limitation means the connector can only be used when there is direct access to the Business Central SQL Server database. However, in some customer environments, direct access is not available/allowed. In such cases, the only option is to use the Azure Data Factory – SQL Server connector. Unfortunately, this alternative lacks key features provided by the Business Central connector, such as option fields, translations, and SIFT tables.It would be highly beneficial if both connectors could be combined to enable ADF/IR support while retaining the Business Central-specific features.

    0
    bas.hopstaken
    TimeXtender Xpert
    Forum|Forum|1 year ago

    Filter by product

    • All products
    • TimeXtender Data Integration
    • TimeXtender Data Integration Portal
    • TimeXtender Data Enrichment
    • TimeXtender Orchestration & Data Quality
    • TimeXtender Classic
    • Data source providers
    • Exmon
    Terms and ConditionsAccessibility statement