At noventum, we very often deal with the connection of SAP systems to Microsoft-based data platforms. Both on Azure with ADF and Azure SSIS or locally with SSIS and often with XtractIS from Theobald.

The supreme discipline of data extraction from SAP is the connection of data via SAP BI Content Datasources.

SAP systems offer advanced interfaces, which on the one hand provide delta mechanisms. On the other hand, these bring together a wide variety of base tables in order to simplify processing. This functionality can be accessed with the help of Microsoft SQL Server Integration Services and the 3rd party component XtractIS from Theobald. We have used this technology successfully many times in the last 10 years (e.g. BRITA).