Skip to main content
To homepage To homepage

    Filter by idea status

    Filter by product

    859 Ideas

    P
    Contributor
    pontus.berglundContributor

    Visualize datetime fields correctly in the Query toolSUBMITTED

    Hi,The query tool incorrectly visualizes datetime fields as dates. We are using version 6346.1.The workaround for this problem is to either cast the field as a varchar, or to do the queries in SSMS.DW_TimeStamp has datatype “DateTime” but is being presented as a “Date” field in the Query tool In SSMS DW_TimeStamp is correctly presented as a “DateTime” field Appreciated if anyone had a look at this.Best,Pontus Berglund

    0
    P
    Contributor
    Forum|Forum|2 years ago
    KaiMueller
    TimeXtender Xpert
    KaiMuellerTimeXtender Xpert

    Include ODX in perspectivesSUBMITTED

    Hi,it would be great if we could include ODX instances in a perspective. Especially in a multi-developer situations where we have different ODX instances with distinct data sources for different developers it would be really helpful. CheersKai

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

    Do not force environments in the portal to be part of one OTAP flowSUBMITTED

    The new environment feature in the portal is very useful. Apart from making it visually clear which instances belong together, it also makes environment promotions a lot easier than before.There is a drawback to the current implementation though: each environment is expected to be part of a single linear chain: 1 → 2 → 3 etc. I think it would be useful to have the option to have multiple chains. You might require a separate setup for HR compared to other data but want to be able to manage them from one place.

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|2 years ago
    rvgfox
    Problem Solver
    rvgfoxProblem Solver

    Modeling degenerated dimensionsSUBMITTED

    I’m using the “Add junk dimension table” feature to create a degenerated dimension and store it the Invoice number for example.It works perfectly but it would be very useful to add in this feature the possibuility to “Add data selection rule” to filter the records to store on it. 

    0
    rvgfox
    Problem Solver
    Forum|Forum|2 years ago
    rvgfox
    Problem Solver
    rvgfoxProblem Solver

    Indexing internal primary keys tablesSUBMITTED

    I’ve seen that internally, TX creates tables to store the primary keys. If there are a lot off records:It would be better to create indexes on them as Azure recomends:   

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

    Generate documentation for project perspectiveSUBMITTED

    Add an option to generate documentation for a specific project perspective. 

    5
    K
    Contributor
    Forum|Forum|2 years ago
    devin.tiemens
    TimeXtender Xpert
    devin.tiemensTimeXtender Xpert

    Multi Environments with 2 ODXs on single serverSUBMITTED

    Hi, I was wondering if it is possible to setup Multi Environments with 2 ODXs with the newest version (6436.1) on a single server? If so, I assume that you have to create a second ODX service; one for e.g. development and one for production. In the 20.10 version you could fix this within TimeXtender via Tools -> Windows Service Setup -> Options -> Create service. However in the new version I cannot find this option.

    3
    devin.tiemens
    TimeXtender Xpert
    Forum|Forum|2 years ago
    K
    Contributor
    KajEmergoContributor

    Mapping set in combination with renamed fields in DSASUBMITTED

    Currently, a mapping set only works if you keep the fieldnames in your table exactly the same as they are in your ODX (i.e. names as they are apparent in your data source). Because these fieldnames may be very vague or long, you usually rename them in your DWH. Unfortunately, a mapping set is not able to cope with this. You will be able to accomplish something like that by manually adding a second mapping to a table in your DWH that has renamed fields using the 'smart synchronize’ option:Create the table in DSA by manually dragging the first ODX table to DSA Rename fields in DSA Add second ODX table to DSA by using ‘smart synchronize’I would like step 3 to be something like “Convert mapping to a mapping set and make sure it detects the currently mapped columns from ODX to renamed DWH columns”.For more information, please check my post on the community.

    0
    K
    Contributor
    Forum|Forum|2 years ago
    erik.van.mastrigt
    TimeXtender Xpert
    erik.van.mastrigtTimeXtender Xpert

    Group data sources in ODX ServerSUBMITTED

    In large environments the list of data sources in your ODX instance can get quite long. It would be nice to organize this better. For instance, I have a lot of Excel sources (which we want to get rid of, but that’s a different story) that make the list of data sources very long. Putting all of these into one folder/group would provide a much better overview of all data sources.

    1
    erik.van.mastrigt
    TimeXtender Xpert
    Forum|Forum|2 years ago
    mnoordam
    Contributor
    mnoordamContributor

    Object-Level Change Logging Linked to DevOps WorkItemsSUBMITTED

    Rather than aggregating changes at the project level, I recommend introducing a feature that enables detailed logging at the object level, akin to the functionality of the description field.We utilize the description field to meticulously track our modifications, and subsequently, these alterations are associated with the driving DevOps Workitem and visualised in a PowerBI report.This approach not only provides a comprehensive view of impending deployments but also chronicles previous modifications. By logging the initials of the developer alongside each change, we maintain a clear record of who made each alteration and their rationale behind it. This clarity is further enhanced when the change is directly linked to the work item, as it offers additional context and background information.For a more in-depth information on this topic, I invite you to read my LinkedIn article  

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

    Max the ODX Server Configuration window pop to the front not the backSUBMITTED

    Whenver I install the ODX Server I get slightly annoyed that the ODX Server Configuration tool window pops to the back (at least not to the front) requiring an extra click to pull it forward. Should be an easy fix.

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|2 years ago
    KaiMueller
    TimeXtender Xpert
    KaiMuellerTimeXtender Xpert

    Downgrade Option for Data Source Providers and/or show depencies to other componentsSUBMITTED

    Hi,the data soure provider upgrade button in the TX portal is a great feature.What is not so good, is that there are sometimes dependencies between a provider version and the installed TX/ODX version at the customer site. So when a customer accidentally upgrades the provider before he upgrades the TX version there might be problems.It would be great if there was also an option to “downgrade” to an older version or if the dependencies would be shown in a popup or somewhere in the data source.The best solution would be,that an upgrade is not allowed if the customer uses an incompatible TX/ODX version, but I don’t know if the installed TX version is stored in the repository in the cloud. Cheers,Kai

    0
    KaiMueller
    TimeXtender Xpert
    Forum|Forum|2 years ago
    rvgfox
    Problem Solver
    rvgfoxProblem Solver

    Execution of a job when one of the packages failsSUBMITTED

    I’ve detected that when I’ve a job that runs two packages:If the fist package fails it will run the second.In this case it’s not correct.There is some way to avoid it?

    5
    rvgfox
    Problem Solver
    Forum|Forum|2 years ago
    Søren Sørensen
    Contributor
    Søren SørensenContributor

    DowngradeSUBMITTED

    When upgrading v21, it would give peace of mind if it was possible to downgrade shortly afterwards.One option could be to keep the pre-upgrade repository available for e.g. a couple of weeks, allowing for an “upgrade cooling off period”.In v20 solutions, I always keep a backup of the repository before upgrading but that’s not an option in v21.

    2
    Søren Sørensen
    Contributor
    Forum|Forum|2 years ago
    sierd.zuiderveld
    Contributor
    sierd.zuiderveldContributor

    Give incremental executions a different color in the Gantt chartSUBMITTED

    In our favorite Gantt chart the execution step is always orange and the cleansing step is blue. A table insert has a different color, purple. I think it would make sense to show a difference between a full load and an incremental load in the Gantt chart. Perhaps make one of them yellow or darker orange.Like this: This would benefit beginners that have trouble figuring out why their transformation doesn't do any thing (see this nice meme by @rvgfox ) And it would also help in spotting executions that could be incrementally loaded, and other monitoring purposes.  

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

    Floating save button and index for Data Source ConnectionsSUBMITTED

    When setting up data source connections, especially for CData connections, there may be a large amount of settings. There is currently an index which really helps to jump down to the setting you want to change.This would be even better if the index floated on the left, so that you don't have to scroll up many pages. Similarly if you have changed a setting and want to apply it, you need to scroll all the way down to the Save button. If this floated at the top-right, this would be much easier to do.

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|2 years ago
    devin.tiemens
    TimeXtender Xpert
    devin.tiemensTimeXtender Xpert

    Job execution overview log with more than 20 tasks (possible bug)SUBMITTED

    Hi,There’s probably a bug within the Job Execution Log View. It looks like the bug happens when having 20 or more tasks (e.g. synchronize, transfer, cleaning) in 1 job. We have an example at a customer of us, but to be able to share some screenshots I just recreated the situation by adding 21 synchronize tasks of the adventure works database.When running a job with 12 tasks in it, I receive right Job Execution Log: Current job Execution log of the jobHowever, when I add in total 21 execution tasks, and execute it, I don’t get a status update in the job execution log, although that I know that it has completed successfully. This because I can see it on the execution log of the ODX. See the results below: Current job Execution log of the job Execution log of the ODX When changing the job again into 14 tasks I correctly receive a status in the Job Overview:Could you please have a look into this.Thank you in advance. Kind Regards,Devin

    0
    devin.tiemens
    TimeXtender Xpert
    Forum|Forum|2 years ago
    KaiMueller
    TimeXtender Xpert
    KaiMuellerTimeXtender Xpert

    Allow Partners to directly manage the data estate of their customers in the portalSUBMITTED

    Hi all,in our case we are always also the implementation partner for our TimeXtender customers. Which means that I am both the admin of our own data estate in the portal, as well as the customers data estate.Right now, I have to create a new e-mail alias for each customer and add me as a company admin/data estate admin and then open the portal a second or third time in an incognito browser to work on the customers data estate.It would be really helpful, if there would be a possibilty for a “context switch” in the portal. So I switch into a customers data estate via a drop down list of or customers or something similar.This would lessen the administrative effort by much and make the development for different customers much easier.Thanks for considering the idea!Kai

    0
    KaiMueller
    TimeXtender Xpert
    Forum|Forum|2 years ago
    sierd.zuiderveld
    Contributor
    sierd.zuiderveldContributor

    Synchronize all Mapping Sets at onceSUBMITTED

    When using mapping sets, is it possible to synchronize them all at once? Similar to how we can use “Synchronize with ODX” ? I noticed that changes do not show when we use “Synchronize with ODX” on mapping sets. 

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

    Be able to completely sign out of TimeXtenderSUBMITTED

    If you have MFA enabled, TimeXtender will not prompt you for user+pass but only for your MFA key on subsequent opening of the application. I guess the user+pass is coupled to the Windows user signed in, which is useful in most situations. If you have a machine with, for instance, local accounts (User1, User2, etc.) that are logged into by different TimeXtender Portal users they will not be able to pass the MFA challenge (someone else's key) and not be able to log out completely.Apart from the fact that this is very annoying, it should be possible to set an option to force a complete login and be possible to do a complete logout. Currently you only have MFA authentication the first time and single-factor in subsequent times at worst (depending on how people secure their on-time-pass device). This may be a hiccup that SSPs and partners can run into a bit more often than end-customers, but still something that should be smoothed out.

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|2 years ago
    wouter.goslinga
    TimeXtender Xpert
    wouter.goslingaTimeXtender Xpert

    Add option to create promotion jobsSUBMITTED

    When promoting an instance (copying for example from dev to prod), the datawarehouse instance needs to be copied and after that, all semantic models need to be copied one by one, which is a bit of a time consuming process.It would be nice to be able to set up some kind of promotion job in which you can add multiple copy to instance actions into one job and execute it.

    0
    wouter.goslinga
    TimeXtender Xpert
    Forum|Forum|2 years ago
    wouter.goslinga
    TimeXtender Xpert
    wouter.goslingaTimeXtender Xpert

    Collapse Data Sources nodes in ODX by defaultSUBMITTED

    In the ODX management pane, all Data Source nodes are expanded by default. After each refresh, all sources are again expanded which makes the screen somewhat cluttered.It would be nice if the data sources are collapsed by default, so they can be expanded when needed (like everywhere else in the GUI).

    0
    wouter.goslinga
    TimeXtender Xpert
    Forum|Forum|2 years ago
    erik.van.mastrigt
    TimeXtender Xpert
    erik.van.mastrigtTimeXtender Xpert

    Central management of ADF credentialsSUBMITTED

    Currently there are multiple places where you have to enter you ADF credentials. For instance:All ADF Data Sources: Storage Management Task for rolling up incremental data: Transfer ODX to DWH It would be nice to manage ADF instances/credentials on one central place, not on every single data source/task. ClientID/Secrets have a maximum lifespan of two years, which means a new secret has to be entered on multiple/many locations.

    0
    erik.van.mastrigt
    TimeXtender Xpert
    Forum|Forum|2 years ago
    P
    Contributor
    pontus.berglundContributor

    Add more operators to "Filter rows" on ODX data sourcesSUBMITTED

    Currently, the number of choices of operators is limited when filtering rows in ODX data sources.The available options can be seen in this screenshot: It would be great to have “greater/less or equal” in here as well. It would be even better if we write our custom filtering rules, like how we can set custom data selection rules on DW tables.

    1
    erik.van.mastrigt
    TimeXtender Xpert
    Forum|Forum|2 years ago
    wouter.goslinga
    TimeXtender Xpert
    wouter.goslingaTimeXtender Xpert

    Add option to allow NULL values in primary key columns in ODXSUBMITTED

    I have a source database that allows NULL values in primary key columns. What happens now is that these tables fail on transfer because the ODX server does not allow NULL values in key columns.I can of course override the key for the table but it is a key provided by the source database, and this also eliminates the possibility to set up an incremental load.Also, my general incremental load rule (this database has a change date column with the same name in every table) leads to a warning every time the table with the removed primary key columns is transferred.A solution would be to set an option to allow NULL values in primary key columns, or to be able to set a default value on columns.

    0
    wouter.goslinga
    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