IBM Licensed Programs: Database Accessories 525IBM Licensed Programs: Database AccessoriesThe API supports Visual Basic, C, C++, and other application developmentenvironments and works with Windows 95/98, Windows NT, and UNIX.• Extended Spreadsheet Toolkit: Includes more than 20 macros and Visual Basic (VB)functions, allowing the user to build custom Lotus 1-2-3 or Microsoft Excel applicationsthat tightly integrate with DB2 OLAP Server for AS/400.• DB2 OLAP Server for AS/400 for AS/400 Partitioning Option Version 7.1: Providesa collection of powerful features to make it easy to design and administermultidimensional databases (cubes or star schemas) that span OLAP applications orservers. The functions can:– Integrate multiple physical cubes or stars into a single logical cube– Centrally administer and share metadata– Allow the connection of cubes and stars with varying dimensionality– Allow partition replication between centralized and distributed cubes and stars• DB2 OLAP Server for AS/400 for Builder Version 7.1: Assists in moving enterprisedata to the iSeries or AS/400e server by transforming and simplifying onlinetransaction data. The features include:– Use full SQL support to easily build a data warehouse or data mart. Select specificdata from one or more tables in your OLTP database in DB2/400 and move them toexisting or new tables created “on-the-fly” by Warehouse Builder.– Call user programs or enter SQL statements to cleanse data before or after thedistribution.– Implement business rules, such as profit margin formulas, or inventory reorderthresholds, using Builder’s ability to create result columns and assign themmeaningful names and descriptions.– Distribute data from DB2 DRDA data sources other than the AS/400, including DB2Universal Database running on OS/390, AIX, and Windows NT.IBM DB2 DataPropagator Version 7.1 for AS/400 (5769-DP3)DB2 DataPropagator Version 7.1 provides read-only, update-anywhere, and on-Demandreplication between relational sources and targets databases. It defines the architecture forthe comprehensive IBM Data Replication solution.
