Starschema

In einem schwierigen wirtschaftlichen Wettbewerb für jedes Unternehmen ist es ein Muss zu sammeln und zu benutzen alle möglichen geschäftlicher Daten aus aller Systeme - um das effiziente Entscheidungsbringen zu unterstützen und so die die Rentabilität des Unternehmens zu sichern. Diese Datenerhebung muss schnell, effektiv und zuverlässig erfolgen um die richtigen Entscheidungen auf Zeit zu treffen.
Die Heterogenität der Geschäftssysteme macht es schwierig alle Daten zu integrieren. Es ist nicht trivial zum Beispiel, was der beste Weg sei um Daten aus SAP und Oracle-Systeme zu integrieren. Wie macht man es schnell, zuverlässig und einfach?

PL/SAP Connector tut es für Sie!

Mit PL/SAP Connector kann die TCO von SAP-Datenintegration um 50-70% vermindert werden. PL/SAP Connector is ein sehr wirksames Mittel, aber gleichzeitig ist er einfach zu verwenden. Mit dieser Lösung wird das Folgen und Veränderung von Geschäftsprozessen, oder die Unterstützung der Entscheidungen mit exakten Daten Ihnen nie Probleme verursachen!

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)

Übersicht

Die Starschema's STM-O Produkt ist eine komplette Lösung für die Oracle Datenbank, die analysiert und erstellt die Beschreibung der Datenfluß von SQL-oder PL/SQL-Befehl der von der Quelle zum Ziel ausgeführt wird.

Der endgültige Ausgang des STM-O ist eine bestimmte Menge von Metadaten oder eher Berichte aufgrund dieser Aggregation, die die Route der übertragenen Daten in der Datenbank während dessen Bearbeitung beschreibt.

Die kleinsten (Rekordniveau) Elemente beschreiben die Rolle der Datenbank-Tabelle-Feld in einer Datenladungsphase (Quelle oder Ziel), oder vielmehr die Transformationen die zwischen den beiden Staaten gemacht werden.