使用SSIS MS SQL从非SAP系统中提取SAP数据 [英] Extracting data from SAP from non-sap system using SSIS MS SQL

问题描述

如何使用ssis（非SAP系统）从远程计算机上的SAP中提取数据？在某处我读到使用Sap连接器和librfc32.dll。但librf32.dll只能从Sap Market Place下载，这需要客户帐户。还有其他方法吗？请建议!!

How can i use ssis (Non-Sap System) to extract data from SAP on remote machine ? Somewhere i read to use Sap connector along with librfc32.dll. But librf32.dll can only be downloaded from Sap Market Place & this requires Customer account. Any other way ? Please suggest !!

推荐答案

从SAP传输数据时，您可以采用不同的方式。可以使用BAPI将数据从SAP转换为任何csv / xml文件，并将其传输到FTP位置。 SSIS可以下载文件并将数据传输到SQL Server DB。这是间接的做法。



另一种方式是使用SAP连接器。 SAP连接器可以从市场下载，需要您提到的帐户。使用连接器，您可以直接连接到SAP的BAPI并下载数据。



无论哪种方式，我们都需要SAP ABAP程序员编写BAPI来获取数据。第一种方式是最简单的方法。



希望它有所帮助。如果您需要更清晰，请告诉我

When you transfer the data from SAP you can do it in different ways. The data can be converted from SAP to any csv/xml file using a BAPI and transferred to a FTP location. The SSIS can download the file and transfer the data to the SQL Server DB. This is indirect way of doing it.

The other way is use SAP connector. The SAP connector can be downloaded from market place and needs the account as mentioned by you. Using the connector you can directly connect to the SAP's BAPI and download the data.

Either way we need a SAP ABAP programmer to write a BAPI to get the data. The first way is the easiest way of doing it.

Hope it helps. Please let me know if you need more clarity

这篇关于使用SSIS MS SQL从非SAP系统中提取SAP数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！