This is a bit confusing but here goes: I need to access data in SAP via OLE DB. I can't go direct to the back end database (Oracle), we have to use RFC or BAPI calls to access the SAP data. That's part works, we have a DLL that accesses the SAP data we need.
Next I would like to be able to access the data in that DLL with something like:
Select * from view_SAPData.
We messed around with extended stored procedures and it looked good for a bit because we could call the extended proc from a stored proc and we could create a view from a function so I figured we could make it work, but we couldn't.
So now I'm asking you nice folks if there is a way we can provide a dataset to SQL Server from our DLL? I don't know much about DMO, is there anything there?
Hope this makes sense.
TIA,
Blaise
Hi blaise,
You would to use Microsoft .NET Data Provider for mySAP Business Suite:
http://download.microsoft.com/download/f/7/4/f74cbdb1-87e2-4794-9186-e3ad6bd54b41/DataProviderSAP.exe
You could to see more info about it, here:
Feature Pack for Microsoft SQL Server 2005
http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en
Good Coding!
Javier Luna
http://guydotnetxmlwebservices.blogspot.com/
No comments:
Post a Comment