Knowledge Base
This section contains in-depth articles and sample use cases for Xtract Universal.
Xtract Universal
- Certificate Renewal for TLS
- Deactivate Usage Data Collection
- Deploy Extractions Using Git Version Control
- Insert Extraction Events into Windows Logs
- Load Balancing
- Proxy Server Settings
- Run Xtract Universal in a VM on AWS EC2
- Target Principal Field (TPN)
- Usage Data Statistics in Xtract Universal
Run & Automate Extractions
- Call Extractions via Script
- Create Extractions via Commandline
- Deploy Extractions Using Git Version Control
- Execute & Schedule all Extractions using an SSIS Package
- Insert Extraction Events into Windows Logs
- SAP Access with Xtract Universal and Powershell
Communication Scenarios
- Access Data in the SAP Public Cloud using RFC BAPI
- Client PSE to connect to SAP Cloud Systems
- Secure Network Communication (SNC) via X.509 certificate
- SNC Authentication for DeltaQ and OHS
- SSO with Client Certificates
- SSO with External ID
- SSO with Kerberos SNC
- SSO with Logon Ticket
SAP-Related Topics
- Check the Accessibility to an SAP System
- Authorize Access to Reports via Authorization Groups
- Create / Configure the Custom Authorization Object Z_TS_PROG
- Import an SAP Transport Request
- Look Up SQL Names of CDS Views
- Register an RFC Server in SAP with Kernel Release 720 and higher
- Supported SAP S/4HANA Versions
Destinations
The following articles refer to specific destinations defined in Xtract Unviersal.
Microsoft Azure:
- Authentication via Microsoft Entra ID for Azure Storage
- Integration in Azure Data Factory using Commandline
- Integration in Azure Data Factory using Webservices
- Call Dynamic Extractions with Variables in ADF
- Run an ADF Pipeline when an SAP Extraction File is uploaded to Azure Storage
Microsoft Fabric (OneLake):
Microsoft SharePoint:
Microsoft SQL Server:
Microsoft Power BI:
Microsoft Power BI Report Server:
Google Cloud:
KNIME:
Snowflake:
Tableau:
Amazon Redshift:
Extraction Types
The following articles refer to specific extraction types defined in Xtract Unviersal.
BAPI:
- Access Data in the SAP Public Cloud using RFC BAPI
- Read Data from Cluster Fields in Tables PCL1 and PCL2 (Payroll)
DeltaQ:
- Create Generic DataSources
- Register an RFC Server in SAP with Kernel Release 720 and higher
- SNC Authentication for DeltaQ and OHS
OData:
ODP:
Report:
- Authorize Access to Reports via Authorization Groups
- Create / Configure the Authorization Object Z_TS_PROG
- Extract Reports with ALV Layouts
- Parse Reports in Xtract Universal
Table:
- Extraction Mechanism of Table
- Delta Table Extraction
- Deprecated /THEO/READ_TABLE Versions
- Look Up SQL Names of CDS Views
- Read data from Cluster Fields in Tables PCL1 and PCL2 (Payroll)
- Working with Lists in the WHERE-Clause Editor
- Working with LIKE operand in WHERE-Clauses
Table CDC:
Last update: January 16, 2026