Starschema

In a tough economical competition for every company it is a must to collect and use all possible business data from all over it's systems - to support the efficient decision making process and so ensure the profitability of business. And this data collection has to be fast, effective and reliable - to make the right decisions on time.
The heterogeneity of business systems makes it difficult to integrate all the data you may need - for example it is not trivial what is the best way to integrate data from SAP and Oracle systems - and how to do it fast, reliable and simple.

PL/SAP Connector will do it for you!

Using PL/SAP Connector may decrease the TCO of SAP data integration by 50-70%. It provides so powerful though easy to use services, that following up business process changes, or supporting business decisions with exact data while meeting tough deadlines, or serving data to any parties of your business will never be a pain again for your company.

The Pentaho BI Suite provides a full spectrum of business intelligence (BI) capabilities including query and reporting, interactive analysis, dashboards, data integration/ETL, data mining, and a BI platform that has made it the world's most popular open source BI suite.

Pentaho's commercial open source model eliminates large, upfront software license fees and dramatically reduces the total cost of ownership for enterprise-class business intelligence compared to traditional, proprietary BI.

Pentaho Enterprise Edition products provide comprehensive technical support, software maintenance, enhanced functionality and more via an annual subscription. Pentaho Enterprise Edition products help organizations achieve BI success and mitigate risk while saving time, money and resources.

Pentaho Community Edition is a free industry leading, MPL licensed commercial OpenSource product, which is a complete, all-around BI solution, incorporating ETL (Kettle), OLAP (Mondrian), standard and ad-hoc reporting tools.

To learn more about Pentaho, gain first hand experience and Test Drive Pentaho 3.5 CE (Community Edition) on our demo server. 

DW SCHEDULER
a simple but effective tool to manage data warehouse loads.

Summary:
DW Scheduler has been designed to ease the everyday work of scheduling, managing, editing and monitoring the daily execution of Oracle data warehouse jobs. With the use of DW Scheduler, you will be able to access all the features of the daily job management without the need of manual editing of tables with 3rd party tools (like Toad, etc) or to write special SQL queries.
DW Scheduler provides a rich and intuitive web based GUI, accessible on the companies intranet. With it's highly flexible security settings even business users can monitor, trigger or schedule their jobs. Our scheduler can replace Oracle Warehouse Builder's workflow module (WF), providing the same functionality with a friendlier and robust web interface.
It runs almost invisible, consumes only minimal resources from the data warehouse back-end database - even in case of high number of jobs scheduled, executed, monitored.
DW Scheduler uses an Oracle based repository database, so it's metadata can be accessed and used by other applications, it can be easily integrated into frameworks built around an Oracle data warehouse.

The protected intelligence

Even the products of biggest software vendors can't remain standalone applications within a company's IT infrastructure. All software elements require the same high level of care, monitoring and support - otherwise unmonitored elements may become the weak-points, and such starting points of problems not only impacting the IT infrastructure, but the whole company.

HelpSheet Generator for Business Objects (XI R2-R3 compatible)

Business Objects XI is an enterprise BI platform, providing plenty of services, hundreds of settings, complex reporting opportunities and many-many more. Of course the meta data repository of such a complex tool will be a jungle for those not spending years with it. If you are using BO for more than just a few users, managing BO environments for complex databases, reporting from multiple datasources - you may already feel the need of analyzing BO's metadata like:

• What reports do we have?
• What data is used in the reports?
• What is "this" specific report about?
• How is the data accessed?
• What calculations are built on the data?
• What if I change this or that in the environment? Who and how will get impacted?

It contains:

• A Java client tool to extract metadata from CMS and to generate HelpSheet-s for WebI reports
• An excel interface to collect manual data for reports (you can add information not available in CMS, like BusinessOwner,Validity, etc)
• A repository schema to store extracted and manual report information.
• VBA Add-In for DeskI data collection and HelpSheet generation.
• A HelpSheet universe to make data available stored in repository.
• A package of reports to ease of understanding, how reports are used, how business data is accessed at your BO deployments.
• Starschema's best practices and support to get out the best from your BO investment.

• Check out the screen-casts about Starsheet capabilities:
  Helpsheet generator
  

• Request on-line or onsite demo
• Download presentations and white-papers

Helpsheet presentation, PDF Document.
Download PDF (95K, Hungarian)

Source-to-Target Mapping for Oracle (STM-O)

Functional Overview

The Starschema's STM-O product is a complete solution for the Oracle Database which analyzes and creates the description of any dataflow executed by SQL or PL/SQL command from source to target.

The final output of the STM-O is a specified set of metadata or rather reports based on this aggregation, which describe the route of the data travelled in the database while being processed.

The smallest (record level) elements describe the role of the database table-field in a dataload phase (source or destination), or rather the transformations made between the two states.