Tips, Tricks and Best Practices

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

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: 

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 t

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 f

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

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 i

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 thr

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

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. 

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. 

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 d

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.

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 gover

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