Chapter 2. Overview of InfoSphere Warehouse Advanced Edition 67
– A scalable platform that enables companies to solve large-scale business
problems through high-performance processing of massive data volumes.
By leveraging the parallel processing capabilities of multiprocessor
hardware platforms, IBM InfoSphere DataStage Enterprise Edition can
scale to satisfy the demands of ever-growing data volumes, stringent
real-time requirements, and ever-shrinking batch windows.
– Comprehensive source and target data sources support for a virtually
unlimited number of heterogeneous data sources and targets in a single
job includes text files; complex data structures in XML; ERP systems such
as SAP and PeopleSoft; almost any database (including partitioned
databases); web services; and business intelligence tools such as SAS.
– Real-time data integration support operates in real-time. It captures
messages from Message Oriented Middleware (MOM) queues using JMS
or WebSphere MQ adapters to seamlessly combine data into conforming
operational and historical analysis perspectives. IBM InfoSphere
Information Services Director provides a service-oriented architecture
(SOA) for publishing data integration logic as shared services that can be
reused across the enterprise. These services are capable of
simultaneously supporting high-speed, high reliability requirements of
transactional processing and the high volume bulk data requirements of
batch processing.
There are points of integration between InfoSphere Warehouse and
InfoSphere DataStage. An example is the ability for Design Studio to both
import datastage flows and call for the execution flows on an InfoSphere
DataStage system.