将数据从SAP传输到SQL Server的最佳方法是什么？ [英] What is the best way to transfer data from SAP to SQL Server?
问题描述
我们希望基于SAP Tables从头开始构建新的数据仓库。对于提取，转换和加载（ETL）程序，我们要使用Microsoft SQL Server Integration Services。市场上有许多供应商，例如Theobald，CData等，它们提供了访问SAP数据的框架。但是，SAP本身也提供了一个SAP .NET Connector 3.0，可以通过RFC访问数据。
您对这些不同的解决方案有任何经验吗？根据DWH的概念，我们只想访问表，并专注于SAP数据的快速传输（良好的传输性能）。
感谢您的帮助。
我宁愿坚持使用本机SAP解决方案。以下是选项：
- SAP SLT
非常简单但有效的解决方案。 功能相当有限（没有联接，没有来自多个来源的合并），但似乎是一次性转换的理想选择。 - SAP数据服务（SAP BODS）
更复杂的工具从任何来源构建ETL的场景到任何目的地，包括复杂的转换，脚本等。 - SAP MDM / MDG
更具概念性的解决方案，其中包括数据质量，数据治理，验证，重复数据删除等。MDM和MDG实际上是两种不同的产品，但在这里我们为了简单起见将它们放置为单个简单。它们大概用于SAP系统之间的即时复制过程，但是MDM功能更强大，可以独立使用，也可以用于任何数据源。 - SAP PI
最复杂，功能丰富且最复杂的解决方案， 1次传输似乎是合理的选择。有关差异的更多信息。 - SAP数据中心
适用于大数据源的SAP解决方案，对于您的情况而言似乎是多余的。
这完全取决于您的任务范围（镜像，复制或转换），数据的复杂性，必要的转换（简单或复杂），周期性（即席或即时），预算等。 / p>
如果只需要将DWH 原样移动到MS SQL中，建议使用SLT作为最有效的方式。如果您需要更复杂的转换，建议您使用SAP BODS。其他要点似乎与您的任务无关。
We want to build up a new Data Warehouse from scratch, based on SAP Tables. For the extract, transform and load (ETL) proedure, we want to use Microsoft SQL Server Integration Services. There are many vendors on the market like Theobald, CData etc, which provide a framework to access SAP data. But there is also a SAP .NET Connector 3.0 provided from SAP itself to access the data via RFC.
Do you have any experiences with these different solutions? According to the DWH concept we just want to access the tables and are focused on fast transfer (good transfer performance) of the SAP data.
Thank you for your help.
I'd prefer stick to the native SAP solutions. Here are the options:
- SAP SLT Very simple but efficient solution. Features are quite limited (no joins, no merging from multiple sources) but seems to be ideal for one-time transformation.
- SAP Data Services (SAP BODS) More sophisticated tool that allows building scenarios of ETL from any sources to any destinations, including complex transformations, scripts, etc.
- SAP MDM/MDG More conceptual solution which includes data quality, data governance, validation, de-duplication, etc. MDM and MDG are actually two different products but here we place them as single for the sake of simplicity. They are used presumably for instant replication process between SAP systems, but MDM is more versatile and can be used standalone, and for any data source.
- SAP PI The most sophisticated, feature-rich and complex solution which doesn't seem reasonable choice for 1-time transfer. More about differences.
- SAP Data Hub SAP solution for Big Data sources which seems redundant for your case.
It's all depends of the scope of your task (mirroring, replication or transformation), complexity of data, necessary transformations (simple or complex), periodicity (ad-hoc or instant), budget and others.
If you just need to move your DWH as is into MS SQL I suggest to use SLT as the most performance-efficient way. If you need more sophisticated transformations I suggest using SAP BODS. Other points seems not relevant for your task.
这篇关于将数据从SAP传输到SQL Server的最佳方法是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
