Solved

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

Posted on 2006-10-21
3
1,584 Views
Last Modified: 2008-02-01
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
Comment
Question by:icad01
  • 2
3 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 17781201

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
 

Author Comment

by:icad01
ID: 17781882
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
 

Author Comment

by:icad01
ID: 17789365
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now