To homepage To homepage

Learn & Share

Share tips and best practices, show what you've created and inspire others

44 Topics

andrew.gebhard
Participant
andrew.gebhardParticipant
posted in Tips, Tricks and Best Practices

Connecting the Google Analytics V4 API to TimeXtender - Guide and Discussion

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

3
westdorp
Starter
6 days ago
bitmetric_barry
Explorer
bitmetric_barryExplorer
posted in Tips, Tricks and Best Practices

Release management and working with multiple developers

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

0
bitmetric_barry
Explorer
1 month ago
erik.van.mastrigt
TimeXtender Xpert
erik.van.mastrigtTimeXtender Xpert
posted in Tips, Tricks and Best Practices

Deploy to Power BI Premium with TX 20.10.X

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.

4
Thomas Lind
Community Manager
1 month ago
wouter.goslinga
TimeXtender Xpert
wouter.goslingaTimeXtender Xpert
posted in Success Stories

Customer Success Story: Medisch Spectrum Twente (MST)

In 2021, together with the customer, Axians started a project at Medisch Spectrum Twente, a large hospital located in the east of The Netherlands.The aim of the project was to replace a legacy Frankenstack of BI tooling (SAP Data Services, SAP Business Objects and others) with a future-proof cloud based dataplatform. Leveraging the power of the Axians Maestro Platform, based on Microsoft Azure, and of course TimeXtender, MST now has a comprehensive, modern Data Estate that is used by hundreds of employees.Together with the customer, we have achieved the following goals:Training BI employees at the customer Build the complete Data Estate from the ground up using Azure, TimeXtender and PowerBI Much better and faster business insights (shorter time to market) Lower TCO Easy oversight and management of the entire solution Stable and well manageable data loadsTimeXtender was the absolute best match for this project because it was the only tool able to facilitate the entire data flow, from s

1
JTreadwell
Community Manager
2 months ago
thagin
Community Manager
thaginCommunity Manager
posted in TimeXtender Tuesdays

What are best practices to build a data model in TimeXtender?

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

6
rory.smith
TimeXtender Xpert
3 months ago
RichTX
Employee
RichTXEmployee
published in Tips, Tricks and Best Practices

The More You Know: Unleashing the Power of Ever-Increasing Data: TimeXtender's Holistic Solution for Data Integration in Today's Competitive Business WorldThe More You Know

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

1050
RichTX
Employee
3 months ago
ShivamKapoor
Employee
ShivamKapoorEmployee
published in Tips, Tricks and Best Practices

The More You Know: Why TimeXtender is Essential in Today's Data-Driven WorldThe More You Know

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

550
ShivamKapoor
Employee
4 months ago
K
Starter
KathyBespokeStarter
asked in Tips, Tricks and Best Practices

Migrate datalake from BU to ODX

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?

5
K
Starter
4 months ago
Stefan
Employee
StefanEmployee
published in Tips, Tricks and Best Practices

Fast Track To Success:  How to combine TimeXtender and Exmon for fast, pragmatic Data Governance to unlock business value.Interview

 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! 

2263
daniel
TimeXtender Xpert
4 months ago
CDaniels
Employee
CDanielsEmployee
published in Tips, Tricks and Best Practices

The More You Know: Play Script "A Day in the Life of an IT Developer - with & without TimeXtender"The More You Know

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  

590
CDaniels
Employee
4 months ago
thagin
Community Manager
thaginCommunity Manager
asked in TimeXtender Tuesdays

Migrate from Business Units to ODX

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

6
K
Starter
5 months ago
ignacio
Contributor
ignacioContributor
asked in Tips, Tricks and Best Practices

What is the best practice Business Unit or ODX?

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 

1
rory.smith
TimeXtender Xpert
5 months ago
ShivamKapoor
Employee
ShivamKapoorEmployee
published in Tips, Tricks and Best Practices

The More You Know: Ditch "Frankenstack": Embrace a Holistic and Agile-Optimized Data Integration Solution.The More You Know

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

900
ShivamKapoor
Employee
5 months ago
RichTX
Employee
RichTXEmployee
published in Tips, Tricks and Best Practices

The More You Know? Time is Money! What are the 5 features of TimeXtender that are "so money"? And what's with the name TimeXtender?The More You Know

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

750
RichTX
Employee
6 months ago
harishkm
Employee
harishkmEmployee
published in Tips, Tricks and Best Practices

The More You Know: We Have Tools to Identify if TimeXtender is Right Fit for New Projects.The More You Know

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

770
harishkm
Employee
7 months ago
CDaniels
Employee
CDanielsEmployee
posted in Tips, Tricks and Best Practices

Did You Know: 7 Innovative Ways You Can Utilize TimeXtender!

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

0
CDaniels
Employee
7 months ago
M
Visitor
malknVisitor
asked in Tips, Tricks and Best Practices

Best practice team development rsd files

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

1
Thomas Lind
Community Manager
7 months ago
rory.smith
TimeXtender Xpert
rory.smithTimeXtender Xpert
posted in TimeXtender Tuesdays

Keep it clean: taking care of your TimeXtender deployment

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 

1
JTreadwell
Community Manager
2 years ago
thagin
Community Manager
thaginCommunity Manager
asked in TimeXtender Tuesdays

Episode 09 - Configure Incremental Load & Schedule Executions

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

1
thagin
Community Manager
2 years ago
thagin
Community Manager
thaginCommunity Manager
asked in TimeXtender Tuesdays

Episode 14 - Use ODX as secure, scalable, & remote server architecture

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

1
thagin
Community Manager
2 years ago
thagin
Community Manager
thaginCommunity Manager
asked in TimeXtender Tuesdays

Episode 15 - Implement a Periodic Snapshot table

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

1
thagin
Community Manager
2 years ago
thagin
Community Manager
thaginCommunity Manager
asked in TimeXtender Tuesdays

Episode 16 - Dimensional Modeling in TimeXtender

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

1
thagin
Community Manager
2 years ago
JTreadwell
Community Manager
JTreadwellCommunity Manager
asked in TimeXtender Tuesdays

Episode 01 - Create Application Server for TimeXtender in Azure

What are the steps to set up the application server in Azure for TimeXtender?

1
thagin
Community Manager
2 years ago
thagin
Community Manager
thaginCommunity Manager
asked in TimeXtender Tuesdays

How should Agile process be applied to TimeXtender Projects?

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?

1
thagin
Community Manager
2 years ago
thagin
Community Manager
thaginCommunity Manager
asked in TimeXtender Tuesdays

How to ingest data from IoT sources (e.g. sensors) into the ODX?

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

1
thagin
Community Manager
2 years ago

Badge winners

Show all badges
Terms and ConditionsCookie settings