Xtract IS

提取任意SAP系統的數據，並將其整合至SQL Server Integration Services流程中——極其簡單且完全自動化

集成SAP數據之後，微軟環境中的分析和報告類解決方案將變得更有價值，並為您提供更多洞見。

作為SSIS 的插件，Xtract IS能確保SAP數據快速、可靠且自動地提取到其他微軟環境，以作進一步處理。得益於內置的各類連接組件，所有數據流和數據提取設計都可以高效完成。

工作原理

如果客戶已經使用或計劃使用Microsoft Integration Services (SSIS) 作為搭建企業級數據集成和數據轉換解決方案的平台，Xtract IS 解決方案是最理想的選擇。SSIS 是最受歡迎的ETL 解決方案之一，客戶可利用它提取或轉換來自不同數據源（例如平面文件或關聯式數據源）的的數據，然後將這些數據載入一個或多個目標終端。

對於SSIS 開發人員而言，這意味著您可以繼續在熟悉的SQL Server Data Tools (SSDT) 環境中工作，連接到一個或多個SAP 系統，並對SAP 數據流進行設計和測試。SSIS 工具箱中提供了用於連接至SAP 的Xtract IS 源組件，跟其它所有標準SSIS 數據源、轉換和目標工具一樣。只需點擊幾下鼠標，即可輕鬆拖放和配置SAP 源，無需任何編程或腳本。

對於SSIS管理員而言，這意味著針對SAP數據流的SSIS包部署、調度和監控與其他的數據流無異。

利用Xtract IS，您可以將SAP數據複製到數據存儲中心或其他選中的存儲方案，雲端或本地均可使用。Xtract IS 支持海量數據複製和不間斷、持續增長的SAP數據推送。

特色

• 基於SAP 認證技術*
• 只需對您的SAP 系統作微小改動或零修改
• 極速安裝和設置
• 快速、簡便、用戶友好性高；不需要編程知識
• 跨模塊且模塊獨立
• 100%的類型安全和全面的元數據支持
• 業務邏輯可用
• 穩定、標準化的增量數據載入流程（Delta Logic）
• 讀寫無縫集成
• 通過最優化集成節省費用，無兼容性損失
• 通過最佳集成節省費用，無摩擦損失

*我們的SAP 認證產品ERPConnect 為我們的一切產品提供內核，並負責連接所有的SAP 系統。

Xtract Universal 

無論您需要在哪裡使用SAP數據，都可以通過Xtract Universal來完成。

無論是數據庫、數據分析工具、BI 解決方案或云解決方案——SAP數據都可以分別放入任何目標環境。並且它的自動化程度非常高，無需長時間的開發。作為一個獨立解決方案，Xtract Universal 獨立於任何現有的ETL或數據倉儲解決方案，它可以輕鬆地無縫融入到您現有的數據集成架構和解決方案。不同的、集成式SAP源連接組件會確保無論SAP數據以何種形式存在何處，您都可以輕鬆獲取。

工作原理

Xtract Universal 是一款靈活獨立的解決方案，能夠滿足您的SAP 數據集成需求。作為Xtract 系列的一員，它與其他Xtract 產品一樣具備成熟可靠的SAP 數據提取功能。

通過Xtract Universal Designer，用戶只需點擊幾下鼠標，即可連接到一個或多個SAP 系統，並完成SAP 數據提取的配置，無需任何編碼或腳本。數據預覽和日誌功能能幫助您開發各種SAP數據提取。

從SAP中提取數據之後，您就可以將其傳輸至產品支持的20多個目標環境。包括最常見的數據庫系統（SQL Server、PostgreSQL、Oracle）、廣受歡迎的雲存儲服務（AWS Redshift、AWS S3、Azure Blob、Azure Data Lake、Azure SQL、Snowflake），以及各種先進的分析工具（Alteryx、Power BI、Qlik、Tableau）。

輕鬆修改SAP數據推送，使其包含新的數據元素或傳輸至其他目標終端，以適應您不斷變化的業務需求；且無需昂貴費時的ABAP編程週期。

Xtract Universal支持海量數據複製和不斷增長的SAP數據推送。您可以同時運行多個SAP數據提取，使其完全自動化並對其進行監控。通過內置的安全功能，您可以控制敏感SAP 數據的訪問權限。

 特色

• 基於SAP 認證技術*
• 可將您的SAP 數據集成到完全不同的目標系統中
• 極速安裝和設置
• 能實現最佳設計性能的實時數據倉庫
• 只需對您的SAP 系統作微小改動或零修改
• 跨模塊且模塊獨立
• 業務邏輯可用
• 穩定、標準化的增量數據載入流程（Delta logic）
• 中央安全性概念
• 進行中央監控和過程監控，從而全面控制SAP 訪問
• 通過最優化集成節省費用，無兼容性損失

*我們的SAP 認證產品ERPConnect 為我們的一切產品提供內核，並負責連接所有的SAP 系統。

ERPConnect

.NET Framework
ERPConnect (without LINQ to ERP) consists of two .NET assemblies that target different frameworks:

• ERPConnect35.dll (targets .NET Framework 3.5 SP1)
• ERPConnectStandard20.dll (targets .NET Standard 2.0)

That results in the following compatibility matrix:

SAP Releases
All communication with SAP is performed via the RFC protocol. That means, the integration occurs at SAP application server level. Therefore, the database used by the SAP system is irrelevant - all databases (including HANA) are supported. This also means, that the operating system of the SAP system is irrelevant - all operating systems are supported. SAP Systems running on Big Endian and Little Endian hardware are supported.

SAP Releases 4.6C and newer are supported. This includes:

• SAP R/3 Version 4.6C and later
• mySAP
• SAP ERP / ECC 5.0 / ECC 6.0 (including all EhPs)
• SAP Business All-in-One
• SAP Business Suite 7
• SAP S/4HANA
• SAP BW 3.1 and later
• SAP BW/BI 7.x
• SAP BW/4HANA
• SAP Application Server ABAP, Message Server, Router, Standalone Gateway

SAP Business One, SAP Business Objects and SAP Public Cloud Versions are not supported.

Installation of custom function modules / transport requests is not required.

Operating Systems

• Windows 10
• Windows 11
• Windows Server 2019
• Windows 8.1 (until 10.01.2023)
• Windows Server 2016 (until 12.01.2027)
• Windows Server 2012 R2 (until 10.10.2023)
• Windows Server 2012 (until 10.10.2023)

Visual Studio

• Visual Studio 2022
• Visual Studio 2019
• Visual Studio 2017
• Visual Studio 2015 (until 14.10.2025)
• Visual Studio 2013 (until 09.04.2024)

Other Applications and Frameworks #

• SAP NetWeaver RFC Library 7.50
• Visual C++ 2013 Runtime

Netweaver RFC Library
ERPConnect supports the Netweaver RFC (SDK) as of version 4.6.0.
To use it, set the Property Protocol of the R3Connection object to ClientProtocol.NWRFC before opening the connection (default setting).

For 64-Bit environments the following DLLs are required:

• ERPConnect35.dll or ERPConnect45.dll
• sapnwrfc.dll
• icuucXX.dll
• icudtXX.dll
• icuinXX.dll

XX can vary depending on the version of the NW RRC Libraries.
The ERPConnect*.dll is delivered with ERPConnect. The other DLLs can be downloaded from the SAP web site.

Memory
2 GB or more recommended (depends on actual use case)

Disk Space 
About 50 MB disk space are required for a full installation.

32/64-Bit Environment 
Both x86 and x64 platforms are supported.

Security Settings 
For logging on to SAP, a system or dialog user with appropriate authority objects is required.
Plain authentication (user/password), Secure Network Communications (SNC) with and without Single Sign-On (SSO) and SAP Logon Tickets (MYSAPSSO2) are supported.

Network Settings 
Ports need to be opened depending on the SAP System connection technique. Details can be found in the knowledge base article How to check the accessibility to a SAP System.

Xtract IS

Supported Visual Studio Versions #

• Visual Studio 2015
• Visual Studio 2017
• Visual Studio 2019
• Visual Studio 2022
• Note: To create SSIS packages in Visual Studio, SQL Server Data Tools (SSDT) are required. Make sure to use the SSDT that correlates to your SQL Server version. For more information, see Microsoft Documentation: Download SQL Server Data Tools (SSDT) for Visual Studio.

Supported SQL Server Versions #

• SQL Server 2014
• SQL Server 2016
• SQL Server 2017
• SQL Server 2019
• SQL Server 2022

Supported SQL Server Integration Services (SSIS) #

• SQL Server Integration Services (SSIS) 2014 SP3 (until 2024-07-09)
• SQL Server Integration Services (SSIS) 2016 SP2 (until 2026-07-14)
• SQL Server Integration Services (SSIS) 2017 (until 2027-10-12)
• SQL Server Integration Services (SSIS) 2019 (until 2030-01-08)
• SQL Server Integration Services (SSIS) 2022

The version of the SQL Server Database used to read or write data can differ from the SQL Server Integration Services (SSIS) version, e.g., you can use SSIS version 2019 to write data to SQL Server Database version 2022.

Supported SAP Systems and Releases #
The following SAP Systems are supported:

• All SAP ABAP based systems that provide RFC connectivity are supported. All communication with SAP is performed via the RFC protocol.
• SAP ABAP Systems on any database (including HANA) are supported. The database used by the SAP system is irrelevant, because the integration occurs at SAP application server level.
• SAP Systems running on Big Endian and Little Endian hardware are supported.
• SAP industry solutions like IS-U, IS-R, etc. are supported.
• SAP Releases 4.6C and newer are supported.
• All operating systems are supported.

Examples: SAP S/4HANA, mySAP, SAP Application Server ABAP, Message Server, Router, Standalone Gateway, SAP Business Suite 7 (CRM, SRM, SCM etc.), SAP Business All in One, CAR, APO, PI, SAP BW 3.1 and later, SAP BW/BI 7.x, SAP ERP / ECC 5.0 / ECC 6.0 (including all EhPs), SAP R/3 Version 4.6C and later, SAP BW/4HANA and more.

Disclaimer: While SAP versions that are no longer supported by SAP still work with Theobald Software products, they are excluded from the Theobald Software support service.

Not supported SAP Systems #
The following SAP Systems are not supported:

• SAP systems that don’t run on ABAP systems
• SAP systems that don’t provide RFC connectivity.

Examples: SAP S/4HANA Cloud Public Edition, Business By Design, Business One, Business Objects, Sybase, Ariba, Success Factors, Concur

HANA Database #
You can use Operational Data Provisioning (ODP) to connect the SAP HANA database of an SAP ABAP source system. Communication is done via RFC. With the ODP context for SAP HANA (HANA) the following HANA View types are available for extracting:

• Analysis Views
• Calculation Views
• Associated Attribute Views

Direct access to a HANA database without an SAP ABAP source system running on the corresponding HANA database is not supported.

Operating Systems #

• Windows 11
• Windows Server 2022
• Windows 10
• Windows Server 2019
• Windows 8.1 (until 10.01.2023)
• Windows Server 2016 (until 12.01.2027)
• Windows Server 2012 R2 (until 10.10.2023)
• Windows Server 2012 (until 10.10.2023)

Other applications and frameworks #
.NET Framework 4.7.2 or higher. Download .NET Framework from the Microsoft website.

Hardware #

Memory

Minimum 4 GB.
Depending on data volume, more memory may be required.

Disk space
50 MB total for installation

32/64-Bit Environment
32-Bit and 64-Bit operating systems

Xtract Universal 

Supported SAP Systems and Releases 
The following SAP Systems are supported:

• All SAP ABAP based systems that provide RFC connectivity are supported. All communication with SAP is performed via the RFC protocol.
• SAP ABAP Systems on any database (including HANA) are supported. The database used by the SAP system is irrelevant, because the integration occurs at SAP application server level.
• SAP Systems running on Big Endian and Little Endian hardware are supported.
• SAP industry solutions like IS-U, IS-R, etc. are supported.
• SAP Releases 4.6C and newer are supported.
• All operating systems are supported.

Examples: SAP S/4HANA, mySAP, SAP Application Server ABAP, Message Server, Router, Standalone Gateway, SAP Business Suite 7 (CRM, SRM, SCM etc.), SAP Business All in One, CAR, APO, PI, SAP BW 3.1 and later, SAP BW/BI 7.x, SAP ERP / ECC 5.0 / ECC 6.0 (including all EhPs), SAP R/3 Version 4.6C and later, SAP BW/4HANA and more.

Disclaimer: While SAP versions that are no longer supported by SAP still work with Theobald Software products, they are excluded from the Theobald Software support service.

Not supported SAP Systems 
The following SAP Systems are not supported:

• SAP systems that don’t run on ABAP systems
• SAP systems that don’t provide RFC connectivity.

Examples: SAP S/4HANA Cloud Essentials Edition (ES), Business By Design, Business One, Business Objects, Sybase, Ariba, Success Factors, Concur

HANA Database 
You can use Operational Data Provisioning (ODP) to connect the SAP HANA database of an SAP ABAP source system. Communication is done via RFC. With the ODP context for SAP HANA (HANA) the following HANA View types are available for extracting:

• Analysis Views
• Calculation Views
• Associated Attribute Views

Direct access to a HANA database without an SAP ABAP source system running on the corresponding HANA database is not supported.

SAP Authentication 

• SAP user authentication (user name and password)
• SAP authentication with Single Sign On (SSO) and kerberos
• SAP Logon Ticket (via SAP Ticket Issuer) is also in some products available.
• SAP system or dialog user with appropriate authority objects.

Ports 
Following ports have to be opened depending on the SAP system, where nn is the instance number of the SAP system (e.g. 00 or 99).

• SAP Application Server: Port 33nn
• SAP Message Server (Load Balancing): Port 36nn
• Secure Network Communications (SNC): Port 48nn
• SAP Router: Port 3399

SAP Licenses 
Additional SAP licenses might be required for extracting data from SAP. Contact SAP to verify these requirements.

Operating Systems 

• Windows 11
• Windows Server 2022
• Windows 10
• Windows Server 2019
• Windows 8.1 (until 10.01.2023)
• Windows Server 2016 (until 12.01.2027)
• Windows Server 2012 R2 (until 10.10.2023)
• Windows Server 2012 (until 10.10.2023)

Other Applications and Frameworks 
.NET Framework 4.7.2.
To use TLS encryption via HTTPS .NET Framework 4.8 or higher is required.

Hardware Requirements 

Processor Cores
Minimum: 2 Cores. 1 additional core is required for each additional parallel extraction.
Processor Speed
Minimum: processor: 1.4 GHz, recommended: 2.0 GHz or faster.
Main Memory
Minimum: 8 GB, recommended: 12 GB for up to two parallel extractions.
4 GB dedicated memory in average for each additional parallel extraction. Check the exact storage requirements of an extraction in your scenario.
Disk space
For the installation 150 MB disk space is required. When using specific destinations additional disc space may be required.

64-Bit Environment
The product can be installed on 64-Bit operating systems only.

Display Resolution
The product supports a display resolution of min. 1920x1080x1.25 with 1.25 representing the display scaling.

Note: For more information on the processing of parallel extractions, see Run parallel Extractions.

  數據抽取   

BOARD Connector 
BOARD Connector 可以由專業用戶通過圖形編輯器輕鬆操作——訪問SAP數據並將其集成至BOARD應用。

為實現SAP數據對象的全覆蓋，我們提供各種SAP數據源的連接組件——例如，從SAP表中提取海量數據，以及從SAP BW InfoCubes、BEx Query、現有的ABAP報告又或是SAP原生態的DataSources(BW extractors)中提取數據。
 

  數據抽取   報表及數據分析

Xtract for Alteryx 
Xtract for Alteryx 嵌入在Alteryx Designer中。因而SAP 系統中的數據能直接在Alteryx Designer 內輕鬆地集成到您Alteryx解決方案的數據流中。

接口中集成的多種連接器組件可實現對不同的數據流和數據提取的高性能設計建模。其中包括直接從一個或多個SAP 表中抽出海量數據或是從SAP BW InfoCubes 和Bex Query 中提取數據。此外，所有SAP DataSources (BW extractors)、CDS Views、BW/4HANA 對象、Hierarchy類型和其他數據源均可輕鬆完成提取。
 

  數據抽取   數據倉儲

Xtract IS for Azure 
Xtract IS for Azure 確保了SAP 系統和Microsoft Azure-SSIS Integration Runtime 之間的無縫集成。

原理很簡單：SSIS包本地開發，雲端運行。經過時間檢驗的本地版Xtract IS 確保SAP 的連接。在Azure雲，SSIS包的部署、調度和實施中使用這一巧妙的接口非常簡單且高度自動化。最讓人拍手稱讚的一點是：借助Xtract IS for Azure，您既可以一步步從頭開發SSIS包，也可以使用由Xtract IS開發完成的SSIS包。

  流程整合  

yunIO
yunIO是一個用於SAP 流程自動化的無代碼應用程序，為在雲中設計、自動化和集成SAP流程而生。yunIO是最為精簡的SAP和Web或云應用程序的連接方式。不受系統束縛，即使是複雜的流程序列也可以輕鬆完成，也無需擔憂SAP是在本地運行還是在雲中運行。通過直觀的用戶界面整個業務流程都可以輕鬆靈活地完成設計。無論流程簡單還是複雜，是否發送通知信息——只需輕點鼠標，所有這些都可以完全根據您的需求進行設置。  用戶能夠從更好更快的流程中受益。他們可以單獨設計符合自身需求的流程並隨時隨地使用任意設備通過中央平台訪問數據。簡而言之，yunIO 讓SAP 流程變得輕而易舉。這款解決方案名稱中的“yun”源自於中文的“雲”一詞，而IO 則表示輸入和輸出——即我們的專長： SAP數據的寫入和提取——完全在您熟悉的雲環境之中！