Linking Access to SAP's Business Warehouse

[vbjenny]

I've been told I can link MS Access to SAP's Business
Warehouse. I have linked Access to SQL Server using an
ODBC connection. Is that the same process I would use
for SAP's Business Warehouse?

thanks, vbjenny

 

[Nikos Yannacopoulos]

Jenny,

I'm not an expert on the subject, but here's my penny's worth: SAP (like
most ERP's) relies on a separate database product for data storage; this
can be SQL Server or Oracle or... the same holds for BW. In that sense,
what you really need is an ODBC connetion to the tables in the database.
So, you need to know (a) the type of database used, (b) the database
server, (c) database structure details (name, tables etc.), and (d) a
user account and password. This will probably require some help form
your IS Dept, who are typically reluctant to help users gain access to
the databases (and for good reasons, mostly), so good luck!

HTH,
Nikos