如何使用SSIS将数据从SQL Server加载到SAP BW [英] How to load data from SQL Server to SAP BW using SSIS

问题描述

我想使用SSIS将数据从SQL Server加载到SAP BW.有人可以帮我吗，我该怎么做.当前，我正在使用sql server2005.

I would like to load data from SQL server to SAP BW using SSIS. Could some one help me on it how can i do it. Currently i am using sql server 2005.

推荐答案

为什么要为此使用SSIS? 我建议使用SAP BW标准anyDB源系统或使用BO Data Services进行加载. 两者都本机地做得很好. 如果您坚持，请查看: https://theobald-software.com/en/xtract-is-productinfo. html 它们具有以下功能:

Why would you use SSIS for that? I would recommend either load using SAP BW standard anyDB source system or using BO Data Services. Both do it natively and well. If you insist, look at: https://theobald-software.com/en/xtract-is-productinfo.html They have the following feature:

使用Xtract IS BW Loader数据目标，您可以在SAP BW系统中直接在SSIS数据流内重新路由数据流.

With the Xtract IS BW Loader data target, you can reroute data streams within your SSIS data flow directly in your SAP BW system.

相应的BW InfoPackage将自动触发并填写. 当然，该组件完全基于所需的SAP标准(第三方供应商的暂存BAPI). 下面的屏幕快照显示了如何在管道中将管道元素与传输结构链接起来.

The corresponding BW InfoPackage is automatically triggered and filled in. Of course, the component is based exclusively on the required SAP standard (staging BAPIs for third-party vendors). The following screenshot shows how the pipeline elements can be linked within the Integration Services with the transfer structure.

这篇关于如何使用SSIS将数据从SQL Server加载到SAP BW的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！