• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1997
  • Last Modified:

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

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.
0
icad01
Asked:
icad01
  • 2
1 Solution
 
Rey Obrero (Capricorn1)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
0
 
icad01Author 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
0
 
icad01Author Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now