The software lets companies extract and transform data from 30 sources, including relational databases, mainframe IMS and VSAM files, and applications, and load it into a database or data warehouse. ADT, known as InfoPump when CA acquired Platinum Technologies in 1999, is the core data extraction and transformation engine. The ADT Enterprise Metadata Edition is an extended version of the software that includes metadata management capabilities for inventorying a company's data assets and tracking changes in data and applications.
Earlier versions of ADT were essentially scripting tools for developing data-transformation code. ADT 2.0 offers pre-built transformations and a graphical interface, both of which can shorten integration projects and improve data consistency throughout an organization. ADT EME 2.0 is more tightly linked with its repository, which should give developers easier access to data-mapping metadata. That product also offers new versioning and life-cycle controls and a new graphical mapping interface.
Companies often forget how many disparate data sources they have when undertaking data-integration projects, Aberdeen Group analyst Guy Creese says. Data-transformation tools are a natural for CA, "drawing on its longtime exposure to tons of different systems," he says.
Pricing starts at $58,000 for ADT and at $96,000 for ADT EME. Windows NT/2000 versions will be available in late April with versions for AIX, HP-UX, and Sun Solaris to follow.