Xtract Universal - Automatic Data Warehousing
"Previously we were not able to bring the SAP data that we need for our reporting into Tableau. Today we can deliver Tableau reports with SAP data fast and reliably to our business users."
Taru Gupta, Business Intelligence Manager at Atmel
Xtract Universal enables you to save data streams from SAP to any destination environment, and thereby significantly reduce development time, thanks to a high degree of automation.
The result is maximum ROI with minimum risk and cost. In addition, Xtract Universal is also virtually independent of the client’s desired or existing data warehouse technology, and can therefore also be integrated into existing data integration landscapes:
Alteryx, Power BI, Oracle, Amazon Redshift, EXASOL, Tableau, Qlik, Microsoft SQL Server, IBM DB2, HP Vertica, Teradata, SharePoint, GoodData, plus generic transport protocols, such as OData, CSV, and HTTP.
Whether intended for use as a data mart solution for individual departments or subsidiaries or as part of an enterprise-wide BI strategy, Xtract Universal can meet all IT and specialist user requirements:
- Central monitoring of all extraction activities and detailed logging
- Wide variety of extraction types that can be used to extract data from all SAP modules and SAP BW
- Security and user management with optional Active Directory (AD) linking for handling highly sensitive data
- Integrated data type safety and traceability, from source through destination
The idea of instant data warehousing with Xtract Universal is to make the load process design as simple, and therefore as fast as possible.
Whether you want to create a company-wide enterprise data warehouse or set up a data mart for a single task or a department, the first step is always to retrieve the relevant data.
Automatic conversion of SAP objects
The relevant destination object can be very easily created from the SAP source object automatically. During this process, the metadata for the object in question is optimally and automatically transferred to the destination. A customer number that consists of 10 digits in the SAP system, for example, will also have 10 digits in the destination system. The accuracy of a value field with three decimal places will not be affected. This process is generally referred to as type safety and is systematically implemented for Instant Data Warehousing.
The processing of data content works just like the automatic procedure for transferring metadata. In the simple case of a full load, the entire SAP object is replicated. Even more interesting is the incremental delta load process, that is, the limiting of the download to the data content that has been changed or added since the last download. The data to be loaded is then updated against the data already available in the target system from previous data runs. The data update can either also be automatic or, depending on the client’s specific requirements, extended to include individual add-ons in the load process.
Xtract Universal supports a number of environments as the target for the data extraction, including
- Azure SQL
- Power BI
- SAP HANA
- Amazon Redshift
- Amazon S3
- SQL Server
- IBM DB2
- HP Vertica
- Generic transport protocols, such as OData, CSV, and HTTP
and some more. In addition, data streams are also provided in other common formats, such as OData, CSV, and HTTP, to facilitate access to target environments that are compatible with such formats (for example, Excel, Access, Tableau and a large number of third party software producers and OEM partners).
The architect or power user decides on the degree of automation. In the simplest case, the SAP source object is replicated in the relevant target environment, where it is compiled automatically together with all its metadata. The data types are transferred with as few changes as possible. Standardized conversion routines (for SAP date fields, for example) guarantee quick results and provide the architect with the best possible support. This, of course, is also the case for updating deltas, that is, data that has changed since the last data extraction.
If desired, every detail of the transfer process can also be managed. This means that the architect can choose to adjust the user and metadata from the SAP source as they wish already during the data transfer process– this can include simple type conversions or format conversions, as well as master data historization, quality checks, and individual routines for updating incremental data.
All of these processes are mapped using the relevant SQL dialects for the target systems and a powerful, in-house script language. Depending on the architecture, other target system options can also be utilized, such as Macros or more complex procedures.
- Based on SAP certified technology*
- Integrate your SAP data in the most different target systems
- Very fast installation and configuration
- Fast, simple & user-friendly; programming knowledge not necessary
- Instant Datawarehousing for maximum design performance
- Minimal to zero intrusion in your SAP system
- Cross-module and module independent
- Business logic is available
- Robust, standardized process for incremental loads (Delta logic)
- Central security concept
- Central monitoring and process monitoring for complete control of SAP access
- Cost savings through optimal integration, no friction losses
*Our SAP certified product ERPConnect provides the kernel for all our products and is responsible for the connection to each SAP system.