Witness the power of automation

Visually identify where data originates and how it is used

Determine the impact and decide if a change is feasible

Automatically generate full documentation and version control

Automatically connect and extract data from virtually any source

Keep track of all your data

Data
Lineage

As the volumes of data multiply, information about the data lifecycle becomes even more critical. The data lineage capabilities of TX DWA work like an x-ray for data flow in the organization and show where the data comes from. It makes a very cumbersome process easy to manage as data lineage is created automatically on a project basis. Which means it will never be out of sync.

TX DWA

  • Tracks all objects and their dependencies
  • Delivers an end-to-end visual representation that helps improve data governance and assists in the response to regulations like Sarbanes-Oxley, HIPAA, Basel II
  • Provides a complete audit trail of the data point of interest from the final destination to the source

Example: If you find yourself questioning a figure in a report, you can use the data lineage feature in TX DWA to trace that number back to its origin by simply clicking on the data point. This allows users to answer questions like:  “What are the sources for the report I’m looking at?” and “Which transformations have been applied to the data?” Answers to these questions ensure a higher level of trust and assist with achieving regulatory compliance in many industries, including  healthcare, finance, banking, and manufacturing.

Impact
Analysis

One key challenge of any integration effort is determining the impact that changes may have. The impact analysis capabilities built into TX DWA addresses this challenge and enables you to perform impact analysis on tables and fields automatically. By identifying dependencies you can get the full picture and assess the impact of change.

TX DWA

  • Shows the movement of data within projects or multiple projects
  • Identifies dependencies
  • Helps you determine the impact of change

Example: If you are merging data from two systems and need to change the name of a field from Sales to North American Sales, TX DWA detects the change automatically and provides an overview so you can see what’s been synced, deleted, changed; and corrected. Similarly, IT analysts can get answers to questions regarding impact of change, including “Which assets and processes would be affected if I change this column?” and “what will happen is I delete a table?” TX DWA shows these consequences.

Auto-Generate
Documentation

The robust documentation that’s generated automatically by TX DWA can help you maintain regulatory compliance in response to legislation like Sarbanes-Oxley, HIPAA, or Basel II.  With the click a button, it will read the entire metadata model and describe it in a PDF.

Here you can create the content that will be used within the module.

TX DWA

  • Allows you to see the settings, description and code for every object
  • Ensures that the documentation is always up to date
  • Automatically generates documentation to assist with audit and regulatory compliance

Example: For audit and other purposes, you might need printed documentation of your project. TX DWA lets you create full documentation of a data warehouse, a business unit or an entire project with a few clicks. The documentation contains names, settings and descriptions for every object as well as the code where applicable.

Quickly and accurately extract
data from source systems

Adapters

TX DWA can connect and extract data from virtually any data source and comes equipped with Intelligent Adapters for some of the most popular source systems. These adapters retrieve data using the business logic of the source systems and retrieves additional metadata which helps the user get a quicker understanding of where valuable data is located.

TX DWA

  • Connects and extracts data from any data source
  • Imports data with speed and accuracy
  • Provides Intelligent Adapters for the most popular source systems

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