how do i import data from sap bw

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » how do i import data from sap bw

how do i import data from sap bw

Rate Topic

Display Mode

Topic Options

Author

Message

speedy525e

Posted Thursday, February 24, 2011 6:29 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 24, 2011 6:24 AM
Points: 1, Visits: 0

Hi

How do i import data from SAP BW into SQL

I need this for a anytical tool tableau

Regards

Post #1068886

Brandie Tarvin

Posted Thursday, February 24, 2011 11:40 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 6,668, Visits: 5,695

The two methods I know of are to either use a webservice to get into SAP's database and call the data that way, or get SAP to provide a csv / flat file for you to import.

Either way, you need to discuss this with your SAP dev team so they can provide you with the information you need, especially the data types / layout.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #1069161

Koen Verbeeck

Posted Thursday, February 24, 2011 11:43 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473

Brandie Tarvin (2/24/2011)

I think the second alternative from Brandie, letting the SAP team produce a flat file dump of the data you need, is the "easiest" option.
I wouldn't want to go into "SAP black box" to fetch the data myself.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1069168

stevefromOZ

Posted Thursday, February 24, 2011 12:32 PM

SSCommitted

Group: Moderators
Last Login: Yesterday @ 12:03 PM
Points: 1,763, Visits: 3,189

Use the SSIS SAP adapter? http://msdn.microsoft.com/en-us/library/dd299430.aspx

Absolutely agree, don't go trying to hit the tables directly, it gets ugly very (very!) quickly. You can also expose different BAPI's as web services and could theretically extract using these, but this would be my 3rd option behind the SSIS adapter and almost any other 3rd party component (eg http://www.theobald-software.com/en/products.htm ).

Oh, also forgot, there's the Business Data Catalog (i think this got a new name in Sharepoint 2010) that can also be used for this purpose.

Steve.

Post #1069224

Brandie Tarvin

Posted Thursday, February 24, 2011 12:37 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 6,668, Visits: 5,695

I think BAPIs is the way the webservices I know of do it. There's no direct table involvement.

I don't think I've tried the SSIS adapter, though.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #1069231

ALZDBA

Posted Thursday, February 24, 2011 1:31 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 2:17 AM
Points: 6,862, Visits: 8,049

If I'm correct you need middleware for SQL2005.

With SQL2008 MS did aquire that middleware.

Now, if only I could recall the exact name.

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?

"press F1 for solution", "press shift+F1 for urgent solution" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #1069276

Rajan5436

Posted Wednesday, March 28, 2012 7:31 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 29, 2012 12:53 AM
Points: 1, Visits: 8

Hi,

Can any one help me about fetching the data from SAP flat file that is generated by our SAP Team?

Actually I want this to be done by scheduling SQL Server Jobs. I am using SQL Server 2005 and SSMS of the same.

Regards
Rajan

Post #1274805

Koen Verbeeck

Posted Wednesday, March 28, 2012 11:16 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473

Tutorial: Creating a Simple ETL Package

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1274852

Brandie Tarvin

Posted Thursday, March 29, 2012 4:30 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 6,668, Visits: 5,695

What Koen said. SSIS is the way to go.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #1274976

sagar0838

Posted Tuesday, October 02, 2012 1:45 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 12:53 AM
Points: 18, Visits: 93

hi ,
Yes you can direclty connect to SAP BW using Tableau's builtin adapter
Hope below link will help u

[url=http://kb.tableausoftware.com/articles/knowledgebase/sapbw-connection][/url]

Post #1366884

« Prev Topic | Next Topic »

Permissions