Tips, Tricks and Best Practices

Hi all,I am looking for architectural advice on designing a future-proof multi-ERP data warehouse setup in TimeXtender.We currently have multiple ERP systems feeding into one data warehouse. The goal is to create a scalable pattern that works now, but also remains maintainable when more ERP systems are added later.The main question is around where and when to create keys, especially super natural keys / business keys, and where to perform the joins between facts and dimensions. I found some scattered articles on keys and stuff, but not really an proposed best practice in TimeXtender. I understand there are multiple ways to Rome depending on the setup/preferences/performance etc. but I reckon there would be an advices standard based on TimeXtender working and fundamentals. Example simplified architecture:DSA.ERP1.Customers- CustomerID- CustomerName- DW_SourceCode- SNK_Customer = DW_SourceCode + CustomerIDDSA.ERP1.Invoices- InvoiceID- CustomerID- Amount- DW_SourceCode- SNK_Invoice = DW_S

This guide will help you get started connecting an AFAS GetConnector to the TX REST data source provider. It assumes you have: Created an app-connector in AFAS Added the GetConnector(s) you would like to load to the app-connector in AFAS Obtained an Afas TokenStep 1: Encode token as base64The AFAS API token takes the following format:<token>{YourTokenHere}<tokenYou must use a base64 encoded token to authenticate the API. There are multiple tools you can use to achieve this; I will be using PowerShell: $token = '<token><version>1</version><data>{YourTokenHere}</data></token>'$encodedToken = [System.Convert]::ToBase64String([System.Text.Encoding]::ASCII.GetBytes($token))$authValue = "AfasToken $encodedToken"echo $authValue The result will look something like: AfasToken PHR{EnCoDeDtOkEnHeRe}This entire output should be passed through the authorization parameter, which will be discussed in the next section. Step 2: Create a new data connection i

CData is imposing a monthly fee on customers that use their connectors after 5 March 2026.It’s easy to switch to TimeXtender connectors but it can be a tedious process in larger solutions with many projects to find those connectors.Here’s a query you can run against the project repository to get a list of currently used connectors:/***** Current CData Usage *****/select p.Name as Project      ,s.Name as DataSource      ,left(stuff(c.ProviderName, 1, 18, ''), charindex('.', stuff(c.ProviderName, 1, 18, '')) - 1) as Provider  from CDataDataSources c  inner join DataSources s on c.CDataDataSourceId = s.DataSourceId and s.ValidTo = 99999999  inner join BusinessUnits b on s.BusinessUnitId = b.BusinessUnitId and b.ValidTo = 99999999  inner join Projects p on b.ProjectId = p.ProjectId and p.ValidTo = 99999999  where c.ValidTo = 99999999  order by 1, 2

I wanted to post a link to the first article in a series on TX technical debt I published:https://www.linkedin.com/posts/ruairidhsmith_timextender-datawarehousing-technicaldebt-activity-7160565324541554689-fAIX?utm_source=share&utm_medium=member_desktopThis one is about CASE statements; I have a number of other topics planned out and am hoping to make this somewhat regular.

PrerequisitesODX Server machine has access to the URLs: *.googleapis.com/* Profile: 9-digit number connected to the GA profile you want to collect data from Property/Properties: 9-digit number relating to the property (e.g. website) you will collect data from. You will need a separate data source for each property (I think).  Account with admin privileges in the API for granting access as well as authenticating OAUTHMigrating Universal Analytics to V4If you already have a connection to GA Universal Analytics with the CDATA for Google Analyics 2022 Provider, setting up the connection to V4 will be easy. I recommend creating a new CDATA data-source for V4, so that you can compare the tables from Universal Analytics and V4. The structure of the data model has changed significantly!Copy connection string from GA Universal CDATA data-source Create a new data source with the GA CDATA connector and version Import connection string Change the version to V4 at ‘Authentication’ → ‘Schema’ as wel

Hello community,I’ve encountered over time some login issues when using the configurator exe’s.Most of the time is are firewall issues. So ofcourse check all the firewall settings and do not forget to add the TX .exe (all of them) to your inbound and outbound Windows Defender (gave me a lot of issues)While implementing this at my client we were still encountering issues for the login when checking configurations. But after a while the Internet Explorer pop up turned from grey to ‘refresh the page’ and then it went through with the autentication:  appentently some settings must be turned off for this to work smoothly. namely these settings you can find in the internet explorer settings:Now it is running smoothly again.Have any of you encountered this? Any other best praktises or stuff we need to check or know about?Maybe not the right place to ask this question here but what is your experiance with silent installs?I’ve encountered that the silent install works fine, but due to the login

Hi gang!I'm new with TX and wondering how to merge multiple sources into a single table. For example, let's say we have 3 different systems with a company table in each of them but with different IDs. What strategy would you use to have only one dimension/ one record for the same company in TX?Thanks in advance :-)Christine

Hi all,We've probably all encountered the challenge of coordinating releases, especially within bigger development teams. Currently, when we execute a release in TimeXtender, the entire project gets deployed. This can lead to problems, especially when trying to address minor production issues or releasing only the work of a single developer while others are still in progress. This often results in project-wide delays.I submitted an idea about this last week, and would love a vote if it's something you experience as well.At the same time, seeing how this probably won't get solved in the near future, I'm wondering how other are dealing with this at the moment. Any insights you could share into your way of working are very much appreciated!Kind regards,Barry

IntroductionIt has been discussed in multiple topics here: the question how to deploy semantic layers from TimeXtender to Power BI. As of version 21, this is natively supported. But many organizations are still on version 20 and therefor use Azure Analysis Services (AAS) to deploy their datasets to. While this works fine, AAS is a very expensive service and if you already have Power BI Premium, you already pay for a similar technique called XMLA Endpoints.Because the techniques behind AAS and XMLA Endpoints are similar, there is a way to directly deploy from TimeXtender 20.10.X to Power BI Premium. This guide explains how. DisclaimerObviously this guide explains a trick. Deploying from TX 20.10.X to Power BI Premium is not supported by TimeXtender and some manual manipulations after deployment are involved. However, it can be used to save costs. In our customer case, we save around EUR 4500 on monthly AAS costs, which is worth the pain of some manual actions. IngredientsTimeXtender 20.

Unleashing the Power of Ever-Increasing Data: TimeXtender's Holistic Solution for Data Integration in Today's Competitive Business World.In today's digital era, businesses are generating an unprecedented amount of data at an exponential rate. The vast array of information available presents a golden opportunity for enterprises to make well-informed decisions, improve customer experiences, and gain a competitive edge. However, the challenge lies not just in accumulating this data, but in utilizing it quickly and effectively to drive valuable insights. This is where TimeXtender, with its holistic data integration solution, plays a pivotal role in helping businesses harness the full potential of their data.The Soaring Data LandscapeData has become the lifeblood of modern enterprises, driving everything from market strategies and customer engagement to operational efficiency and supply chain management. The advent of social media, IoT devices, mobile applications, and online transactions h

Why TimeXtender is Essential in Today's Data-Driven WorldHey there, data enthusiasts! We all know that data is the new oil, and in today's digital age, it's essential for businesses to extract valuable insights from vast amounts of information. With data coming from all sorts of sources, it can be challenging to consolidate and analyze it all. That's where TimeXtender comes in - our holistic data integration tool is like a superhero that helps businesses automate their data processes, enabling faster, more accurate analysis, and decision-making.My Experience with Data Automation TimeXtender is an exceptional choice for businesses aiming to optimize their data processes through integration and automation. One of the greatest challenges I’ve faced in my career as a data specialist has been consolidating data from various sources, which required substantial time and effort. Once data consolidation was achieved, the subsequent hurdle was data preparation, cleansing, and transformation, all

Hi, we are migrating a datalake from Business Units to ODX.  I want to do some QA to ensure:  1. all tables have been remapped, 2. All columns are present.  3.  All Data types reconcile.  4.  Number of table rows matches.  Is there a recommended automated way to do this?

 Fast Track To Success: How to combine TimeXtender and Exmon for fast, pragmatic Data Governance to unlock business value. Watch our recorded webinar with Stefan Ahlbom, Solution Specialist at TimeXtender & Gunnar Steinn, CEO at Exmon.Key takeaways:1. Quick Start with TimeXtender: Master the essentials of TimeXtender deployment to get up and running in no time.2. Maximising and Exmon: Learn how to utilize both tools effectively to enhance data governance and drive business results.3. Selling to Clients: Get tips on how to clearly communicate the benefits of TimeXtender and Exmon to potential clients.Watch here. Thank you for your Time! 

Ever wonder what a day in the life of an IT Developer would be like with and without TimeXtender? We’ve created a short play walking through their day. Read More here. Feel free to use content as a tool to evaluate whether TimeXtender is a suitable solution for your clients' projects. If you have any questions or would like to schedule a demo let me know. Don't forget to check out the Partner Community where you can find additional tips, tricks, best practices and share thoughts.  Thank you for your continued partnership.Best regardsDid You Know Author:Christopher Royce DanielsSolution Specialist - North America  Christopher has been a Solution Specialist for TimeXtender since 2021. He enjoys enabling others on best practices with TimeXtender and delivering data solutions that solve common pain points in data estates.Contact: cdaniels@timextender.com  

Hi team, I have worked on many TX projects using ODX, but I have a new project that is using Business Unit. Someone told me that Business Unit will be deprecated in the future version of TX. What is the best practice for that? Regards Ignacio 

Ditch "Frankenstack": Embrace a Holistic and Agile-Optimized Data Integration Solution.  In today's data-driven world, many organizations find themselves trapped in a "Frankenstack" nightmare - a fragmented and inefficient data tool environment. TimeXtender's data integration solution empowers businesses to streamline processes, unlock hidden insights, and drive success. Ditch "Frankenstack": and EMBRACE a Holistic and agile-optimized data integration solution. Feel free to use these tools as you evaluate whether TimeXtender is a suitable solution for your clients' projects. If you have any questions or would like to schedule a demo let me know. Don't forget to check out the Partner Community where you can find additional tips, tricks, best practices and share thoughts. Thank you for your continued partnership.Best regards, The More You Know Author: Shivam KapporSolution Specialist - North America Meet Shivam, one of TimeXtender's go-to Solution Specialist since 2021. Passionate about

Did You Know? Time is Money!  What are the 5 features of TimeXtender that are "so money"? And what's with the name TimeXtender?  They say time is money, and within the business world, time is a valuable resource. Just like money, wasting it can be just as costly, because time matters. In business, time is a critical factor in determining profitability, growth, and success. The longer it takes to produce a product or deliver a service, the higher the cost of production and the lower the profit margins. Similarly, if employees are not working efficiently or effectively, this can result in lost productivity and revenue, and thus, business growth, success, and bottom-line profitability. And in the data driven world of business, how you manage, understand, and utilize data has a direct impact on a business’s time and how it’s utilized.   Therefore, to be successful in business, it is important to manage time effectively and efficiently. This means optimizing processes, minimizing wa

We wanted to update you on some new tools that can help you determine whether TimeXtender is the right fit for your clients' projects. Our in-house Solutions Specialist Harish Kundanchery Mechery has a quick message for you, click play! Here is the link for the tool to identify if TimeXtender is the right fit mentioned in the video.We Have Tools VideoAs you know, TimeXtender provides all the features you need to build a future-proof data infrastructure capable of ingesting, transforming, modeling, and delivering clean, reliable data in the fastest, most efficient way possible - all within a single, low-code user interface. By unifying each layer of the data stack, TimeXtender empowers you to build data solutions 10x faster, while reducing your costs by 70%-80%.That's why we've developed these tools that can quickly and easily assess whether TimeXtender is the right fit for your projects. Read more about the Why, What, & How To Choose Your DWA Tool in the recent blog.Feel free to us

Healthcare: Timextender can automate data integration and data management tasks in healthcare organizations, improving patient care and operational efficiency. Retail: Timextender can provide a holistic view of the business by integrating and analyzing data from various sources, optimizing inventory management and personalizing customer experiences. Financial Services: Timextender can help financial institutions ensure data accuracy, comply with regulatory requirements, and make informed investment decisions by managing and analyzing data from multiple sources. Manufacturing: Timextender can streamline data management and integration processes in manufacturing companies, optimizing production processes and improving product quality. Government: Timextender can enable government organizations to make data-driven policy decisions, improve service delivery, and enhance transparency and accountability by managing and analyzing diverse data sources. Education: Timextender can provide insigh

Are there any best practices regarding the management of rsd files (and the like) in a multiple developer / multiple environments setting. We are currently manually distributing the files, and considering linking the locations to a git controlled repo to have some sort of control, but we do not want to complicate things if it is not necessary.Note: Using legacy version