1、inum, PowerMart was released in 1996). As a result, InfoPump is installed at about 300 customer sites worldwide, whereas PowerMart claims just 60 customers in its first year. rHowever, since the marketplace is beginning to demand an easy-to-use tool in this market space, PowerMart is gaining market
2、share much more quickly than code-driven tools like InfoPump. One item of note is that Informaticas first customer was Microsoft. rPlatinum has been in the server-based ETL business since acquiring Trinzic and much of its development team in 1994. Informatica has only been in business since 1996 but
3、 counts former Evolutionary Technologies Inc. (another ETL vendor) and Sybase employees among its development team. rPlatinum has an alleged and yet unconfirmed alliance with Microsoft in the development of its next generation of InfoPump, due in 1998. Microsoft is also alleged to be using Platinums
4、 client-server repository as the basis for the next generation of BackOffice. This is also unconfirmed. rInformatica has created a metadata specification called MX (Metadata Exchange), which allows end user tool vendors to integrate PowerMarts metadata with theirs. Among the vendors which have made
5、their tools MX-compliant are Andyne, Cognos, Brio and Business Objects. Bell Mobilitys current end-user tools are Andyne GQL, Logic Works and Cognos PowerPlay. G:dataclientsmanulifeitedwreportsarch0309.ppt - 49 49 Manulife Financial Enterprise Logical and Physical Architecture Appendix “A” - Data Tr
6、ansformation, Extraction, Transfer and Load (Contd.) Evaluation Criteria Data Extraction Metadata Driven rDefinition: Whether the metadata offered by the tool plays an active role in defining and maintaining the extract, transform and load process. r“Codeless” Development rDefinition: The extent to
7、which program code must be written by hand. rData Transformation rManipulate Data rDefinition: The ability of the tool to handle data manipulation routines such as string manipulation, data type conversions, date conversion, arithmetic and boolean logic, if-then-else, looping, etc. rAggregation and
8、financial officers think about revenues and expenses in different business units for different accounting periods. Relational OLAP (ROLAP) rROLAP tools provide multidimensional capability on top of relational technology (RDBMS) by adding the ability to create complex decision support metrics which c
9、an be rotated, sliced and diced in a number of ways. Tools in this category are able to take advantage of the data management capabilities of a RDBMS, ROLAP implementations support the ability to drill down from the highest level of summarization down to the lowest level of detail all within the sam
10、e data structure. Recommended Data Mart Technology (Hybrid OLAP) rHybrid OLAP provides the best of both MOLAP Logic Works; Platinum Technology; Powersoft; Rational Software; SAS Institute; Sterling Software. More information is available at Metadata Coalition Metadata Interchange Specification (MDIS
11、): rThe Metadata Coalition was founded in October 1995 by a group of industry-leading vendors aiming to define a tactical set of standard specifications for the access and interchange of Metadata between software tools. Participation in the Metadata Coalition is open to all vendors and end users. MDIS version 1.1 (01Aug97) is available at MDIS and Microsoft Repository: rMetadata Coalitions announcement 4Dec97 that it will support an emerging Metadata standard for the Microsoft Repository, which has gained a significant following among