Oracle Pure Extract supports native access to OS/390 platforms:
The OWB repository is a server-based, low maintenance, powerful metadata repository based on the openstandard Common Warehouse Model (CWM). The repository is the central nervous system of the Enterprise Business Intelligence solution provided. All design information regarding sources, trformations and warehouses is available and can be viewed over the web, utilizing Oracle Portal technology. This includes lineage and impact analysis throughout the warehouse.
No, OWB currently doesn’t support these data types.
OWB supports the following source environments:
Oracle Warehouse Builder (OWB) is a framework for creation of extraction, trformation, and loading scripts for populating an operational data store, a data mart or a data warehouse. OWB also includes a component to design the target data warehouse / data mart / operational data store. The design component can be used to create data warehouses designed as star schema (including aggregations / summary levels with multiple hierarchies) or warehouses / operational data stores as third normal form.
Yes, depending on the implementation language, OWB uses either sequences (PL/SQL implementation) or a data generator (SQL*Loader implementation) to product these artificial keys.
Yes, OWB has a wizard-driven design process for both dimensions and for facts. Both can be viewed and printed in a diagramming mode.
Yes, OWB generates code, which can be deployed into the database and it can be deployed into scripts (text files). These text files can be modified and then deployed to the database with the changes. Note that these changes (if made outside of OWB) are not stored in the repository, and that problems with modified scripts are not supported by Oracle.
Yes, OWB let’s you define 3rd normal form schemas with the wizards guiding you through the table creation process. It also provides a simple wizard to design and define keys between the tables.
No, the OWB integrator solution for SAP is not depended on the underlying database. SAP installed on a non Oracle database (Informix, DB2, SQL Server or Sybase) can be accessed with the OWB SAP integrator.
OWB is tuned and build to fully utilize the market leading-Oracle database. OWB is a code generation tool and uses the Oracle database as its trformation engine. The client software must be installed on either a Windows 2000 or NT 4.0 client
Yes, the user can add source objects to a mapping and join these via a joiner. If the tables are connected by key relationships OWB picks these up automatically and populates the join condition without the user having to open the joiner and type this in.
OWB is a code generation tool based on a metadata repository, meaning that the design is trlated internally by OWB, which results in the generation of code. This code can then be used to create a data warehouse and the accompanying data trformations.
OWB delivers a time dimension based on the Gregorian calendar. The user can determine the levels in this dimension and choose from a number of pre built hierarchies.
Due to OWB’s graphical nature, prototypes can be built rapidly. OWB provides a graphical design tool for logical representations of star schema and third-normal-form target databases. It contains automated validation of source to target mappings, and automated code generation of code. SQL DDL for building target tables, SQL*Loader control files for loading data from flat files, PL/SQL for extraction and trformation and TCL to enable registration in Oracle Enterprise Manager.
OWB gives the user a wizard-driven design environment to create the dimensional warehouse schema. Wizards guide the user through the creation of dimensions with multiple levels and hierarchies, the creation of keys on these levels, and the linking of these dimensions to the fact tables. OWB provides wizards for all database objects supported in OWB.