BI Connectors by Matt Masson

Question

I read an article by Matt about SAP connectors, but still need to connect a few dots, especially since it was an older article.

I have SAP ERP ECC6, the article mentioned connectors for SAP BI also BIZTALK.  So what I want to do is use SSIS 2008 on SQL Server 2008 r2 on Windows 2008 Server to create some basic data pulls from the SAP ERP 6 system.  I guess one of my questions is, are the SAP connectors ONLY for SAP BI/DW, are there any for just the ERP system?

I have searched for ODBC drivers, OLEDB drivers or anything else that can connect to SAP 6.  But have not yet been able to find a complete solution.  It seems that BIZTALK might be the best route, but I have also encountered BAPI'S and SAP extractors.

So what is the best most complete solution to make the connection and pull the data using SSIS?

Note: I don't know much about BIZTALK or what it is.  So details on that would help, as opposed to saying, Oh, just use BIZTALK.

Thanks!

Answer 1

This is the wrong forum (this is for forum profile issues). Try...

http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver/

http://social.technet.microsoft.com/Forums/en/category/windowsserver/

http://www.microsoft.com/biztalk/en/us/forums.aspx

http://social.msdn.microsoft.com/Forums/en-US/category/biztalkserver

Thanks!

---

Ed Price (a.k.a User Ed), SQL Server Experience Program Manager (Blog, Twitter, Wiki)