将SQL Server数据库数据移动到SAP BW [英] Move SQL Server Database data to SAP BW
问题描述
我已经阅读了几篇有关将数据移出SAP BW并移入SQL Server的文章。我找不到任何有关将数据从SQL Server移至SAP BW的文章，甚至有可能，如果可以的话，处理此问题的最佳方法是什么？
I have read a few articles about moving data out of SAP BW and into SQL Server. I cant find any articles on moving the data from SQL Server to SAP BW, is it even possible and if so what would be the best way to handle this?
推荐答案
在搜索了该主题之后，我发现了许多解决此问题的链接，在此答案中，我将尝试总结所有这些链接并提供所有可帮助您实现目标的链接。 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
- 将数据库作为源系统链接到BW，从而创建对外部关系数据库管理系统（RDBMS）的直接访问点。
- 通过生成数据源使BW知道元数据。
- 使用DB Connect传输数据
- 一步一步为DB Connect创建数据源
- SAP BW 7.3：如何使用DB Connect从SQL Server提取数据
- 注释512739-MS SQLServer的BW外部DB Connect
- Transferring Data Using DB Connect
- Create DataSource for DB Connect step by step
- SAP BW 7.3: How to extract data from SQL Server using DB Connect
- Note 512739 - BW external DB Connect for MS SQLServer
- Creating a Data Store by using SQL Server Database
- How to load data into SAP BW 7.3 from SQL Server using SSIS
- 用于SAP BW的Microsoft连接器
- 用于SAP BW组件的Microsoft连接器
- Microsoft Connector for SAP BW
- Microsoft Connector for SAP BW Components
- 用于SAP BW的Microsoft连接器1.1
- Microsoft Connector 1.1 for SAP BW
- Using SQL Server 2008 Integration Services with SAP BI 7.0
- Steps to Create your First SSIS Package
- SSIS Basics: Setting Up Your Initial Package
- Create a new SSIS package/
- Official integration services tutorials
- Xtract IS – SAP和SQL Server集成服务的即插即用
- Xtract IS – Plug’n’Play for SAP and SQL Server Integration Services
- Loading Data from SSIS to SAP BW
- Using SSIS to load data from SQL Server to SAP BW
- SAP BW to SQl Server import and export wizard
- How to load data from SQL Server to SAP BW using SSIS
- Quick Tip: SSIS and SAP BW -Setting up connection between SAP BW and SSIS
- White paper - SAP BW transferring data with DB Connect
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.
这篇关于将SQL Server数据库数据移动到SAP BW的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
