Xtract Universal

What is Xtract Universal?

Xtract Universal allows you to save SAP data flows to any target environment and thus significantly reduce development time thanks to a high degree of automation.

The result is maximum ROI with minimal risk and cost. In addition, Xtract Universal is also virtually independent of the customer's desired or existing data storage technology and therefore can also be integrated with several existing data integrations:

Alteryx, Power BI, Oracle, Amazon Redshift, EXASOL, Tableau, Microsoft SQL Server, IBM DB2, HP Vertica, Teradata, SharePoint, GoodData, plus generic transport protocols such as OData, CSV and XML

Sizing and security: Ready for business

Intended for use as a smart data solution for individual departments or subsidiaries or as part of an enterprise BI strategy, Xtract Universal can meet all it needs and expert users:

Central monitoring of all extraction activities and detailed loggingWide variety of extraction types that can be used to extract data from all SAP and SAP BW modules

Active Directory (AD) optionally binding user security and management for highly sensitive data manipulation

Integrated data security and traceability, from source to destination

Instant Data Warehousing - Maximum Design Performance

The idea of storing instant data with Xtract Universal is to make the design of the loading process simple and therefore as fast as possible.

If you want to create an enterprise-wide enterprise data store or set up a smart data solution for a single task or department, the first step is to always retrieve the relevant data.

Automatic conversion of SAP objects

The relevant target object can be easily created from the SAP source object automatically. During this process, metadata for the object in question is transferred optimally and automatically to the target. A customer number consisting of 10 digits in the SAP system, for example, will also have 10 digits in the target system. The accuracy of a value field with three decimal places will not be affected. This process is generally referred to as security type and is systematically implemented for "Instant Data Warehousing".

Data content processing acts as 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 process of delta load, that is, the limitation of downloading to the data content that has 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 the previous data. Data refresh can also be automatic or, depending on customer-specific requirements, extended to include targets

Xtract Universal supports multiple environments as a destination for data extraction, including

Alteryx

Power BI

Oracle

Redshift of the Amazon

EXASolution

Picture

SQL server

IBM DB2

HP Vertica

Teradata

SharePoint

GoodData

Generic transport protocols such as OData, CSV, and XML

And a few more.

In addition, data streams are also provided in other common formats, such as OData, CSV, and XML, to facilitate access to target environments that support these formats (for example, Excel, Access, Tableau, and a large number of third-party Software Manufacturers and OEM partners).

The architect or potential 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 automatically compiled along with all of its metadata. Data types are transferred with as few changes as possible. Standardized conversion routines (for SAP date fields, for example) ensure fast results and provide the architect with the best possible support. This, of course, is also the case with updating deltas, that is, data that has changed since the last data extraction.

If desired, all details of the transfer process can also be managed. This means that the architect can choose to adjust the user and SAP source metadata as they wish already during the data transfer process – this can include simple type conversions or format conversions, as well as master data history, quality checks, and individual routines for updating incremental data.

All of these processes are mapped using sql dialects relevant to the target systems and a powerful built-in scripting language. Depending on the architecture, other target system options can also be used, such as macros or more complex procedures.

Advantages with Xtract Universal

Based on certified SAP technology

Integrate your SAP data into the most different target systems

Very fast installation and configuration

Fast, simple & user-friendly; No programming knowledge required

Instant Datawarehousing for maximum design performance

Minimal or zero intrusion into your SAP system

Cross-module and independent module

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 without friction losses

Xtract Universal certified by ERPConnect provides the kernel for all our products and is responsible for connecting to each SAP system.

SYSTEM REQUIREMENTS

SAP supported

SAP R/3 Version 4.0B and higher versions, or, SAP ECC.

SAP S/4 Hana

SAP BW Version 3.1 e superior.

SAP Authentication

Custom authentication.

SAP authentication: Single Sign On (SSO) or SAP credentials.

SAP system or user dialog with appropriate authority objects.

Operating system

Windows XP

Windows Vista

Windows 7

Windows 8

Windows 10

Windows Server 2003

Windows Server 2008

Windows Server 2008 R2

Windows Server 2012

Windows Server 2012 R2

Other applications and Frameworks

.NET Framework 4 or higher.

Visual C++ 2005 Runtime.

Librfc32.dll if SAP GUI is not installed.

Memory

At least 4 GB, depending on the volume of data, more space may be required.

Hard drive space

For installation, 100MB is required.

32/64-Bit Environment

The product can be installed and both 32/64-bit environments.

Network Settings

The ports below should be open depending on the SAP System where NN is the instantiation of the SAP System number.

SAP Application Server: Porta 33nn

SAP Message Server (Load Balancing): Porta 36nn

Secure Communication Network (SCN): Porta 48nn

SAP Router: Gate 3399