1. Analytical Application Infrastructure User Guide
  2. Data Management Framework
  3. Data Management Tools

Data Management Tools

Data Management Tools is a software application based on the ETL (extract-transform-load) structure, which is used for data transformation and merging. The E-LT (extract-load, transform) structure in Data Management Tools eliminates the need for a separate ETL server, and the analytical rules facilitate to optimized performance, efficiency, and scalability.

Figure 7-1 Illustration of Data Management Tools


This image displays the Illustration of Data Management Tools.

The Data Management Tools module is equipped with a set of automated tools and a tested data integration methodologies that allows you to position the advanced N-tier web-based architecture and integrate the enterprise data sources from the mainframe to the desktop.

In Data Management Tools, you can standardize and integrate the various source system data into a single standard format for data analysis. You can also populate the warehouse in a defined period using the ETL process for data extraction, transformation, and loading.

Following are the prerequisites while working with Data Management Tools:

  • You can transform data using the options - Before load, While load or After Load.
  • For source system information, filenames can be either fixed or delimited in length.
  • The source types that can be loaded into the system are RDBMS and Flat-Files. For an RDBMS source type, ensure that the appropriate drivers are installed.
  • Ensure that you are aware of the process flow before you start with the extraction, transformation, and loading process.

As part of the 8.0.6.0.0 release, Data Management Tools User Interface is re-organized and OJET/ALTA theme is adapted for better usability. All metadata in DMT is now persisted in Database instead of XML files.

Note:

For migrating DMT metadata in previous versions to 8.0.6.0.0 version and above, see DMT Metadata Migration Guide.