Learn & Share

ScenarioEarlier executions of a package used to complete in less time.  However, it is taking more time now. There are no specific errors or retries. Review and compare execution logs Right-click on a package => View Execution History Log Review Gantt charts for fast and slow execution to compare objects, steps and timings. Check to see if overall number of objects or steps have increased.    View Tools menu => Instance Execution Overview Log. Review various measures and drill-down to various objects.  Two examples are shown below:  Right-Click on data warehouse or a table => Execution Overview Log  When you turn on logging (execution package settings => Log Execution time and Log Row Count check boxes), it will show how fast a table ran and how many rows were transferred.Compare slow and fast executions, looking at timings and number of rows.  Environment, machine and network factors Review Windows Event Viewer logs for errors or warnings related to ODX Service and TimeXte

Test - post from "Control" UI

We’re always updating our users on new features we launch via the community. It’s such a great way to communicate on a 1-to-many basis with our customers. Additionally, what’s even better is that we have started to launch beta testing groups on our community where we invite a certain number of customers to test new features before we release them.   Not only does this allow us to iron out any bugs before a full roll-out, it also creates a real feeling of collaboration and togetherness between us and our customers. Such a great way to make sure you are building a product that really meets the needs of your end users! 

Why migrate from Business Units to ODX and steps to do so in TimeXtender?

What is Dimensional Modeling? How is this done in TimeXtender?

What is a Periodic Snapshot table and how does one implement it in TimeXtender?

How does one use the ODX as a remote server for multiple desktop clients?

What are the best practices for working with CData ADO.NET data providers in TimeXtender?

How to explore the data stored in Azure Data Lake, outside of TimeXtender?

Why and how to use Azure Synapse SQL Pool with TimeXtender MDW?

What are the steps to configure multiple environments in TimeXtender, such as Dev/Test?Prod?

What are the steps to set up Incremental Load and schedule data refreshes?

Just like your tools need cleaning or your garden needs weeding, TimeXtender performs better if some cleanup is done periodically. Items to cover: Repository execution logging cleanup Cleaning Unknown/Running tasks in the Execution Overview Log (see https://support.timextender.com/hc/en-us/articles/115004728763-Scheduled-Execution-issues-Did-it-not-start-did-it-fail-or-is-my-execution-still-running-) SQL Database Cleanup Wizard (take care with Azure SQL DB deployments and Unidentified Foreign Objects)  Find Unused Fields Techy Bonus: Full Recovery Mode in on-prem deployments and huge log files can lead to slowdown of Deployment checks  

What are the steps to work with the Scheduler Service, and how to effectively use Execution Packages

Since we talk about how easy it is to build a data warehouse in TimeXtender, is there some demo showing how to quickly create a data warehouse from data to dashboard?

What are the steps to use AAS for TimeXtender Semantic Endpoint?

What are some tips and tricks to troubleshoot issues in TimeXtender?

What are the pro-tips to create a TimeXtender environment as quickly an easily as possible?

What are the steps to upgrade TimeXtender and ODX from a previous version? What about Multiple Environments?

Jan Willem, Winvision NL asks: What is the reference architecture and flow of data from IoT devices and sensors into TimeXtender?

What are the best practices around using version control and backups in TimeXtender? How to perform a version Roll-back, per environment, if needed?

How would the facets of Agile development, with Sprints and Ceremonies, be a part of TimeXtender projects? What are the considerations for working in teams on TimeXtender?