Thursday, May 22, 2008

WhereScape RED

WhereScape RED provides integrated DW life cycle management functionality for Microsoft SQL Server, Oracle and Teradata deployments. The company’s go-to-market approach includes direct sales to clients, OEM relationships with transactional application vendors, and a network of resellers and consulting partners in the geographic regions in which it operates. WhereScape also provides a freely down loadable working version of its software, which has been an effective method for allowing prospective clients to test-drive the software prior to production deployment,
by building fully-functional small-scale warehouses and marts with WhereScape RED
prior to purchase.

WhereScape RED is a meta data driven DW life cycle management environment. WhereScape RED includes 5 integrated components that support all stages of the DW life cycle process:

  • Source data extraction and loading facilities (native database connectivity, ODBC, XML, flat file)

  • WhereScape RED Applications: Administrator is a developer’s interface for creating repositories within the data warehouse and maintaining schedulers. Integrated development Environment (IDE) is a desktop interface for designing and managing the data warehouse. Scheduler is an optional interface that is used primarily by administrators for job status information.

  • Repository housed within the target DW, the RED Repository is a set of database tables that are installed in each target DW environment. Meta data tables can be accessed by business intelligence tools for query, reporting and analysis purposes. The data warehouse objects created by WhereScape RED are standard database objects such as tables, views, scripts, procedures and indexes. They are always specific to the details of the target database’s SQL or data manipulation dialect: scripts in Teradata can be Multi Load or Fast Load,
    procedures are PL/SQL in Oracle and Transact SQL in SQL Server. RED uses the database as the data transformation engine and also stores all meta data about the objects created in the target DW and about the dependent objects within the repository.

  • Scheduler polls meta data to identify tasks that can be run. It also manages the work flow of dependencies that may exist among jobs or groups of tasks. Tasks can run in the target database or on a separate scheduler platform and initiate loads or procedures specific to databases being used. The scheduler supports multi-platform scheduling and can be called from an existing enterprise scheduler.

  • Dependent Objects located outside the RED repository, dependent objects include OLAP cubes or exports for other downstream systems whose meta data is stored within the RED repository. The scheduler also manages these objects.

Addressing the DW Life cycle Management Process with WhereScape RED

WhereScape RED provides support for all steps of a DW life cycle. It supports both the developers and business users in their collaborative efforts from the definition stage to deployment stage through a series of iterative steps and feedback loops.

Some of the key strengths of the WhereScape RED software include:

Rapid Prototyping
WhereScape itself describes its software as enabling developers to "fail fast and fail early." With WhereScape RED, developers can create prototypes of candidate production schema, populate it immediately with source data (familiar to business users), and adjust the schema in response to business users’ feedback as needed during joint design-prototype-iterate sessions . all within days and in some cases hours. This practices allows business users to see, in real time, the translation of their requests into working data warehouses and/or data marts, and helps BI/DW
practitioners make appropriate accommodations while they themselves get comfortable, incrementally, with those accommodations.

Self-documentation was highlighted as one of the key features of WhereScape RED during interviews with WhereScape customers. Within RED, meta data is created automatically while an architect interacts with the RED desktop interface during the various stages of the data warehousing process. Meta data and other documentation can also be edited or added manually on an as needed basis.

Single Source for Metadata
WhereScape RED stores meta data not only about source systems and the data warehouse objects, but also about the external dependent objects such as OLAP cubes as well as ETL routines. Having a single source for all meta data related to the various steps in DW life cycle management enables administrators, architects and developers to manage and access this meta data more efficiently than if it was distributed in individual repositories of the component tools.

Users of WhereScape RED can also reuse existing tables designed with third party DW modeling tools. In this case the software automatically recognizes that RED was not used as the design tool and retrofits existing DW tables into the RED Repository. This process has been identified as a considerable time saver at organizations, that for various reasons, may chose to work with another modeling tool. This is an example of WhereScape ensuring its product’s compatibility with existing data warehousing tools and environments.

I was given a demo of this product by WhereScape which I called then a framework to build Data Warehouse Application based on industry best practices. I was literally blown away by it. Kind of the same way when I saw Siebel Analytics SRMW model for the first time. The only way I will work on a stand alone implementation of Oracle BI EE would be if client agrees on purchasing this amazing product. Otherwise, they better buy Oracle BI Application since I do not build Data Warehouse from the ground up. Why reinvent the wheel and add unnecessary risk to project which success rate still below 50% when there are product such as this one and Oracle BI Applications in the market?

Siebel Eai
This chapter describes the structure of Siebel integration objects. It describes the Integration Object
Builder wizard, which assists you in building your own integration objects based on Siebel objects.
The chapter consists of the following topics:
■ “Integration Objects Terminology”
■ “About Integration Objects”
■ “Integration Object Base Object Type”
■ “Difference Between Integration Objects and Integration Object Instances”
■ “About Integration Object Wizards”
■ “About the Structure of Integration Objects”
■ “Permission Flags for Integration Components”
■ “About the EAI Siebel Adapter Access Control”

Business Process Management

I just completed two tutorial for for Oracle JDeveloper which I recommend to every one who consider themselves a BI resource. They are:

Defining Business Requirements using UML Use Case diagram in JDeveloper 10g

Modeling Activities for E-Business Integration

I could not complete the last one since I do not have the menu option to complete "Step 8 - Setting E-Business Integration Properties"

Now days, everyone that works in the BI field needs to take into account BUSINESS PERFORMANCE MANAGEMENT, BPM, why? Because applications like Siebel Analytics now Oracle BI set a trend in which drilling into analytics dashboards from the OLTP application is a simple technical procedure; nevertheless, not easy to implement effectively.

It is my believe that in order for a BI application to be truly pervasive. It needs to answer the basic questions who, what and when at the instance the user can pro-actively take action from the information which is being supplied through the interface between OLTP and BI applications.

The following quote is from Jim Ericson editorial "Step By Step" BI Review June 2007.
"I think a casual observer at most companies we study would find that the greatest stumbling block in operational Business Intelligence lie in those neglected, unknown or ad hoc business processes. I do catch myself going overboard on this topic, but how many times does it have to be said: Business processes make up the language that is least abstracted from the psyche of the business itself"

Technical people needs to learn how to speak the business language in order to communicate to its pears in the Business team. I also think Business people need to be less resistance to learn new technology and procedures in order to meet its pears in the Technical team half way. Only then we would be successful implementing the next generation of application which Oracle is bringing to the market.

Oracle BI Applications

"Oracle’s applications have given the company a large, heterogeneous applications and infrastructure installed base. These customers need an integrated way to access, analyze and deliver information and insight from multiple business applications," the trio notes. "[T]he newly branded Business Intelligence Suite Enterprise Edition from the Siebel acquisition—which Gartner previously rated as visionary [in its magic quadrant]—has given Oracle a new opportunity to create a compelling BI platform strategy and become a significant BI platform and applications vendor in 2007 and beyond."


About is an online community that is developed and maintained by the Business Intelligence Network ( and The Data Warehousing Institute (TDWI). This is a comprehensive, centralized resource for professionals in the business intelligence and data warehousing industry. The Business Intelligence Network and TDWI have taken the lead to generate and distribute content within a vendor-neutral environment to promote the advancement and success of the BI/DW industry. By combining the expertise of industry thought leaders, and the collective experience of the BI/DW community, delivers up-to-date information and practical tools that improve industry, enterprise and individual performance.