更新时间:2023-02-04 15:54:47
在搜索了该主题之后,我发现了许多解决此问题的链接,在此答案中,我将尝试总结所有这些链接并提供所有可帮助您实现目标的链接。 em>
After searching on this topic, i found many link addressing this issue, in this answer i will try to summarize them all and to provide all links that can help you achieving your goal.
有很多方法可以将数据从SQL Server导入到SAP BW:
There are many way to import data from SQL Server into SAP BW:
使用DB Connect,您可以通过以下方式从SAP支持的数据库系统中加载数据:
With DB Connect, you can load data from a database system that is supported by SAP, by
Microsoft为SAP BW创建了一个SSIS连接器,该连接器允许您创建与SAP BW的连接,您可以参考以下链接和官方文档:
Microsoft has created a SSIS connector for SAP BW, which allows you to create connection To SAP BW, you can refer to the following links and official documentations:
SQL Server 2016
SAP BW的Microsoft连接器由一组三个组件组成,可让您从SAP Netweaver BW 7版中提取数据或将数据加载到其中系统。
用于SQL Server 2016的SAP BW的Microsoft连接器是SQL Server 2016 Feature Pack的组件。
The Microsoft Connector for SAP BW consists of a set of three components that let you extract data from, or load data into, an SAP Netweaver BW version 7 system. The Microsoft Connector for SAP BW for SQL Server 2016 is a component of the SQL Server 2016 Feature Pack.
SQL Server 2014
用于SAP BW的Microsoft Connector 1.1包括可以让您从SAP Netweaver BW 7版系统中提取数据或将数据加载到其中的三个组件。
The Microsoft Connector 1.1 for SAP BW consists of a set of three components that let you extract data from, or load data into, an SAP Netweaver BW version 7 system.
SQL Server 2008
如果您决定使用SSIS,我从SAP那里找到了这份白皮书,其中包含详细的教程:
If you decide to go with SSIS, I found this white paper from SAP that contains a detailed tutorials:
如果本文没有没有帮助,您可以参考有关如何在Internet上创建SSIS包的数十个教程:
If this article didn't help, you can refer to tens of tutorials on how to create SSIS packages on the internet:
这是一个允许SSIS创建的第三方工具连接
This is a third-party tool created to allow SSIS to connect with SAP BW.
Xtract IS组件套件提供了九个组件来提供各种SAP接口技术。使用图形编辑器以安全且类型安全的方式实现数据流。
The Xtract IS Component Suite offers nine components to provide all kinds of SAP interface technologies. Implement your data flows in a secure and type-safe way with a graphical editor.
在搜索此问题时,建议不要使用SSIS来实现此目标,因为它可能会遇到一些不兼容的问题,因此建议使用 SAP BW标准anyDB源系统或 SAP BO Data服务。
While searching for this issue, using SSIS to achieve that is not recommended because it may encounter some incompatibility issue, they recommended to use SAP BW standard anyDB source system or SAP BO Data services.
问题示例:
另一方面,SSIS保证了易用性,并且该技术有成千上万的主题和参考资料,可帮助您比其他技术更快地实现目标。
On the other hand, SSIS guarantee the ease of use and there is thousands of topics and references for this technologies which will help you to achieve your goal faster than other technologies.