Keep track of all your data
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
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
