Skip to main content
To homepage To homepage

    Filter by idea status

    Filter by product

    859 Ideas

    F
    Starter
    f_keferStarter

    Add logging to new TX Data Sources (Excel and REST)SUBMITTED

    Hi all,I tried the new TimeXtender Data Sources (Excel and REST) and noticed, that there is no option to create a log file anymore. Especially when using a REST source with pagination the log file helped me a few times to identify problems.Will the log feature be implemented in the near future or is there a new possibility to write logs?

    1
    Christian Hauggaard
    Forum|Forum|1 year ago
    tito.paterson
    Starter
    tito.patersonStarter

    Ingest instance to all for cross domain authentication of usersSUBMITTED

    As part of our offerings, we have a managed service where we have a set of boxes on one for the Ingest instance and TimeXtender Data Integration (TDI) application on one domain, but also have SQL servers on a different domain. We utilize a specific user for monitoring but because we haven’t added it into the “Roles” part of the Ingest instance in TDI, the permissions for the user keeps on getting removed. It would be good for the Ingest instance to look across domains.  

    3
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    S
    Starter
    stijn.vannieuwenborghStarter

    Clone dimensions within and between semantic modelsSUBMITTED

    When creating a tabular model, I might use the same DWH view twice. E.g. when creation a supply chain model, there should be a 'shipping location' and a 'receiving location' with both dimensions built on the same DWH view 'locations'. Once one of both dimensions is built in a tabular model, it would save time when one could just copy/paste the dimension and just change the name (besides the name, both dimensions are identical).

    8
    R
    Forum|Forum|1 year ago
    helgi
    TimeXtender Xpert
    helgiTimeXtender Xpert

    Display Execution Job in Alphabetical OrderSUBMITTED

    For TimeXtender SaaS packages the Execution Jobs show up in random order. I would suggest it to be in Alphabetical Order

    0
    helgi
    TimeXtender Xpert
    Forum|Forum|1 year ago
    K
    Contributor
    KajEmergoContributor

    Use Service Principal authentication in combination with ADFSUBMITTED

    Since version 6675.2 it is possible to use a Service Principal for authentication on SQL databases:“You can now use Windows, Entra Password, Entra Integrated, and Entra Service Principal authentication for ODX SQL storage in addition to the existing SQL Server Authentication.”However, when you are using ADF for data transfer from ODX to DWH it is not possible to authenticate using a Service Principal. You would get this error:I would like to use a Service Principal in combination with Azure Data Factory too. 

    0
    K
    Contributor
    Forum|Forum|1 year ago
    R
    Participant
    RobertUParticipant

    Add a sort option when selecting columns in Ingest instance data sourceSUBMITTED

    When selecting columns for an Ingest instance data source a sort option is missing when you click on Schema, Table or Column. Especially that last is really needed.  

    0
    R
    Participant
    Forum|Forum|1 year ago
    R
    Participant
    RobertUParticipant

    Be able to overwrite datasource when using clone in TX DesktopSUBMITTED

    I want the cloning of a datasource connection to be able to overwrite the current one if it already exists.We have 30 companies with the exact same Business Central setup. Right now when i want to add a table or a column i have to manually add them to each datasource. When initially setting it up i made one and then cloned that one with all the selected tables and columns.   

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

    Issue with change of schema name with conditional lookupSUBMITTED

    Hi,I just discovered that when you have a table (let's say Table A) and another table (Table B) has a conditional lookup from Table A, then when changing the schema of table A won't lead to a red table nor a differential check of table B. Hence by means of differential deployment only Table A will be deployed, there where Table B also needs a deployment.I think it would be wise to fix this, since this can cause unexpected execution failures.Kind Regards,Devin

    0
    devin.tiemens
    TimeXtender Xpert
    Forum|Forum|1 year ago
    andrew.gebhard
    TimeXtender Xpert
    andrew.gebhardTimeXtender Xpert

    Always add storage management task to new data sourcesSUBMITTED

    When creating a data source, a synchronize task is automatically created and you are prompted to set up a transfer task. Storage management tasks may be the most important task of all, and i.m.h.o should automatically be added to every data source or the user should get a prompt to add one. I have seen several clients now with endlessly growing ODX storage because they have no cleaning tasks and are unaware that transfer tasks are cumulative. Kind regards,Andrew

    3
    rory.smith
    TimeXtender Xpert
    Forum|Forum|2 years ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    See more detail in Exmon Orchestration for TimeXtender executionsSUBMITTED

    It would be great to be able to differentiate between different types of activity in the execution logging in Exmon Orchestration. At the moment you can only see complete runtimes of TimeXtender jobs, this includes some different types:Queue for ExecutionEngine slot Queue for ODX source slot Transfer Cleanse Etc.As discussed here: Allow multiple jobs to be run concurrently | Community (timextender.com) you can currently wrongly assume an Execution is slow when it is simply waiting for another Job to finish

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|2 years ago
    tito.paterson
    Starter
    tito.patersonStarter

    Grouping data source connections in the portalSUBMITTED

    So when working on the data sources in the portal, especially where we have multiple data sources. For example. I would have multiple SQL connections to different databases then different REST API connections. It would be good to either group them up by connection type and or client just like how the environment feature would be.This is an example of multiple REST API connections 

    0
    tito.paterson
    Starter
    Forum|Forum|2 years ago
    bas.hopstaken
    TimeXtender Xpert
    bas.hopstakenTimeXtender Xpert

    Be able to set display name in Business UnitSUBMITTED

    In ODX Server, it is possible to have both a Display Name and a Short Name (DW_SourceCode). In Business Units, you only have a Short Name (DW_SourceCode).One of our customers decided to use Business Units instead of ODX Server in TimeXtender Classic because ODX Server in TimeXtender Classic will be phased out. Now, we need to be very creative with the data source names in Business Units, as we can only use a maximum of 15 characters.It would be great if we had the option to set both a Display Name and a Short Name in the Business Units as well.

    2
    bas.hopstaken
    TimeXtender Xpert
    Forum|Forum|2 years ago
    R
    Participant
    RobertUParticipant

    Be able to select which environments you see in TimeXtender Data Integration appSUBMITTED

    When working with multiple environments you see all the environments (for instance DEV, TST and PRD) in the same screen. That could potentially lead to by accident start developing in the production environment.It would be nice to be able to select which environments are currently visible in the desktop even when you are admin. 

    1
    rory.smith
    TimeXtender Xpert
    Forum|Forum|2 years ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Be able to resize the source selection area when selecting data from the Ingest instanceSUBMITTED

    Currently the data selection area in the Ingest instance, where you select which source to look in when you want to map data from the Ingest instance to the Prepare instance is fixed in size. This becomes difficult when you have more than a few sources. Please size the windows according to the number of sources and give the user the ability to resize this. 

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|2 years ago
    Søren Sørensen
    Contributor
    Søren SørensenContributor

    Field mapping for data lineageSUBMITTED

    One of my customers operate with a virtualized data warehouse, i.e. their “gold” tables are in fact rather complicated views. They showed me today how they use kada.ai to establish data lineage (outside TX).It would be nice to have automatic mapping of view fields in TX … whether we develop it in-house or enter into a commercial arrangement with someone like kada.ai like what we’ve done with CData.It would also be nice to be able to override field mappings on tables, e.g. if a field gets updated by a script.

    3
    daniel
    TimeXtender Xpert
    Forum|Forum|2 years ago
    daniel
    TimeXtender Xpert
    danielTimeXtender Xpert

    Temporary Perspective on selected TableSUBMITTED

    To improve the possibility to do impact analyses and make searching and finding easier I would like a funcionality withing the Perspective menu which is available when right clicking the table.this functionality should temporarily create a dynamic perspective on a table and show all the tables it is connected to in each of the data area's.I find it easier to wor through the perspective then through the impact analyses / data flow / data lineage. 

    0
    daniel
    TimeXtender Xpert
    Forum|Forum|2 years ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    When dragging a table into a Deliver instance do not select System Fields by defaultSUBMITTED

    When I am building Semantic Models, in about 9999 out of 10000 cases, I do not use the Prepare instance System Fields in the tables I add to a deliver instance. It would be great if those four fields are deselected by default in the field selection interface.Additionally having an option to turn the adding back on would, off course, be great.

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|2 years ago
    bas.hopstaken
    TimeXtender Xpert
    bas.hopstakenTimeXtender Xpert

    Add icon in front of table to indicate if Pre/Post scripts, Custom Data or Table inserts are usedSUBMITTED

    Currently, it's challenging to determine if Pre/Pro scripts, Custom Data, or (Custom) Table Inserts are used in a table. I currently use descriptions to indicate this information. However, it would be better if these details were displayed using icons on the table, similar to how the Date table and Aggregate Tables are shown.This idea builds upon a idea previously proposed.  

    0
    bas.hopstaken
    TimeXtender Xpert
    Forum|Forum|2 years ago
    bas.hopstaken
    TimeXtender Xpert
    bas.hopstakenTimeXtender Xpert

    Do not open the Ingest instance tab with data sources expanded by defaultSUBMITTED

    When you open the Ingest instance  tab, all data sources are expanded by default. This can look messy if you have many data sources and tasks.You can easily collapse them by using CTRL + left arrow, but it would be better if all data sources were collapsed by default when opening this tab.

    0
    bas.hopstaken
    TimeXtender Xpert
    Forum|Forum|2 years ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Improve relation diagramSUBMITTED

    Hi,when looking at your MDW relations it is often useful to use the Relation Diagram, for instance from a Fact table, to see what tables are linked together.Usually you are interested in the tables linked to the table you are looking at as well as what field(s) are used to form the relation. In the current Relation Diagram, all tables are fully expanded and there is no indicator on what fields form the relation.My suggestion would be to add (at least) two improvements:collapse related tables by default - I want the table I am generating the diagram from expanded, all others collapsed. See the screenshot below for an example. Add a setting to influence this. add a visual indicator to fields involved in the relation. Ideally I would like to see the collapsed tables show only the keys fields. Add a setting to influence whether relation key fields should always be shown, all fields should be shown, or fully collapsed.  

    2
    rory.smith
    TimeXtender Xpert
    Forum|Forum|2 years ago
    daniel
    TimeXtender Xpert
    danielTimeXtender Xpert

    Automatic archiving functionalitySUBMITTED

    Dear all,Some clients have a lot of data. some of the data is from 2010 or even earlier.Each day my ODX or BU runs, it has to check ALL the PK's for changes and this takes a long time.I've created some scripts / SQL snippets and whatnot to just load the current year (current and last year) and then eventually bringing them together in the semantic layer.It has become quite complex for these big tables because I'm load two seperate tables, but want to make sure that they both get the same transformations and business rules and I do not want to maintain two seperates pieces of script (because mistakes are easily made).What I propose is a functionality which let you choose which data from the source or DWH tables to refresh / check in the incremental load and stuff and which data in the table to ‘archive’ and only load when explicitly asked for (full load, manual stuff). So in TX you are handling one table and one script and one custom transformation but are governing the current table with the data you want to reload or have checked every day and one archive table which contains all the history which does not have to be checked or loaded each day.

    1
    rory.smith
    TimeXtender Xpert
    Forum|Forum|2 years ago
    avanrijn
    Contributor
    avanrijnContributor

    TimeXtender as a SAAS as a Workload in Microsoft FabricSUBMITTED

    Dear Sir,I know it sounds like a dream:TimeXtender as a SAAS as a Workload within Microsoft Fabric.Workloads has just been announced by the Fabric Team, so it is now possible to bring Microsoft analytic partners inside the Microsoft Fabric environment.This sounds like a win 😉 win situation for everybody.Regards from Amsterdam,Arthur

    1
    avanrijn
    Contributor
    Forum|Forum|2 years ago
    M
    Starter
    mikeschipperStarter

    Make table red when releasingSUBMITTED

    As in the legacy version when releasing the project all tables that changed are marked dirty (red). When releasing in the new version (TimeXtender 6675.2) this does not happen, no tables are marked even though they have changed.

    0
    M
    Starter
    Forum|Forum|2 years ago
    coen.donders
    TimeXtender Xpert
    coen.dondersTimeXtender Xpert

    Sort fields in Data Movement section in Alphabetical orderSUBMITTED

    Please order the fields in Alphabetical order. We see that fields are now ordered randomly. Not Alphabetical nor as sorted in the source.This makes it hard to find fields in large tables

    0
    coen.donders
    TimeXtender Xpert
    Forum|Forum|2 years ago
    erik.van.mastrigt
    TimeXtender Xpert
    erik.van.mastrigtTimeXtender Xpert

    Use Instance Variables on data selection rules from Ingest instance tablesSUBMITTED

    Currently it is not possible to use instance variables on a data selection rule, if the table comes from an Ingest instance.We use this a lot in TimeXtender Classic (with business units), to reduce data that has to be processed towards a Deliver instance. For example: only data from the last two years.Would also be helpful if variables can be used in Ingest instance itself, see Current workaround is that we hard-code most of them, which is not really what we want :)

    0
    erik.van.mastrigt
    TimeXtender Xpert
    Forum|Forum|2 years 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