RESEARCH & RESOURCES

TimeXtender Releases TX DWA

Major upgrade to data warehouse automation solution lets enterprises report directly from data warehouses; improves DW speed, performance, and execution.

Note: TDWI’s editors carefully choose vendor-issued press releases about new or upgraded products and services. We have edited and/or condensed this release to highlight key features but make no claims as to the accuracy of the vendor's statements.

TimeXtender, a provider of data warehouse automation (DWA) software for the Microsoft SQL Server, has released a completely revamped DWA product for the Microsoft SQL Server known as “TX DWA.”  

The product has several major upgrades and new features to help data warehouse developers and users receive reporting and analysis straight from a data warehouse. The new tool also improves speed, performance, execution, and ease of use for numerous DWA tasks.

One of the biggest capabilities offered by TX DWA is machine learning and intelligence or what TimeXtender calls “Intelligent Managed Execution.”  This feature, believed to be the first for the Microsoft SQL Server, is built into the execution and removes the ongoing need by developers to optimize the solution, resulting in significantly faster load times and stronger efficiency. This function can only be done using automation, as traditional deployments use a hand-coded solution and rely on parallel processing.

Companies are now using business intelligence tools to report directly from data warehouses as opposed to using OLAP cubes.  This improvement puts demands on a data warehouse to be structured to deliver data direct to business applications so that the application can understand the data and then can easily be analyzed by the end-user. TX DWA provides many of the calculation tools needed by applications to interpret how all data in the data warehouse fits together, and formulates the relationship between tables so that they can understand each other. TimeXtender has also added and improved several other automation functions in the new TX DWA.

“A data warehouse automation platform such as TimeXtender’s TX DWA allows a company to build a data warehouse much faster than with traditional methods, our goal is to make the process of building, deploying, and maintaining data warehouses faster, better, and easier with each new product release,” said Heine Krog Iversen, CEO, TimeXtender. “The keyword in all this is ‘automation.’ Why should anyone in the enterprise do routine or manual tasks when all this work can be automated?” 

The following features and capabilities are available in the new TX DWA:

Aggregated tables enable users to create aggregations (such as sales per customer per month) that are saved along with the source table in the data warehouse.  

Data access control allows the enterprise to control data access at the data warehouse level, which is important when reporting directly from the data warehouse.  Users can be allowed or denied access to a specific table or granted access to only a subset of the data in a table.

Prioritization enables users to give priority to certain tables and sources to make sure tables are processed as early as possible. It is also possible to stop other tasks from being processed until a specific task has completed.

Maximum number of simultaneous data transfers from a specific data source can be set. This prevents one source from reducing the performance of the entire execution process because it cannot handle more than a few connections.

Safeguards for system errors allow configuration so that the execution does not stop simply because TX DWA cannot reach noncritical systems. Users can choose to keep the newest data from the system until fresh data can be fetched. 

Safeguards for critical errors, which can be fixed and execution can be resumed from where it stopped. This eliminates the potential of hours of delay.  

Easier connection to new data sources thanks to TimeXtender’s AnySource adapter that works with specialized drivers provided by software suppliers or third-party developers that follow OLE DB or ADO standards. This allows users to connect to data sources that are not already supported by TX DWA, and where a driver already exists.

Several other upgrades have been made to remove or automate routine tasks. These include:

  • Time dimension contains indexes that make it easier to compare historical data with present data.
  • Customer periods can track data for seasonal or cyclical patterns to analyze and report.
  • Project variables enable developers to change the same value in multiple places and the change only has to be made once.  
  • Context-sensitive variables such as server environment or user name provides an easy way to handle different development environments.    
  • Dynamic perspectives allow users to create perspectives on a project that automatically includes all tables and objects related to one or more objects that they select.  A dynamic perspective could be developed based on a function such as sales, production, or finance to provide an instantaneous overview of all objects related to this area.

More information about TX DWA is now available direct at www.timextender.com.

 

TDWI Membership

Get immediate access to training discounts, video library, BI Teams, Skills, Budget Report, and more

Individual, Student, & Team memberships available.