Skip to main content
To homepage To homepage

    Filter by idea status

    Filter by product

    859 Ideas

    erik.van.mastrigt
    TimeXtender Xpert
    erik.van.mastrigtTimeXtender Xpert

    Add Import Connection String button to TimeXtender PortalSUBMITTED

    As in the near future many clients will move from TX v20 to v21, all data sources have to be created in the new TimeXtender Portal.It would be of a great help if there is a Import Connection String button in the Portal, like it used to be in v20. Otherwise all properties have to be copied manually, which is a lot of work and sensitive to errors.

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

    Move ODX Data Transfer Incremental Setting to JobsSUBMITTED

    In the current version, you can enable/disable incremental load in the Transfer task. If you like to schedule an incremental load on weekdays and a full load in the weekends for example. You need to recreate the data transfer task. And when you need to add tables to the transfer task, you need to do it twice (for incremental and full data transfer).Unfortunately it is not possible to copy/clone ODX tasks, so it can be a lot of work to recreate a transfer task.It would be way easier if the incremental enable/disable option is moved to jobs. This makes it possible to create an incremental and a full load job. Both jobs are connected to the ODX same transfer task. 

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

    Show step in Execution overview when it starts not when it finishedSUBMITTED

    In the graph it would be important to visualize the process from the moment it starts and not when it ends. This would allow us to better monitor the execution of processes. 

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

    Duplicate Execution PackagesSUBMITTED

    It would be very useful to be able to duplicate a execution package to edit it.For example if you define a full load in a pexecution package with several tables and you want creare the same with incremental load.

    0
    rvgfox
    Problem Solver
    Forum|Forum|2 years ago
    T
    Starter
    ted.clarkStarter

    Remove Guarded Items from the Deploy Review Tasks ScreenSUBMITTED

    When I am managing a large project with lots of tables in a data warehouse, I will have some table guarded for good reason. When I go to deploy the entire project that table that I have guarded shows as checked in the “review tasks” step of the deployment planning step. This is either a feature request or a, what’s the reason for this, as to why is my table that I’ve set as “guard and do not deploy” set up and checked in the review tasks view of the project? When the deployment is off and running this table is not deployed as expected, but how come it’s checked in the first place as it causes some confusion and questions about how many items are getting differential deployed. 

    1
    Christian Hauggaard
    Forum|Forum|2 years ago
    S
    Contributor
    spenningContributor

    Ability to select semantic layer tables per endpointSUBMITTED

    Based on this article We tried to implement perspectives with on our environment in which we are running sql server 2019 standard edition locally with SSAS. Nonetheless, you can only create perspectives if you have SQL Server Entreprise edition, which renders the functionality mentioned in the article above to not work. (Or standard edition if you have Azure Analysis services). Look at topic below: Therefore, we suggest to possibility to be able to select which table you want to be able to be seen per endpoint, like in the case of roles per endpoint. For you roles you can either select to which endpoint a role is dedicated or vice versa.  We suggest to implement the same ability but then with objects within the semantic layer (measures, tables, columns). What this would practically mean is that instead of having one endpoint, which creates one table in SSAS with multiple perspectives, you would have a database for each endpoint created with the tables that you selected. Which means it could look something like this (excuse me for my photoshop skills) Again, this would solve the issue that we mentioned above for users which are locally hosting. Nonetheless, this could also turn out to be useful for other scenarios. Which could potentially be mentioned in the comments below from other users.   

    0
    S
    Contributor
    Forum|Forum|2 years ago
    Bernarddb
    TimeXtender Xpert
    BernarddbTimeXtender Xpert

    Execution packages based on schemaSUBMITTED

    For one of my client's there is authorization based on schema's that are created in the database. We also want to executed based on those schema's Now we either have to manually add all the tables to an execution packages. Or create a project perspective for that schema and then execute that execution packages. and create a different project perspective for the models that we are creating. So it would be very helpfull to be able to selecte the schema's you want to execute from a Data Warehouse in the execution packages.

    0
    Bernarddb
    TimeXtender Xpert
    Forum|Forum|2 years ago
    rogier.helmus
    Problem Solver
    rogier.helmusProblem Solver

    Azure AD login options for [Azure Data Factory - SQL Server] connectorSUBMITTED

    Hi all,When the TimeXtender environment is in Azure and you want to connect to an on-premise SQL database using the “Azure Data Factory - SQL Server” connection in combination with a Self-Hosted Integration Runtime is the only option. Unfortunately this connection only has the option to connect to the SQL database via a SQL account.At some clients I work and have worked for the use of SQL accounts for connections to databases has been prohibited. Therefore I would like to have all Azure AD login options added to this connector in the current and legacy (20.10.x) TX release. Greets, Rogier Screenshot "Azure Data Factory - SQL Server” connection config: 

    0
    rogier.helmus
    Problem Solver
    Forum|Forum|2 years ago
    rogier.helmus
    Problem Solver
    rogier.helmusProblem Solver

    Repository connection using service principalSUBMITTED

    Hi all,For the legacy TX release there are currently the following options to connect to the project repository:For a client that has the TX environment in Azure I would like to be able to connect to the repository via an Active Directory Service Principal, just like how it is possible via Management Studio:Username in this case is the app-id of the service principal and the password is the secret.Is this possible, perhaps via a workaround? If not, I’ll switch this to the idea section and ask for this option to be added together with the other options: 

    2
    rogier.helmus
    Problem Solver
    Forum|Forum|2 years ago
    sierd.zuiderveld
    Contributor
    sierd.zuiderveldContributor

    Scheduled DeploymentSUBMITTED

    Hello,Is there a possibility to schedule regular deployment tasks? Specifically, we're interested in deploying security updates every night.Apart from if this is a good idea or not, is it at all possible? 

    3
    sierd.zuiderveld
    Contributor
    Forum|Forum|2 years ago
    anders.e.jonsson
    Contributor
    anders.e.jonssonContributor

    Create secrets in the portal that can be used as variablea in the applicationSUBMITTED

    Hi,We have a customer who wants us to anonymize social security numbers. it must be done with SHA256 with a salt.It would be really neat if the customer could create the salt as a secret in the Portal. That functionality could be placed under Security and permissions.Then developers should be able to use the secret as an Instance Variable in the application. The content of that type of variable should never be visible to developers, but function like any string in the application.Would it be possible to arrange?

    1
    anders.e.jonsson
    Contributor
    Forum|Forum|2 years ago
    anders.e.jonsson
    Contributor
    anders.e.jonssonContributor

    Separate security roles and rules (SSL RLS) per environmentSUBMITTED

    HI,When copying from one SSL instance to another in V21 (6xxx), the RLS settings are overwritten in the destination. Since user access rules can get quite complicated, and often differ between development and production, this becomes quite impractical.Is there any way to avoid this behavior?BRAnders

    4
    anders.e.jonsson
    Contributor
    Forum|Forum|2 years ago
    anders.e.jonsson
    Contributor
    anders.e.jonssonContributor

    Properties on instances that could be good to haveSUBMITTED

    HI,We would like to have properties about an instance available via right-click on the instance in the application.There could, for example, be information about when the instance was created.If the content was copied from another instance, it could state when the last copy was made, from which instance and which version number the source instance had. Also what version number the receiving instance got after the copy.There's probably more information you could have there, but that's what appeared now.BRAnders

    0
    anders.e.jonsson
    Contributor
    Forum|Forum|2 years ago
    anders.e.jonsson
    Contributor
    anders.e.jonssonContributor

    Function to create a Time TableSUBMITTED

    Hi, I’m currently preparing för a workshop with i manufacturing company.It would have been nice with a function that could create a time table. Like the one that exist for adding a Date Table in the MDW.Any one that have solved this in a neat way in TimeXtender?BRAnders 

    0
    anders.e.jonsson
    Contributor
    Forum|Forum|2 years ago
    A
    Visitor
    antanVisitor

    External SQL Connections in TDISUBMITTED

    In the old version of TX (20.10) it is possible to set up an external SQL connection in a business unit under Sources, so that tables from an external database can be used in a TX project without extracting them from mentioned database. TX will then deploy those external tables as views pointing directly to the source database, which can even be on another server (‘linked server’).I cannot find external SQL connections in the latest version of TX. Can anyone confirm if this feature is available or not, and do we know if this in the product roadmap?

    3
    Thomas Lind
    Forum|Forum|2 years ago
    W
    Contributor
    wynkoopContributor

    Work Item IndicatorsSUBMITTED

    Right now, you can’t tell if something has a work item or not by looking at it.  Changing the appearance of an object with a work item on it would be extremely helpful in helping to avoid accidental collisions. 

    1
    daniel
    Forum|Forum|2 years ago
    Bernarddb
    TimeXtender Xpert
    BernarddbTimeXtender Xpert

    Distinct load on tablesSUBMITTED

    When creating tables based on multiple tables it would be nice to be able to set distinct. Duplicates in a dimension table for instance are ussually not what you require. There are workarounds but it would be nice to have a checkbox to just select distinct loading.

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

    Find unused fields for ODX ServerSUBMITTED

    When using the Business Units, the option ‘Find unused fields’ was available. This was very handy and enables you to only load data that is used in the data warehouse layer(s).This option disappeared since the introduction of the ODX Server. In the ODX Server (version 20.10.x) it is very cumbersome to only load columns that are used (luckily in V6XXX it is improved). That's why I most of the time select all columns in the tables in the ODX Server.If the ‘find unused fields’ option is reintroduced that analyzes columns loaded in the ODX Server and columns that are mapped to the MDW, it makes it easy to identify what is used and what is not used.This will only work efficiently if there is a way to automatically select/deselect columns in the ODX server based on the ‘find unused fields’ analysis.  

    1
    daniel
    Forum|Forum|2 years ago
    Jan Stroeve
    Contributor
    Jan StroeveContributor

    Drag-and-drop field above 'Relations' (MDW-to-SemanticLayer)SUBMITTED

    When you drag a field from the MDW to a table in the semantic layer it will show up at the bottom, below ‘Relations’. I'd prefer it to show up just above ‘Relations’.

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

    Do not scroll up one element when selecting in a column that has a horizontal scrollbarSUBMITTED

    When I am working in the TimeXtender GUI I may have many columns open, causing some to have horizontal scrollbars. Whenever a column has a horizontal scrollbar and the vertical scrollbar is scrolled all the way down, TimeXtender will mark the item you click and then move to the item above the one you marked.This is extremely annoying when trying to select the bottom item.

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|2 years ago
    Bernarddb
    TimeXtender Xpert
    BernarddbTimeXtender Xpert

    Execution Package chain continue to next package on errorSUBMITTED

    When creating and chaining execution packages it happens from time to time that one of the execution packages fails. But for sometimes you want to chain you packages and instead of having a retry or stop after failure you still want to continue executing the other packages. I wasn't able to find that option currently at both my current clients we are using 20.10.43 

    0
    Bernarddb
    TimeXtender Xpert
    Forum|Forum|2 years ago
    K
    Contributor
    KajEmergoContributor

    Improve dirty marking mechanism of DWH objectsSUBMITTED

    I would like to propose an idea for improving the mechanism that marks objects in a TimeXtender project as dirty. In the current version (20.10.xx) and probably in the new release as well, a couple of situations exist in which this mechanism fails to mark objects as dirty. As a result, these objects are not recognized when deploying the project and using the ‘review tasks’ option causing the next reload to fail.

    1
    K
    Contributor
    Forum|Forum|2 years ago
    Niels Jonker
    Contributor
    Niels JonkerContributor

    Left join for conditional lookupsSUBMITTED

    I found that I can’t choose to do a LEFT JOIN instead of INNER JOIN when I create a conditional lookup field. I understand that it can be dangerous to explode a table but there should be an option to do it. The current solution of creating a custom view to do this is cumbersome in my opinion

    0
    Niels Jonker
    Contributor
    Forum|Forum|2 years ago
    Niels Jonker
    Contributor
    Niels JonkerContributor

    Duplicate Data AreaSUBMITTED

    Hey, we are currently developing BI reports for our clients. We are working with DEV, TST and PROD versions of the dashboards. In TX I’m developing in our DEV data area. Once these developments are stable and approved we want to duplicate this data area to our TST data area. That way we can have a stable TST layer and continue new developments on the DEV layer again. To request is basically to be able to duplicate a data area into new or existing data area.

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

    Badge for Certified Pre-sales ProfessionalSUBMITTED

    Now that there is a certification for pre-sales professionals, there should also be a badge for those of us trying to “catch ‘em all”

    4
    devin.tiemens
    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