Product ideas

863 Ideas

rory.smithTimeXtender Xpert

Be able to set primary key from Data Source ExplorerSUBMITTED

Instead of needing to define rules for Primary Keys individually, it would be nice if you could simply toggle column inclusion from the Data Source Explorer. This would really speed up the process and make it more intuitive.

Forum|Forum|3 years ago

rory.smithTimeXtender Xpert

Set default data type for fields to Any in primary key definition for ODX ServerSUBMITTED

When data sources in the ODX Server do not automate primary keys, you need to manually define the primary key. By default the Data Type is set to Unknown which typically matches nothing. As a result you need to explicitly choose the type, but oftentimes you only care about the field in a table whatever the type is. I propose to add an ‘Any’ option and having this be the default.

Forum|Forum|3 years ago

rvgfoxProblem Solver

User that launch a package or jobSUBMITTED

In our current environment we have several developers.We have scheduled jobs that launch run packages, but we can manually launch jobs or run packages.Is it possible to know which user is launching the process?

Forum|Forum|3 years ago

sierd.zuiderveldContributor

Change 'Edit Table' to 'Rename Table'SUBMITTED

The name “Edit Table” does not reflect its only function of renaming the table. A more consistent and intuitive name would be “Rename Table”. The actual editing of the table is done in Settings, where you can change various aspects of the table. On the other hand, the edit button for a field lets you modify the field’s name, data type, and other properties. There are no settings for the field level. I have noticed that this inconsistency in the user interface can cause confusion and frustration for new colleagues/customers. A more streamlined experience would lead to happy customers 😀.Maybe a Settings button inside the table edit interface would be enough.

Forum|Forum|3 years ago

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):

Forum|Forum|3 years ago

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.

Forum|Forum|3 years ago

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

Forum|Forum|3 years ago

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.

Forum|Forum|3 years ago

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

Forum|Forum|3 years ago

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.

Forum|Forum|3 years ago

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.

Forum|Forum|3 years ago

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

Forum|Forum|3 years ago

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

Forum|Forum|3 years ago

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:

Forum|Forum|3 years ago

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

Forum|Forum|3 years ago

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.

Forum|Forum|3 years ago

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.

Forum|Forum|3 years ago

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.

Forum|Forum|3 years ago

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

Forum|Forum|3 years ago

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?

Forum|Forum|3 years ago

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?

Forum|Forum|3 years ago

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.

Forum|Forum|3 years ago

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

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.

Forum|Forum|3 years ago

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.

Forum|Forum|3 years ago

Filter by idea status

Filter by product

863 Ideas

Be able to set primary key from Data Source ExplorerSUBMITTED

Set default data type for fields to Any in primary key definition for ODX ServerSUBMITTED

User that launch a package or jobSUBMITTED

Change 'Edit Table' to 'Rename Table'SUBMITTED

Expand "override data type" functionality in ODXSUBMITTED

Show tooltip when hovering over conditional lookup fieldsSUBMITTED

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

Streamline SQL Formatting: Enhancing Code Readability and Coding EfficiencySUBMITTED

Same e-mail address for logging in to several customersSUBMITTED

Add dynamic project perspective based on impact analysisSUBMITTED