TimeXtender Tuesdays

Discover the powerful new features in TimeXtender's November 2024 release! This walkthrough demonstrates end-to-end Microsoft Fabric integration, showcasing seamless connectivity with Fabric databases and the exciting public preview of Lakehouse support, The New D365 Finance Adapter, Redesigned metadata synchronization with Intelligent table remapping, and Orchestration Enhancements with Automated TDI task synchronization.  Microsoft Fabric & TimeXtender: https://www.timextender.com/microsoft-fabricView Full Release Notes: https://support.timextender.com/produ...Use Fabric Databases: https://support.timextender.com/confi...Use Fabric Lakehouse: https://support.timextender.com/prepa... 00:00 Introduction00:20 Overview of Features01:33 Fabric Database08:00 Fabric Lakehouse14:38 Fabric Semantic Models15:23 D365 F&O Adapter23:09 Metadata Manager29:24 Portal UX Improvements30:27 Orchestration Sync34:00 Local Time Zone34:37 Cloud Cost Optimizer

Annie Nguyen, InfoZone US asks: What are the best practices in TimeXtender to create a data model?

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://legacysupport.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 FieldsTechy 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?

What are the steps and considerations to use SQL DB Serverless with the TimeXtender DW storage?

What are the steps to ingest data using ADF into the ODX?

What are the steps to create an ADLS Gen2 ODX storage?