Skip to main content
To homepage To homepage

    Filter by idea status

    Filter by product

    859 Ideas

    P
    Contributor
    pontus.berglundContributor

    Expand "override data type" functionality in ODXSUBMITTED

    My client has a data source where all the string fields have data type char.They would like to change the data type to varchar for all those fields, but keep the original character length limit. I.e. char(10) → varchar(10), char(255) → varchar(255).To do it in the current version of the ODX they would either have to create one rule per data type which is not feasible, or convert the fields to a large enough varchar that all the char fields would fit which is not optimal.They would like to have a feature where they can set that char(X) → varchar(X):

    0
    P
    Contributor
    Forum|Forum|3 years ago
    P
    Contributor
    pontus.berglundContributor

    Show tooltip when hovering over conditional lookup fieldsSUBMITTED

    In version 20.5.7.64 a tooltip showing detailed information about a conditional lookup field would show up when hovering over the CL field, see screenshot:This feature is really useful to get an overview of tables with many conditional lookups, and especially many “multiple conditional lookups”, without having to drill down inte every single field.This feature has been removed in later versions. It would be great if it could make a comeback in version 6XXX.

    3
    P
    Contributor
    Forum|Forum|3 years ago
    Niels Jonker
    Contributor
    Niels JonkerContributor

    Select tables - remove from list on left when added in selectionSUBMITTED

    Hey,  I use the select tables feature a lot and I find it confusing that when I add a table from the total list on the left it will show in the selection but it is not removed from the list on the left. It would be much easier to check and use if the tables that you added are removed from the list on the left  

    1
    Jan Stroeve
    Contributor
    Forum|Forum|3 years ago
    Jan Stroeve
    Contributor
    Jan StroeveContributor

    Streamline SQL Formatting: Enhancing Code Readability and Coding EfficiencySUBMITTED

    Integrate a feature that enables instant formatting of poorly structured SQL code, similar to the functionality available at https://poorsql.com/.Please refer to the following link for a resource that can assist in achieving this: http://architectshack.com/PoorMansTSqlFormatter.ashx.This enhancement would prove valuable, particularly when dealing with views and stored procedures.

    0
    Jan Stroeve
    Contributor
    Forum|Forum|3 years ago
    anders.e.jonsson
    Contributor
    anders.e.jonssonContributor

    Same e-mail address for logging in to several customersSUBMITTED

    Hi,It would be nice if a partner has the possibility to use the same e-mail address for logging into their own portal, and for all customers.In practical terms, you could perhaps have a drop down in the login where you choose a customer, or your own portal.It would make it easier for consultants who work with several clientsBRAnders

    2
    anders.e.jonsson
    Contributor
    Forum|Forum|3 years ago
    devin.tiemens
    TimeXtender Xpert
    devin.tiemensTimeXtender Xpert

    Add dynamic project perspective based on impact analysisSUBMITTED

    Dynamic perspectives are always based on data lineage. It would be great to have an option to create a dynamic perspective based on a bottom up approach (impact analysis). This way it becomes possible to create e.g. project perspectives per data source or schema. 

    2
    devin.tiemens
    TimeXtender Xpert
    Forum|Forum|3 years ago
    rvgfox
    Problem Solver
    rvgfoxProblem Solver

    Centralize the guarding optionsSUBMITTED

    It would be usefull to centralize both options, guard of development and guard of execution, for all tables in one screen to be quicker to enable it or disable it.

    1
    devin.tiemens
    TimeXtender Xpert
    Forum|Forum|3 years ago
    W
    Visitor
    Wouter

    Improved visuabillity for fields and tablesSUBMITTED

    Hi All,Ik would like to see an improvement on the general visuabillity in Timextender of tables and fields. Having a large set of tables en fields makes it hard to keep an overview of your project.There are already some some things that mark tables and fields, like lookup fields that are marked red and aggregate tables that are yellow.  But a greater set of icons and colors to identify certain properties and changes would make it a lot easier to keep track of the changes that were made.I think the preferences should be adjustable in a settings menu so each user can decide if they want to use these functions or not.Some Ideas:Make it possible to group tables and ident the tables in the groups. Maybe even the possibility to make groups of fields inside tables. Group A Table1 Table2 Group B Table1 Table2 Show if fields have transformations using colors or icons. I think this is a really important one.  In aggregate tables the transofmration fields have a pruple color so you can easily recognize them. Show if fields have a field validation using the icon of the validation used below. Show when there is a data selection rule on a table. Now you can only see if the is a selection rule if you open the mapping and the specific field.Tables that have table inserts. Tables that have custom data

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

    Have the database cleanup wizard split entries over Data AreasSUBMITTED

    The current database cleanup wizard for DWH instances looks across all Data Areas in the instance and lists any objects that seem eligible for removal. This is useful in many scenarios, but I think it would be good to have the following enhancements:make nodes in the hierarchy for each Data Area and list items under those make it possible to run the cleanup from a Data Area only for items in that Data Area

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|3 years ago
    P
    Contributor
    pontus.berglundContributor

    Make it optional to filter rows in ODX without specifying table namesSUBMITTED

    Please make it optional to filter rows in ODX without specifying table names. In this example, I would like to filter all tables with the column “CreatedDate”:  The workaround I currently use is to set the “Table operator” to “Not equal” and writing an “x” as the value, which is not the most elegant solution: 

    2
    P
    Contributor
    Forum|Forum|3 years ago
    devin.tiemens
    TimeXtender Xpert
    devin.tiemensTimeXtender Xpert

    Change Query in Query tool -> Every column on a new rowSUBMITTED

    Hi,Is it possible to change the "SELECT FROM” fields in the query tool, to a script with each field on a new row, as shown below? This improves in my opinion the visibility and makes it easier to change the script.  Regards,Devin

    0
    devin.tiemens
    TimeXtender Xpert
    Forum|Forum|3 years ago
    andri
    Contributor
    andriContributor

    More structured results in the searchSUBMITTED

    I would like to see the search result displayed with a column for the layer (ODX,Stage,DW) and the table name. A type (field, lookup, super natural key) column could be useful too for sorting/grouping the results.  I also think it would be more relevant to only display fields and tables by default, and have additional checkboxes to include "Copy's", "Conditions" and other stuff.

    3
    devin.tiemens
    TimeXtender Xpert
    Forum|Forum|3 years ago
    brian.wijnings
    Explorer
    brian.wijningsExplorer

    custom data selection in valid table instead of in rawSUBMITTED

    Option to select Valid or Raw by a custom data insert on a table. If we do a Inner join (error) to a table where no custom data exists then the custom data record will not be visible. Now we have to create a custom data record also in the lookup table where we use the error join.  Would be nice that we can select where we want to insert the custom data because if we choose the valid this will be visible then.   

    0
    brian.wijnings
    Explorer
    Forum|Forum|3 years ago
    Niels Jonker
    Contributor
    Niels JonkerContributor

    Add DW_SourceTable field to system field by default or enable/disable per data areaSUBMITTED

    I would love to by able to enable the source table field by default for my entire project or per data area. Currently I have to enable it per table which is not optimal. So my suggestion is to add it to system fields by default just instead of adding it via the advanced table settings.

    0
    Niels Jonker
    Contributor
    Forum|Forum|3 years ago
    J
    Starter
    janwillem.kuperStarter

    DW_SourceTableSUBMITTED

    Is it possible to add a field DW_SourceTable in the default fields, so you can trace in the data were this is coming from. At a project I have database names like below: 6401 - Company 1$Appointment6401 - Company 2$Appointment6409 - Company 1$Appointment

    6
    Thomas Lind
    Forum|Forum|3 years ago
    coen.donders
    TimeXtender Xpert
    coen.dondersTimeXtender Xpert

    Use Smart Synchronize by default when mapping tables from ODXSUBMITTED

    in version 6024.1.When you are mapping tables between the ODX and a data warehouse layer we mostly use the Smart Synchonize option. You have to drag-n-drop with the Right mouse button to use the Smart synchronize. To use the Left mouse button is more intuitive but this triggers a full sunchronize. Is it possible to Smart Synchronize by default when mapping tables from ODX? And use the Left mouse button for this?

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

    Add Logging for RetriesSUBMITTED

    Sometimes we face issues with connectivity to Azure SQL Database during overnight executions. Sadly not all of them are reported by Microsoft, but sometimes resource health issues can be found in Azure Portal. For instance: In such cases, a typical error message in TimeXtender will say ‘Physical connection is not usable’.A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)Module: .Net SqlClient Data ProviderSystem.Data.SqlClient.SqlException As Microsoft also suggest, we use the retry function on TX execution packages: So when Azure SQL Database fails, I expect TimeXtender to initiate a new attempt after three minutes of delay. However, there seems no place/log where I can check if a retry actually happened. Following the execution logs, I have a strong feeling that the execution stopped after the first error. In this example we use TX 20.10.39 with Business Units and CData CSV provider 22.0.8417.Did TX actually perform a retry, and where to check?

    10
    Christian Hauggaard
    Forum|Forum|3 years ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Custom View / Stored Procedure dialogues should not require CREATE syntaxSUBMITTED

    When you create a custom view in TX that is not created from a table you have to remember to start with the CREATE VIEW [schema].[view name] AS syntax and match the view name in the syntax with the view name above. This could be 100% automated, reducing the possiblity of errors.The same situation exists with Stored Procedures.

    1
    peter.jensen
    Forum|Forum|3 years ago
    Niels Jonker
    Contributor
    Niels JonkerContributor

    Replace GIFs with Videos in articles and trainingsSUBMITTED

    Hey, This idea is not related to the functionality of the product but to the documentation and trainings. Many articles and training pages contain GIFs that show you how to do that what is described. I think it is great that you add visual instructions but the downside of GIFs is that you can’t pause it (at least not natively to my knowledge in Chrome). I want to follow along with the instructions but often have to wait for the GIF to finish, get to where I was stuck and hope to catch what is shown. To me it would be a lot more user friendly to have the ability to play/pause/rewind etc.Hope that you consider this feedback.Kind regards

    1
    anders.e.jonsson
    Contributor
    Forum|Forum|3 years ago

    Azure Postgres SQL as a DatabaseSUBMITTED

    More and more builders/data scientist are asking if TX can utilise Postgres SQL as a data warehouse option as in alot cases its there goto medium.

    1
    Søren Sørensen
    Contributor
    Forum|Forum|3 years ago
    Søren Sørensen
    Contributor
    Søren SørensenContributor

    Right-click to disable/enable jobsSUBMITTED

    When making major changes in a 6221.1 solution, we sometimes need to disable jobs to avoid deployment/execution collisions. It would be nice to be able to right-click a job and disable/enable it … preferably with a visual cue showing that the job is disabled when that’s the case.

    2
    Søren Sørensen
    Contributor
    Forum|Forum|3 years ago
    Niels Jonker
    Contributor
    Niels JonkerContributor

    Usage condition based on ODX statusSUBMITTED

    I would like to be able to use the status of an ODX task as a usage condition. For example when my ODX tranfer task completed with errors, I don’t want my MDW transfer job to run. This is my use case but I expect that others might have different use cases for the same feature. Please feel free to share such use cases below.

    3
    rory.smith
    TimeXtender Xpert
    Forum|Forum|3 years ago
    K
    Contributor
    KajEmergoContributor

    Audit trail modified objects in 6024.x releaseSUBMITTED

    Since customers will not be able to access their repository in the 6024.x release of TimeXtender, it would be great to see a feature that allows people to establish an audit trail of modified objects between different project versions. In the article below, you can find link to a very useful SQL query for this but it will obviously not be possible to use this in the new release.Therefore, adding such a functionality to for example the TimeXtender API would be a great outcome.

    0
    K
    Contributor
    Forum|Forum|3 years ago
    J
    Starter
    joelpetterssonStarter

    More details in job logsSUBMITTED

    Hi,I am reposting my conversation post as an idea instead. To give some background, I am working with TimeXtender Data Integration and trying to understand jobs better. In my trials I intentionally set up a package to fail, and first of all the monitoring view of jobs do not show any information about the error: Jobs monitoringIf I go into the execution log, I can see an error message that essentially just says that the job didn’t succeed.Execution log for test job​​​​​For debugging that means I have to check the contents of the job (that potentially could have multiple execution packages in it) and then head over to the execution tab to check the log for the package, where I see all the details.Execution log in execution tabI would think it was nice to be able to reach the execution message(s) straight from the Jobs log. And by extension it would be super nice if this information was available by the timextender API as that allows us to create a monitoring setup for the DW.

    0
    J
    Starter
    Forum|Forum|3 years ago
    Søren Sørensen
    Contributor
    Søren SørensenContributor

    More scheduling optionsSUBMITTED

    When scheduling jobs in 6221.1, there are use cases where we need to run a job on the 10th day of the month or the second Monday of the month. It would be nice to have this flexibility when scheduling jobs … a bit like Windows Task Scheduler.(I use Windows Task Scheduler to execute TX jobs in 20.10.x for exactly this reason).

    0
    Søren Sørensen
    Contributor
    Forum|Forum|3 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