IBM i Series, Руководство пользователя

Страница: 555 / 908

IBM Licensed Programs: Database Accessories
525
IBM Licensed Programs: Database Accessories
The API supports Visual Basic, C, C++, and other application development
environments 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 applications
that tightly integrate with DB2 OLAP Server for AS/400.
• DB2 OLAP Server for AS/400 for AS/400 Partitioning Option Version 7.1: Provides
a collection of powerful features to make it easy to design and administer
multidimensional databases (cubes or star schemas) that span OLAP applications or
servers. 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 enterprise
data to the iSeries or AS/400e server by transforming and simplifying online
transaction data. The features include:
– Use full SQL support to easily build a data warehouse or data mart. Select specific
data from one or more tables in your OLTP database in DB2/400 and move them to
existing or new tables created “on-the-fly” by Warehouse Builder.
– Call user programs or enter SQL statements to cleanse data before or after the
distribution.
– Implement business rules, such as profit margin formulas, or inventory reorder
thresholds, using Builder’s ability to create result columns and assign them
meaningful names and descriptions.
– Distribute data from DB2 DRDA data sources other than the AS/400, including DB2
Universal 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-Demand
replication between relational sources and targets databases. It defines the architecture for
the comprehensive IBM Data Replication solution.