What Is DWA to You?
To us it’s all about functionality you can trust.
Trust Us to Make Data Warehousing Easier
In developing TX2014, we took great care to create features and functionality that you can count on. When you choose TX2014 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 TX2014 will meet your needs for Data Warehouse Automation based on Microsoft SQL Server.
With TX2014, you get a comprehensive set of features that automates the tedious aspects of building a data warehouse, allowing you to focus on the most important and interesting elements. The benefits of TX2014 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.
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 TX2014 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
- Multiple Environment Deployment
- Team Development
- Work Items
- SQL Snippets
Modern businesses cannot wait for days on updates to their data warehouses. TX2014’s advanced multithreaded execution engine updates data warehouses within hours. And with offline cube processing, there’s no downtime for the users.
- Managed Thread Execution
- Offline Cube Processing
- Incremental Load
A data warehouse is the best foundation for any business intelligence solution. TX2014 utilizes a wide range of data warehouse automation techniques and is the fastest and easiest way to build a data warehouse.
- Data Warehousing
- Data Staging
- Data Lineage Diagrams
- Automated Documentation
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 TX2014, 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
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, TX2014 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 TX2014.
- IBM DB2
- IBM Informix
- NAV 2.60, 3.60, 3.70, 4.00 Native ODBC
- Excel sheets
- Text files
- Generic Microsoft SQL Server
- Generic ODBC Sources
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:
- SAP R/3
- Dynamics CRM
- Dynamics NAV
- Dynamics AX
- Dynamics GP
Tight Integration with Microsoft SQL Server
TX2014 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 TX2014.
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.
Qlikview Modeler and Script Generator
QlikView is a popular presentation tool that enables business users to rapidly build views and dashboards. However, the backend implementation can easily get complex and time-consuming, due to its need for scripting.
In TX2014, you can create QlikView models that are ready for import into your QVW documents. This eliminates the need for scripting in QlikView.
Models generated by TX2014 are optimized for performance by including surrogate keys for composite joins instead of slow and complex synthetic keys. TX2014 also uses the resident clause and allows for storage into QVD files for better performance. You can also include translations to create models in several languages.