February 24, 2011 at 11:40 am
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.
February 24, 2011 at 11:43 am
Brandie Tarvin (2/24/2011)
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.
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 24, 2011 at 12:32 pm
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.
February 24, 2011 at 12:37 pm
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.
February 24, 2011 at 1:31 pm
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
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 28, 2012 at 7:31 pm
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
March 28, 2012 at 11:16 pm
Tutorial: Creating a Simple ETL Package
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 29, 2012 at 4:30 am
What Koen said. SSIS is the way to go.
October 2, 2012 at 1:45 am
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply