如何配置Microsoft Access数据库以直接从SAP BW中提取源数据? [英] How do I configure my Microsoft Access database to pull source data directly from SAP BW?

问题描述

我定期使用几个Microsoft Access数据库来创建报告.要获取源数据，我目前必须登录到SAP BW(通过SAP NetWeaver)，运行源数据报告，将结果导出为.csv文件(但实际上将其保存为.txt文件)，然后导入将该文件导入Microsoft Access.我可以通过Access直接从SAP BW中提取数据吗?

I use several Microsoft Access databases on a regular basis to create reports. To get the source data, I currently have to log in to SAP BW (via SAP NetWeaver), run the source data report, export the results as a .csv file (but actually saving it as a .txt file), and then import that file into Microsoft Access. Is there a way that I can have Access pull the data from SAP BW directly?

感谢您的帮助！

推荐答案

SAP使用的所有数据库都是行业标准数据库，因此数据将存储在支持ODBC的系统中.

All of the databases used by SAP are industry standard databases and the data is thus going to be stored in a system that supports ODBC.

据我所知，SAP通常使用Sybase，这也是SQL Server最初的基础.

As far as I know, SAP in general uses Sybase which is also what SQL server was originally based on.

因此，SAP在行业标准的SQL服务器(Sybase或SQL服务器)上运行.如果在IBM上运行，则数据位于DB2(通常为as400系统)中.

So SAP is running on an industry standard SQL server (Sybase or SQL server). If running on IBM, then the data is in DB2 (often the as400 system).

因此，您只需联系您的IT部门，并获取到数据库的所需ODBC连接字符串.如果您没有在SQL Server上运行SAP，则可能"还需要安装最新的Sybase驱动程序，但是同样，此类信息也可以从SAP支持人员那里获得.

You thus simply need to contact your IT department and obtain the required ODBC connection strings to the database. You "might" also need to install the latest Sybase drivers if you not running SAP on SQL server but again such information would be available from your SAP support folks.

因此，您只需设置链接表即可访问SAP数据库，因此不需要导出或下载或导入数据–您始终可以报告实时数据.因此，挑战"当然是要掌握SAP中的表结构-这是一个巨大的挑战，因为在大多数情况下，您一直用于导出的报告是许多相关表合并为易于"导出视图的结果.因此，请为一些复杂的需求做好准备，以所需的方式获取数据.

So you simply setup linked tables in access to the SAP database, and thus no export or download or importing of data is required – you be reporting on live data at all times. The "challenge" is thus of course to grasp the table structures in SAP - a LARGE challenge since in most cases a report you been using for exports is the result of MANY related tables joined together into a "easy" view for exporting. So be prepared for some complex quires to get the data the way you want.

这篇关于如何配置Microsoft Access数据库以直接从SAP BW中提取源数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！