On-Prem SQL Server Reference Architecture

  • 30 January 2023
  • 1 reply
On-Prem SQL Server Reference Architecture
Userlevel 4
Badge +5

This is a standard reference architecture to implement TimeXtender fully On-Premises.

To prepare your TimeXtender environment, here are the steps we recommend:

1. Create Application Server - Local Server

To serve the TimeXtender application on-premise, we recommend using an Windows environment such as Windows Server sized according to your solution's requirements.

Guide: Configure an On-Prem Application Server & Storage


  • This article highlights the Separate Application and Database Server architecture. In this configuration, the ODX Server is installed on an "Application" server and the SQL Databases are stored on a separate "Database" server. It is also possible to run the ODX and SQL on a consolidated server.
  • Once you have chosen your desired configuration and deployed the necessary servers, you must install all the necessary TimeXtender Prerequisites.

  • Configure your server(s) firewall to allow TimeXtender's List of Required Firewall Exceptions.

2. Create ODX Storage - SQL Server Data Storage

To integrate your siloed data, On-Prem SQL DB can store your raw data quickly and easily.

Guide: Add an ODX Instance


  • ODX Server Storage database can be created directly in TimeXtender
  • ODX Server Service should be hosted locally on the App Server
  • SQL Server 17 or higher is recommended

3. Create MDW Storage - SQL Server Data Storage

SQL DB is a great option for the data warehouse storage.

Guide: Add a Data Warehouse Instance


  • A data warehouse in TimeXtender is a SQL Server database on premise (or in Azure) where your data is stored for queries and analysis.
  • Often, a TimeXtender solution consists of one data warehouse where you consolidate data from one of more staging databases and a number of data sources.
  • SQL Server 2017 or higher is recommended
  • If using a Data Staging Area (DSA) in your solution, you can use a separate SQL DB as the MDW.

4. (Optional) Create Semantic Model - SQL Server Analysis Services

SQL Server Analysis Services is the ideal way to serve data to Power BI and Excel. Since there are many ways to connect visualization tools directly to the MDW, this is an optional step.

Guide: Add a Semantic Model Instance


  • TimeXtender stores semantic models in Analysis Services Tabular model behind the scenes.
  • Each semantic model can be deployed to one or more endpoints.


1 reply

Userlevel 1


Does the number of ODXs alone determine how many application servers are required?
If we imagine a scenario with version 6143, where we have a common ODX and three MDWs - one each for development, test and production. Is it then appropriate to have only one application server?

Are there cases when we should have multiple database instances?

Where are scheduling and executions run? Is contact with TimeXtender's servers required to be able to run jobs in an on-prem environment?