Configure Your TimeXtender Environment

This guide describes all the necessary steps to prepare your environment for TimeXtender.

Click the links to jump to each section.

  1. What is TimeXtender?
  2. Choose your Environment Architecture
  3. Configure User Accounts & Permissions
  4. Configure the Firewall
  5. Install & Configure ODX Server
  6. Install & Configure TimeXtender Desktop
  7. Configure the Scheduler
  8. Configure Multiple Environments

What is TimeXtender?

TimeXtender is the fastest way to access, model, and document your data solution. To properly setup your environment for TimeXtender, it’s important to first understand how the platform works. The platform can be understood as a database abstraction layer on top of various data storage platforms such as Azure SQL Database, Azure Data Lake, or SQL Server. TimeXtender communicates with these platforms enabling the rapid development and maintenance of a modern data estate.  


Any working TimeXtender environment primarily consists of the following working parts.

  • TimeXtender Desktop & Services - The primary user interface for building projects in TimeXtender & Services used to schedule and manage the data in your environments.
  • TimeXtender Portal - The web interface used for user management & monitoring.
  • Data Storage Platforms - These are the data lake or relational database platforms that you choose to store the data for the ODX, MDW, & Semantic Layers.

For a deeper look into how TimeXtender functions you can watch this brief video:

Choose your Environment Architecture

Use the following decision tree to help you decide the best environment architecture for your use case.





Keep in mind that it is quick and easy to deploy TimeXtender projects to a different environment architecture at any time. For example, if you build your TimeXtender Project on-premise, you can quickly and easily deploy your project onto Azure SQL DB or Azure Synapse, with little to no downtime. So, don't feel like you will need to live with your decision forever. 

If you're having trouble deciding which option to select, please reach out to your TimeXtender Partner or Solution Specialist to determine the best course of action for your goals.


Configure User Accounts & Permissions

For TimeXtender and its services to run properly, you must first Configure User Accounts & Permissions

Configure the Firewall

Configure the Firewall on the Application server with the Required Firewall Rules

Install & Configure ODX Server

Download, Install, & Configure the ODX Server on your Production Application Server. 

Install & Configure TimeXtender Desktop

Download, Install & Configure the TimeXtender Desktop Application. If all machines are running within the same physical or virtual network, the desktop application can be installed on a user client machine. Otherwise, the desktop application should be installed and used directly on the Application Server. 

Configure the Scheduler

When you are ready to begin scheduled executions of your MDW projects, Configure the TimeXtender Scheduler Service and the Application Server.

Configure Multiple Environments

If you wish to keep your development and testing data separate from your production environment you can Configure Multiple Environments.


With your TimeXtender environment set up, you can get started very quickly building your data warehouse solution. If you'd like to see how fast TimeXtender is in action, please check out TimeXtender Tuesday episode, "Lightning Demo: Build a Data Warehouse in 15 minutes".


Was this article helpful?
0 out of 0 found this helpful


Please sign in to leave a comment.