How to connect to SAP BW database for importing data to SQL SERVER and OLAP?

icad01
icad01 used Ask the Experts™
on
Dear experts,
How to connect to SAP BW database for importing data to SQL SERVER and OLAP (via MS Access)?
Is there any OLEDB\ODBC provider to read SAP data?
Thanks in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:

SAP BW provides three ways to extract data at the database or file level: DB Connect, flat file transfer, and XML. SAP BW provides flexible capabilities for extracting data directly from RDBMS tables using DB Connect.

from
http://www.thespot4sap.com/forums/m_30/mpage_1/key_/tm.htm

see this link too
http://www.microsoft.com/sql/solutions/sap/default.mspx


hth

Author

Commented:
Dear capricorn1,
Thanks for your quick answer.
Is DB Connect built in SAP BW or is it an add-on?
Can I use it from outside or did I need the SAP administrator?
Thanks again

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial