What Is DWA to You?

To us it’s all about functionality you can trust.

Trust Us to Make Data Warehousing Faster and Easier

In developing TX DWA, we took great care to create features and functionality that you can count on. When you choose TX DWA for your data warehouse solution, we know that you place great trust in our product – and we do everything we can to live up to that responsibility. You can be confident that TX DWA will meet your needs for Data Warehouse Automation based on Microsoft SQL Server.

With TX DWA, you get a comprehensive set of features that automates the tedious aspects of building a data warehouse. This allows you to focus your work on the most important – and interesting! – elements, those parts of a project that makes a real difference to you company or your client.

The benefits of TX DWA do not stop there: the platform enables you to build OLAP cubes and QlikView models in the same code-light environment you use to build your data warehouse.

Data Warehousing

A data warehouse is the best foundation for any business intelligence solution. TX DWA utilizes a wide range of data warehouse automation techniques to be the fastest and easiest way to build a data warehouse.

  • Data Staging
  • Data Lineage Diagrams
  • Automated Documentation
  • Object and Data Level Security

Learn more about the Data Warehousing features

Maximum Results with Minimal Coding

Data warehouses have traditionally been coded “by hand” in projects that span many months – or even years. The innovative interface of TX DWA enables you to build a powerful data warehouse solution in a short amount time and with a minimum of coding – without compromising on code efficiency, versatility, or speed.

  • Visual development interface
  • Code generation engine
  • Version control
  • Multiple environments deployment
  • Team development
  • SQL snippets
  • Customized code

Learn more about features for development

Intelligent Execution Engine

Modern businesses cannot wait for days on updates to their data warehouses. TX DWA’s advanced multi-threaded execution engine updates data warehouses within hours. And with offline cube processing, there’s no downtime for the users.

  • Managed thread execution
  • Prioritization
  • Incremental load

Learn more about features for execution

OLAP Cubes the Easy Way

To have a data warehouse is rarely a goal in itself – the value of a data warehouse is measured by the insight it provides the business. With TX DWA, you can build analytical cubes for presentation tools by using the same powerful interface that constructed your data warehouse.

  • Business perspectives
  • Writeback for SSAS multidimensional
  • Language control for SSAS multidimensional
  • Offline cube processing

Learn more OLAP Cube features

Support for Any Data Source

Modern businesses rely on a range of different systems, each of which stores data in a different way. To meet this need, TX DWA supports a wide range of source systems, from flat files, Excel worksheets, and different databases to ERP and CRM systems. With the tools available on Microsoft SQL Server, there is practically no limit to the data source types you can use with TX DWA.

Data Sources

  • IBM DB2
  • IBM Informix
  • Microsoft SQL Server
  • Microsoft Excel sheets
  • NAV 2.60, 3.60, 3.70, 4.00 Native ODBC
  • ODBC
  • Oracle
  • Text files
  • AnySource: OleDB and ADO providers

Application Adapters

Application Adapters are intelligent connectors that know the structure of the source system and use that knowledge to simplify connection. Application Adapters are available for a number of popular systems:

  • Infor Infor10
  • Infor M3 (formerly Movex)
  • Microsoft Dynamics CRM
  • Microsoft Dynamics NAV
  • Microsoft Dynamics AX
  • Microsoft Dynamics GP
  • SAP R/3
  • Salesforce
  • UNIT4 Business World (formerly Agresso)

Learn more about supported data sources and Application Adapters

Tight Integration with Microsoft SQL Server

TX DWA is built for Microsoft SQL Server and works seamlessly with Visual Studio and other platform tools. You can, for example, build SSIS packages in Visual Studio and execute them through TX DWA.

Whenever Microsoft releases a new version of SQL Server, we make sure your existing projects still work. We tune our code generation engine to take advantage of any improvements that can speed up your project execution, giving you better performance without any work on your part.

Qlik Modeler

QlikView and Qlik Sense are popular data visualization tools that allows you to rapidly build views and dashboards. However, the backend implementation is based on scripting and can easily get complex and time-consuming. By enabling you to create Qlik models using the drag and drop interface, TX DWA makes building Qlik models much faster.

Learn more about the Qlik Modeler

Email Us: info@timextender.com

Call Us:

HQ - Denmark: +45 8620 5700

HQ – USA: +1 877 572 3477

DACH: +49 (0) 69 6773 3148

France: +33 (0)1 40 90 35 46