Informatica Corp, Menlo Park, California, says new programs it unveils this week will enable users to create flexible networks of data marts which can be interrogated individually or as a single information source by decision support tools. PowerCenter 1.0 links multiple data marts by registering information about each in a shared database which uses metadata – information about data stored in the data marts – providing each with a view of data stored across the enterprise not just in its local store. Data models, column definitions and data changes can also be stored in PowerCenter and made available for use in each data marts. The company says its new program also enables developers to join files together from many different sources – including certain native mainframe files – without the need for special gateway or transformation software. It also allows multiple data marts to be managed from a single console. Version 4.0 of Informatica’s PowerMart software for creating data marts has been re-architected using components which it says means data for use in marts can be extracted and transformed more quickly and in greater chunks and than previously. The company says a new graphical interface improves the representation of processes and makes transformations available for sharing and re-use. PowerCapture 1.1 which captures information into the data mart and changes databases using information from operational systems has been enhanced to better synchronize warehouse and operational data. An MX PowerPlug plug-in developed by Seattle, Washington- based Yaletown Technology enables data models developed using Logic Works’ Erwin or Sybase PowerDesigner to be imported directly into the Informatica meta data repository. Production versions of the new Power software will be available next quarter. PowerCenter starts at $225,000; PowerMart 4.0 at $40,000; PowerCapture 1.1 at $100,000 and PowerPlugs at $10,000. They work on Unix and NT systems and with most major databases.
รก
