The Challenge

In addition to choosing the right technology platform, one of the biggest challenges for building a BI system is clean integration of legacy systems.
Microsoft SQL Server can be a good choice for organizations that extensively use SAP. Organizations with Microsoft-based business intelligence solutions benefit from fast response times, low license and maintenance costs, and seamless integration with Microsoft Office, especially Excel. 

OneConnect has been developed to make the it as easy as possible for SAP users to benefit from the advantages of the Microsoft BI platform.

The Product

OneConnect meets the challenge of connecting the source systems by acting as a "universal adapter", enabling seamless enterprise-wide integration of the Microsoft BI platform in SAP ERP environments.
The "Xtract IS component" is a core component, and is developed in partnership with pmOne. OneConnect includes many additional features for use in enterprise deployments, such as:

Interface to SAP BW Extractors
Companies that have SAP BW environments can use OneConnect to access the same data extractors that SAP BW uses to extract data from SAP ERP.

Detailed Monitoring and Logging
All data loading processes traceable through OneConnect's standardized, detailed processing and error logging. This provides a complete overview of the data warehouse data loading processes. Monitoring helps with recognizing issues in an ETL processes early and preventing performance bottlenecks. A analytical model is included that provides detailed information down to the individual error message.

Metadata-driven Configuration
ETL packages are defined once and can be rolled out effortlessly to any number of clients and systems. Monitoring and management is still done centrally.

Flexible and Customizable
The system is flexible and supports customizations for handling data at the source system level, as well as transportation to the target system. Details are definable and changeable using the central console.
Automatic Type Conversion
SAP data types are automatically converted to Microsoft SQL data types. This helps to reduce memory usage for data warehouse solutions and promote better data quality.


  • Build once, deploy anywhere
    Companies with multiple SAP clients or multi-system environments (development, test, production) will benefit from this opportunity.
  • High degree of prefabrication
    Includes a set of pre-built ETL processes for the SAP modules FI, CO, SD, MM.
  • Centralized monitoring and management
    Central monitoring with error analysis capabilities and dashboard.
  • Centralized control
    Provides a central cockpit for system-wide control of data loading processes.

"OneConnect in the SAP environment is an optimal solution for the integration of Microsoft BI. As an alternative to SAP BW it has proven to be a flexible and cost effective solution."
Patrick Theobald, Theobald Software GmbH


  • Protects existing investments by fully supporting existing SAP extractors.
  • Skills and know-how can be reused.
  • Reduced licensing costs (SAP BW).
  • Enables the enterprise-wide deployment of Microsoft BI solutions for SAP ERP customers.



Further information about pmOne is available here.