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!
Starschema's PL/SAP Connector is probably the most powerful yet easy-to-use interface between Oracle RDBMS and SAP systems.
PL/SAP Connector makes all SAP R3 data, functions, business processes available for applications built on Oracle systems. And it does it in a highly innovative way: PL/SAP Connector's functionality is integrated into Oracle RDBMS infrastructure - to provide it's services to any application using Oracle database (ETL tools, DBMS functions, reporting - analyzing tools, middleware, etc.).
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.
If you have manual data entry processes but worried about security,
compliance or data quality, have a look at Starschema’s
StarSheet which provides MS Excel-like functionality through a
centrally managed web2.0 interface. With StarSheet you will be able to
publish your data to databases or BI applications without consuming IT resources but still complying
all your access control, data validation or data retention rules.
StarSheet can collect and manage manual data like plans, corrective
factors, custom hierarchies or any kind of data stored or managed in
excel, and publish it to any kind of databases (and to BI reports or
dashboards - or EPM / EIM products) – without using desktop level
Excel machinations or consuming IT developer resources. Starsheet is
the easiest, though most secure and centrally manageable way to publish
data to any databases or reporting tools.
Check out the screen-casts about Starsheet capabilities:
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.
BORA BI Solution
Before deploying business intelligence systems it is always advisable to think over : will the introduction and use of a BI tool generate as much revenue growth, efficiency increase, cost reduction, business process acceleration to worth the efforts or the money spent?
Oracle Warehouse Builder Job Scheduler
a simple but effective tool to manage data warehouse loads.
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.
Business Objects XI monitoring
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
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?
Starschema's HelpSheet Generator for Business Objects is not only a metadata manager tool, which can extract meta data into a more readable, understandable format, but can even write back the relevant data into the reports - either WebI or DeskI - by showing the information on automaticaly generated new report sheets. So the users of the reports will immediately know what their report do, what data it accesses, who created, who owns the report, and many other usefull information.
- 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.
Helpsheet presentation, PDF Document.
Download PDF (95K, Hungarian)
Source-to-Target for Oracle
Source-to-Target Mapping for Oracle (STM-O)
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.