Knowledge Base

SAP-Related Topics

• Access Data in the SAP Public Cloud using RFC BAPI
• Create / Configure the Custom Authorization Object Z_TS_PROG
• Import an SAP Transport Request
• Replicate Reports as CDS Views

Network & Communication

• Create a Client PSE to connect to SAP Cloud Systems
• Install an X.509 Certificate to Enable TLS for Xtract Universal.iQ
• Container Directories
• SNC Authentication with SAP Application Servers

BAPI

• Access Data in the SAP Public Cloud using RFC BAPI

ODP OData

• Create OData Services for CDS Views
• Create ODP OData Services using the SAP Gateway Builder

Report

• Authorize Access to Reports via Authorization Groups
• Create / Configure the Authorization Object Z_TS_PROG
• Replicate Reports as CDS Views

SAP Transaction Services

• Transaction IE01 - Create Equipment
• Transaction PA40 - Personnel Actions
• Transaction VA02 - Change Sales Order
• Transaction XD02 - Change Customer Master Data
• Table Parameters

Table

• Extraction Mechanism of Table
• Look Up SQL Names of CDS Views
• Working with LIKE operand in WHERE-Clauses

Table CDC

• Extraction Mechanism of Table CDC
• Initial Table Load in SAP Versions < 7.10

Microsoft Azure Storage

• Authentication via Microsoft Entra ID for Azure Storage

Microsoft Power BI

• Dynamic Table Extractions with Power BI

Microsoft Fabric

• Incremental SAP Data Load to a Microsoft Fabric Medallion Lakehouse

Microsoft SQL Server

• Custom SQL in Database Destinations
• Merge Data in Database Destinations
• Post-Processing Column Name Formats
• Collation Settings for Microsoft SQL Server Destination

Microsoft Copilot

• Sync Copilot with SAP using Power Automate and Xtract Universal.iQ
• Xtract Universal.iQ MPC Integration with Microsoft Copilot
• Xtract Universal.iQ MPC Integration with Microsoft Power Platform

Microsoft Power Automate

• Integrate a Service with Power Automate
• Formats and Conversions in Power Automate
• Xtract Universal.iQ MPC Integration with Microsoft Power Platform

Alteryx

• Integrate an Xtract Universal.iQ Service with Alteryx One
• Integrate an Xtract Universal.iQ Service with Alteryx

Ambersearch

• Xtract Universal.iQ MCP Integration with ambersearch

Langdock

• Integrate an Xtract Universal.iQ Service with Langdock
• Xtract Universal.iQ MCP Integration with Langdock

n8n

• Integrate an Xtract Universal.iQ Service with n8n
• Xtract Universal.iQ MCP Integration with n8n

Nintex Automation Cloud Integration

• Integrate an Xtract Universal.iQ Service with Nintex
• Integrate an Xtract Universal.iQ Service via Nintex Gateway

Postman

• Run an Xtract Universal.iQ Service in Postman