Skip to main content
To homepage To homepage

    Filter by idea status

    Filter by product

    859 Ideas

    J
    Participant
    JeroenSParticipant

    Data on demand option for Azure Data Factory - SQL Server (12.0)SUBMITTED

    It would be nice if the data on demand option will also work the ADF - SQL Server provider.Using version provider version 12.0 and TX version 6143.1.

    4
    JTreadwell
    Forum|Forum|1 year ago
    erik.van.mastrigt
    TimeXtender Xpert
    erik.van.mastrigtTimeXtender Xpert

    Clone instances in TX PortalIMPLEMENTED

    We’re currently investigating a migration from v20 to v21. Our project has 25+ semantic layers, each having a development, test and production version.At this moment all semantic layers for development are created in the TX Portal. Its seems that we have to repeat these create actions twice: for the test and production environments. It would be a huge timesaver if we can clone these for the other two environments. We only have to alter the PBI workspace name.

    4
    andrew.gebhard
    Forum|Forum|1 year ago
    anders.e.jonsson
    Contributor
    anders.e.jonssonContributor

    Copy parts of an instanceSUBMITTED

    Hi,It would be great if it were possible to copy parts of one instance to another.If, for example, you could be presented with a list of the Perspectives that exists in the source instance and be able to choose which of them you want to copy with their contents to the destination instance.It would make it easier, and more risk-free, to have continuous deployment/copying of parts of a solution when several developers work on different areas in the same instance.BRAnders 

    0
    anders.e.jonsson
    Contributor
    Forum|Forum|1 year ago
    anders.e.jonsson
    Contributor
    anders.e.jonssonContributor

    Push feature for the API Server EndpintSUBMITTED

    Hi, We would like to have the ability to export data to an API in another cloud service from Timextender's API server Endpoint. I think this feature was called Push or reverse ETL in Xpert BI.BRAnders

    0
    anders.e.jonsson
    Contributor
    Forum|Forum|1 year ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Improve the Portal display for Instance / EnvironmentsSUBMITTED

    For larger deployments the current Portal runs into some issues:instance icons are only useful when there are low number of them strings for names are truncated if they are too long you cannot filter you cannot sort there are no mouse-overs showing the full description or nameImagine a larger TimeXtender implementation:3 environments 2 ODX 6 DWH 100 SSLYou get a huge page of icons that is hard to work with and makes it easy to make mistakes. If you did not come up with a good naming conventions you might have:Development - SSL - SalesManagement Development - SSL - SalesMarketingThe UI will truncate the names and you might have two ‘Development - SSL - SalesMa' instances, but you only want to promote the Marketing one. You can assume the sorting is alphabetical, but I would not bet on it.These kind of issues could be solved by:Adding a list/table option for displaying instances making it possible to see all attributes and make more effective use of screen real-estate Make it possible to sort by any attribute (i.e. Environment first, name second, etc.) Make it possible to filter the instances displayed. If I am pushing Dev to Test, I don't want to see Prod instances Add mouse-overs to get a full display of attributes in Icon mode 

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Add Exmon service status to status.timextender.comSUBMITTED

    As the Exmon products are now part of the TimeXtender suite, it would be good to have the status of Exmon cloud services added to https://status.timextender.com so that users can check whether a service outage on the Exmon side is the reason something is not functioning.

    2
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    erik.van.mastrigt
    TimeXtender Xpert
    erik.van.mastrigtTimeXtender Xpert

    Make transferring instances in TX Portal less error proneSUBMITTED

    While it is great that you can easily copy instances around, it is also quite error prone.We have 30+ SSLs, all having a dev, test and prod instance. When promoting an instance in the TX Portal, it is too easy to make a mistake and copy Dev SSL A to Test SSL B.It would be nice if you can somehow link instances over environments, so that the default copy instance action is transferring Dev SSL A to Test SSL A.I want to emphasize that the current possibility to copy instances freely around is still a powerful feature (eg. when you need to copy prod back to dev), but a default source-target setting should prevent users from making mistakes.

    0
    erik.van.mastrigt
    TimeXtender Xpert
    Forum|Forum|1 year ago
    R
    Participant
    RobertUParticipant

    Schedule ODX Server to transfer on a different timezone than UTCSUBMITTED

    Is there a way to schedule the ODX server transfers on anything other than UTC? We always want to have the load at 6pm regardless of summer/winter time. 

    4
    erik.van.mastrigt
    TimeXtender Xpert
    Forum|Forum|1 year ago
    erik.van.mastrigt
    TimeXtender Xpert
    erik.van.mastrigtTimeXtender Xpert

    Central and detailed repository for loggingSUBMITTED

    Currently there are multiple places where logging is stored. For instance, if an execution fails, you probably have to look in one or more of these places to see what precisely went wrong:Exmon package logging Emails from Exmon should contain more detail. For example, a job that is ‘Completed with errors’ lets Exmon send an email saying that the job as a whole failed to run without any further info. TimeXtender Data Integration Job Logging Ingest Instance Transfer Log Prepare instance/Deliver instance execution package logIt would be great if all these logs can be analyzed at one centralized place, and have a more detailed view than some current logs, like: 

    0
    erik.van.mastrigt
    TimeXtender Xpert
    Forum|Forum|1 year ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Add functionality to see which user has which instance openSUBMITTED

    When performing instance transfers in the TimeXtender portal, there are some checks you need to do beforehand:Make sure the involved instances aren't opened by developers Make sure there are no executions running or soon to be running on involved instancesFor the first check, there is no current functionality to directly check this. There are a few workarounds:If all developers log into specific VMs to run TimeXtender Data Integration, you can check Task Manager to see which accounts are logged in (and forcefully sign them off in the worst case)   If you have Team development enabled on Prepare instances, you can use the Work Items feature for each opened Prepare instance to see what users have active sessions   If your developers run TimeXtender Data Integration from their own laptops or you are transferring Deliver instances, there is no foolproof way to check. Transferring while people are actively working in instances involved in the transfer can lead to problems, so it is critical to be able to check beforehand. For the second check, you want to be able to see what is running and what is upcoming on the schedule. The only way to see this is to look at the Jobs monitor to see if anything is running at all, and then find out which instances are involved and subsequently which Execution Engine / ODX Service this is coupled to. You can make this easier by having naming conventions, but this becomes difficult for larger environments or transfers.If you are running TimeXtender Orchestration, it is slightly easier to manage but you are dealing with two different applications.I propose adding a centralized overview of all Instances with the following attributes:Environment the instance belongs to Execution Engine / ODX Service the instance is running against Whether Team development is enabled or not Which users have active sessions on the instance Which users have a lock on an instance Which Job / Tasks are currently running on the instance When the next Job / Task will be triggeredIn addition, it would be wonderful if some actions could be applied:Disconnect a user's session / send a message asking to disconnect Stop a currently running Job / Task Pause the scheduling / prevent Jobs / Tasks from being triggered

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    coen.donders
    TimeXtender Xpert
    coen.dondersTimeXtender Xpert

    Possibility to use custom data selection rule on ODX table in a DSA mappingSUBMITTED

    When an ODX table is mapped to a DSA table you can now only use column filters. It is not possible to set a (custom) table filter.example:You can filter on  "date GREATER OR EQUAL 2023-01-01"but you can't use a filter like "field1 + field2 > 1000"or a filter like TRIM (field) = 41 is not even possible. 

    4
    J
    Forum|Forum|1 year ago
    M
    Starter
    markussvanstromStarter

    Allow TimeXtender jobs to be organized in foldersSUBMITTED

    Possibilities to structure the defined jobs in TimeXtender would increase the user experience. For instance when having a multi-environment (DEV, TEST, PROD) it would be good to separate the jobs in folders for each environment. The suggestion is therefore to allow the user to create job folders where the user can organize the created jobs. 

    0
    M
    Starter
    Forum|Forum|1 year ago
    anders.e.jonsson
    Contributor
    anders.e.jonssonContributor

    Select culture/language when semantic model endpoint is added to the portalSUBMITTED

    Hi,It would be nice to be able to choose the culture (language) when the semantic model is added to the portal. This applies to the endpoints Power BI and Tabular.Can you choose the right culture, in our case sv-SE, then the sorting order will be correct in tables. Also for the letters Å, Ä and Ö which now are sorted as A and O respectively.BRAnders

    3
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    N
    Starter
    nilStarter

    Compare different versions of a project in same environmentSUBMITTED

    E.g. current version against deployed version or current version against an earlier version. Now it is possible to see which tables has been changed (red text), but not exactly what has been changed in that table. A list or something else to see exactly where something has been created, changed or deleted would become handy in many situations.

    4
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    richard.ray_ts
    Explorer
    richard.ray_tsExplorer

    Single portal login to access multiple customersSUBMITTED

    In our portal we have several customers set up, and each of them require unique email addresses.This means that we have to ask our IT team to set up aliases for each of the customers, e.g. richard.ray.cust1@…., richard.ray@cust2@… etcI am suggesting a single email address that can be used across customers whereby you would login as normal and then be presented with a drop down of the customers that you have access to, plus of course the top level “Parent” portal where the customers are created.

    3
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    andri
    Contributor
    andriContributor

    Dedicated settings for snapshot tablesSUBMITTED

    Snapshot fact tables are common in many data warehouse projects. Often the data that they store can not be re-loaded as the dw does the snapshotting and is it's only storage. I dont think there is a bulletproof way to do this currently in TX in terms of performance and data safety. There should be dedicated settings for snapshot tables. I've used incremental loading but that's not a safe way and I always take a backup of any snapshot tables before a deployment just to be safe. I've also tried using the history setting but I found the performance to be really bad for big tables as the unnecessary comparison logic is such an overkill for what needs to done. My suggestions for how this setting should work: 1. It should make sure that the valid table is never ever truncated or dropped (unless with a flashy warning dialog asking you to confirm)2. You would set the snapshot value field.3. It would do a delete for the incoming snapshot value before inserting the dataset. Extra----4. It's features could be expanded to have configuration for defining the snapshotting value based on the exection time or a parameter, having it do a daily/weekly/monthly snapshot. 5. It could do a daily snapshot but then have a setting to only store the latest along with week-end/month-end snapshots.    

    21
    peter.jensen
    Forum|Forum|1 year ago
    avanrijn
    Contributor
    avanrijnContributor

    merging multiple projectsSUBMITTED

    Dear Sir,I know this sounds crazy.I would like to merge multiple projects iin TX version 20.10.51.64, bring them together into one single TX project.I know this is a feature of the migration tool, when migrating to an instance in the new TX SaaS version. That is great, I need same functionality in version 20.10.51.Is that possible ? Is there a way to do this ?Hope this makes any sense. Regards,Arthur

    4
    Christian Hauggaard
    Forum|Forum|1 year ago
    G
    Starter
    gdlc_esculineStarter

    Is it possible to give Company Admins access to Data sources in the Instances they have access to?SUBMITTED

    Hi,Our team is currently trying to limit access of our developers in projects that they do not work on. Everyone is currently a Data Estate Admin portal, so they can see every Instance/Data source connection. We tried to test some roles out by having someone only have the role of Company Admin. They now can correctly only see the Instances to which they are assigned to and the Data source connections that are mapped to the Instance. If they click on the Data Source connection, the user gets directed to the Homepage.We would like the developers to have role in which they can also see/edit the Data sources connections to the Instances they have access to. Is it possible to achieve that with the current TX Portal? Thanks in advance!

    5
    Christian Hauggaard
    Forum|Forum|1 year ago
    bas.hopstaken
    TimeXtender Xpert
    bas.hopstakenTimeXtender Xpert

    Add MFA support for the Exmon portal and Desktop applicationsSUBMITTED

    I believe the title is self-explanatory.Please add Multi-Factor Authentication for the Exmon portal and desktop applications (Exmon DG and Exmon DM).    

    0
    bas.hopstaken
    TimeXtender Xpert
    Forum|Forum|1 year ago
    bas.hopstaken
    TimeXtender Xpert
    bas.hopstakenTimeXtender Xpert

    Rename environtments in Exmon DG DesktopSUBMITTED

    Currently, you can use a maximum of three environments in Exmon (if enabled in settings). The environments have fixed names: DEV, TEST, and PROD. These names do not always match the naming conventions used by customers.It would be great if we could rename these environments.

    0
    bas.hopstaken
    TimeXtender Xpert
    Forum|Forum|1 year ago
    rvgfox
    Problem Solver
    rvgfoxProblem Solver

    Allow to execute "guarded tables"SUBMITTED

    We have some parameters tables that are guarded on deployment and execute because it normaly doesn’t change.If some table it’s necesary to change it it’s hard to manually un-guarder, execute and guarder again.It would be usefull to be able to define a execution package to execute tables that are guarded for execution.

    1
    rvgfox
    Problem Solver
    Forum|Forum|1 year ago
    A
    Starter
    AngeloStarter

    Hash function to identify changes on the source systemSUBMITTED

    We have a client case where a huge table - that needs to be loaded incrementally- does not have any changed field. Because of legacy issues, it’s not possible to d introduce a rowversion or Change tracking on SQL Server. The ODX is on a datalake, while the MDW on Azure SQL Server.The proposed solution tries to identify which rows have been updated in the table, here's a streamlined approach:Calculate Total Rows: First, get the total number of rows in the table Initial Range: Start with the full range of IDs, from the minimum to the maximum ID in the target table. Recursive Division: Divide the range into two halves and calculate a checksum for each half: checksum_agg(checksum(ID * EntryType)). The checksum combines IDs and EntryType values to create a unique fingerprint for that segment. Compare Checksums: If the checksums match, no updates in that segment. If they differ, further divide the segment with the differing checksum into smaller halves and repeat the process. Threshold for Division: Continue dividing until the segment size is smaller than the square root of the total row count. This helps us quickly narrow down potential updates. Identify Updates: For small segments (below the threshold), directly compare the rows in the source and target tables to find where row has changed.We can efficiently find updates without having to compare every single row, by focusing only on segments where changes are likely.It would be great if such functionality can be implemented in TimeXtender :-)

    1
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    C
    Explorer
    cmynhardtExplorer

    TimeXtender REST API Dynamic EndpointSUBMITTED

    I am connection to a REST API with multiple Endpoints. Does anyone have experience with setting up a control table for TimeXtender to use to dynamically change the endpoints instead of creating an endpoint per table?

    4
    Christian Hauggaard
    Forum|Forum|1 year ago
    B
    Contributor
    BennyContributor

    Add XSL file directly to REST data source connectorSUBMITTED

    Currently you can add XSL code to the XSLT box under table flattening in the REST data source connector. However you have to paste the text. I would like to be able to browse for a specific file. Specifically so a can place that file in a git repository. We created some custom XSLTs for some more challenging APIs (the table constructor didn't suffice). Currently we have to copy-paste their contents to the portal which is poses some maintenance challenges as you can probably imagine. 

    1
    B
    Contributor
    Forum|Forum|1 year ago
    erik.van.mastrigt
    TimeXtender Xpert
    erik.van.mastrigtTimeXtender Xpert

    Retry Step functionality in ODX Server Transfer TaskSUBMITTED

    With Exmon it is possible to retry a Job if it (partially) fails. DWH execution packages can be configured that steps will be retried a couple of times before the package fails.Currently there is no possibility to retry streps in an ODX Transfer Task. If the Transfer Task fails (or completes with errors), the only thing you can to is configure Exmon to retry the full Transfer Task. This means that all tables in the Task will be reloaded, not only the one that failed.If a data source has many tables, it is quite inefficient and time-consuming to re-load all tables if just one failed in the previous attempt.Especially REST API endpoints sometimes simply throw an error. A retry after a couple of minutes makes that the load ultimately succeeds, where you don’t want to re-load all endpoints that already have been loaded. I found some other questions/ideas that are highly related to this idea, but are not too explicit in what functionality is needed. Hence a new idea.https://support.timextender.com/ideas/fail%2Dretrying%2Dexecution%2Dmessage%2D1199 

    1
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year 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