Contact Us
    
 
     
 
 Contact a StatSoft Office
 Request a Quote
 
   
Products / Solutions
 
 
   
 
 
 STATISTICA Overview
 Enterprise Solutions
 Web-Based Solutions
 Data Mining Solutions
 Desktop Solutions
 
 
Unique Product Features
 
 
     
 
 
 Summary
 Common STATISTICA
Features
 Features Illustrated
 Customizable User
Interfaces
 Flexible Output
 Documents of Unlimited
Capacity
 Unmatched Quality of
Graphics
 STATISTICA Visual Basic
 STATISTICA Query
 Details about analytic
modules
 
 
Product Information
   
 
     
 
 
 STATISTICA Enterprise
 STATISTICA Enterprise/QC
 STATISTICA Document
Management System
 STATISTICA Data Miner
 STATISTICA Data
Warehouse
 STATISTICA Multivariate
Statistical Process Control
(MSPC)
 STATISTICA Monitoring
and Alerting Server
(MAS)
 STATISTICA: Connectivity &
Data Integration Solutions
 STATISTICA: Analytic
Reporter
 
   
Related Information
   
 
     
 
 
 STATISTICA: Connectivity &
Data Integration Solutions
 STATISTICA PI Connector
 STATISTICA Enterpise Movie
 STATISTICA Enterprise
Brochure (pdf)
 Borden Chemical
Success Story (pdf)
 

 WebSTATISTICA Movie
 
   

STATISTICA
Connectivity to SAP


StatSoft's customers depend on STATISTICA Enterprise for their business intelligence and data mining applications using a wide variety of data from disparate sources. STATISTICA Enterprise streamlines the access between consumers of these analyses and the requisite data by providing central configuration and management of connectivity configurations to your company's data sources, including its Enterprise Resource Planning (ERP) systems, Laboratory Information Management Systems (LIMS), Manufacturing Execution Systems (MES), data historians, data warehouses, etc. Once STATISTICA Enterprise is configured with these data connectivity settings, STATISTICA users, depending on their role in the system, have the requisite access to data extraction, filtering, and drill-down tools.

A popular system from which to query data is SAP. SAP is organized by various modules and component systems. Most often, a request of the type "We need access to SAP data" is quickly followed by a more detailed explanation of the data requirements: data from which SAP modules.

StatSoft and its customers have utilized a flexible assortment of general approaches for connecting and provided SAP data to STATISTICA Enterprise end users. StatSoft does not take a "one-size-fits-all" approach because of the breadth of the SAP system and the variability of SAP connectivity requirements from application to application, customer to customer.


1. SAP Interfaces

SAP publishes certified application programming interfaces (API) as one preferred and supported method for data extraction. These interfaces are a popular approach because they provide structured access to the module data in a way that a) respects the SAP access control and security, and b) is robust to changes in the underlying SAP database schema. For example, for manufacturing quality control application, SAP provides the QM-STI interface for accessing data from the QM module. By configuring STATISTICA Enterprise to utilize the QM-STI interface, customers can configure automated analyses and reports using any of the STATISTICA analytic modules, including Quality Control charts, Process Capability, General Linear Models, Variance Estimation and Precision (VEPAC), etc.


2. SAP Exchange Infrastructure

For some applications, it is more efficient to define the data required for the STATISTICA analyses and configure periodic, automated data extracts to be "pushed" to a standard relational database ("data mart"). SAP's Exchange Infrastructure (XI) provides an efficient and powerful way to set up and manage these configurations in the NetWeaver application server framework.

Once the requisite data are in the data mart, STATISTICA Enterprise Data Configurations are configured to access these data with Analysis and Report Configurations to perform the requisite analysis to support the application needs.


3. Third-Party OLE DB Provider

The popularity of the SAP system has a number of advantages to customers. One advantage is that Third-Party independent software vendors (ISVs) develop and maintain interfaces to SAP data, such as OLE for Databases (OLE DB) providers. OLE DB is a Microsoft standard for accessing data sources. An OLE DB provider is a standards-based approach to providing an interface to a data source so that software applications such as STATISTICA are able to use OLE DB to query them.

STATISTICA has a long history of support for OLE DB and is able to utilize Third-Party OLE DB providers for SAP to provide a powerful, flexible approach to configuring SAP Query Configurations in STATISTICA Enterprise.

For more details about an SAP Connectivity approach to suit your business's application requirements, please call one of our STATISTICA Application Specialists at (0)1234 341226 or email info@statsoft.co.uk.