Features in the InfoSphere Warehouse on System z offering include:
Simplified ELT (Extract-Load-Transform) Data Transformation Tool (SQW)-DB2 based data movement and transformation.
Customers can build and populate their data warehouses and data marts with IBM InfoSphere Warehouse on System z without the expense of moving data out of the DB2 for z/OS environment. SQW provides data flow, data transformation and control flow operations required to load data in the proper format into your analytic data store. It provides these services by making use of the power of the DB2 relational database engine and the SQL language. It also provides sequencing and flow control functions and functions to integrate non-database processing. Its features include:
SQL-based data movement and transformation features
- Restart control flow from failure point
- Load data-sets from server
- Staging table tuning: creating indexes, range partition, runstats
- Order by 'get first n rows'
- Flow debugging and execution visual enhancements
- Online and offline modes of flow designing
- Virtual columns, expressions sorting, filtering enhancements
SQW Runtime features
- Parallel execution in control flows
- Sub process modularizations
- Sub process modularizations
- Variable enhancements, reserved system variables
- Activity skip during execution
- Enhanced diagnostics (user control with file write operator), logging and instance maintenance capabilities
Access to multidimensional data with no-copy OLAP analytics
InfoSphere Warehouse on System z customers can also build and deploy multidimensional analytics with Cubing Services. It empowers users to ask intuitive and complex ad hoc questions about their enterprise, such as, "What is my product's profitability for this quarter across my territory?" This type of business query requires the grouping, aggregation and calculation of information across various business dimensions, such as time, product, customer, and supplier. Cubing Services is designed to resolve just this type of multidimensional query, known as Online Analytical Processing (OLAP).
Cubing Services can lead to substantial new insights over traditional outboard cubing technologies. With its ability to scale to over a terabyte users are no longer forced to aggregate their data (sum) losing visibility to detail level activity. This means that the root cause analysis will have drill down capabilities to the individual transaction or product. Leveraging data directly from the warehouse, Cubing Services does not require the overhead of copying data into a third-party technology. Fully integrated into the InfoSphere Warehouse on System z design and administrative warehouse tools, Cubing Services provides the ability to achieve lower design and maintenance costs over external cubing solutions.
With InfoSphere Warehouse 9.7 users will see:
- Stronger governance with dimensional security
- High performance and low latency improvements, including virtual cube support
- Improved modeling, design and management usability
Use a wide variety of BI tools
Cubing Services supports the industry standard multidimensional (MDX) query language as well as industry standard OLAP client APIs that immediately enable the following industry leading BI tools:
- OLE DB for OLAP (ODBO): Microsoft Excel, Third party vendors
- XML for Analysis (XMLA): IBM Cognos BI, Third party vendors
Cubing Services provides OLE DB for OLAP (ODBO) support that enables third-party BI tools to access multidimensional cubes. In addition, Excel Pivot Table Services support allows any Excel user to access the same cubes through a familiar tool. Because the cubes are accessed through Excel, this is available to users without requiring the installation of additional BI tools.
XMLA enablement allows Cognos BI tools and applications to more fully leverage the power of the InfoSphere Warehouse on System z through first class access to Cubing Services cubes. Cognos BI for Linux on System z can now query Cubing Services cubes, so you can now use these cubes to:
- Execute simple ad hoc queries with Query Studio
- Do advanced ad hoc analysis with Analysis Studio
- Deliver standard reports with Report Studio
- Use the results to build and deploy IBM Cognos dashboards
- Integrate with Microsoft Office via IBM Cognos Business Intelligence
Eclipse based design studio
Design Studio makes it easier to model, design, and implement analytic structures in the warehouse, and also helps populate and maintain them. This workbench can be extended with simple-to-build Eclipse-based plug-ins. Design Studio provides the plug-in for physical database design and provides an easy-to-use environment supporting the following capabilities:
- Flexible, extensible (plug-ins), easy-to-use eclipse environment
- Design: Logical Entity Relationship design with Rational Data Architect plug-in (optionally available from Rational); Physical design
- Extract, load, and transform
- Data movement and transformation
- Scripting
- Cube and Materialized Query Table
- Debugging and testing
Physical Modeling
IBM InfoSphere Warehouse on System z now enables DB2 for z/OS customers to leverage the powerful physical database modeling and implementation capabilities of Rational Data Architect (RDA), a rich extensible Eclipse-based design and modeling environment. Packed with graphical modeling, collaborative teaming and model metadata synchronization and sharing features, RDA physical modeling provides the solid foundation on which more advanced data warehousing features are delivered within the complete InfoSphere Warehouse on System z solution.
Browser based Administration Console
Also included as a foundation of the offering is the browser-based Administration Console which provides a common browser interface to manage data warehouse resources, schedule and monitor data warehouse processing jobs and to configure and manage multidimensional cubes and cube servers. The Administration Console also provides a command line interface, troubleshooting, statistics, and logs and traces.
