SP call to SAP

Hi Experts

Anyone know how to call SAP from an SP in sql server 2008? And do i need the DB connection details of the SAP DB in order to do this?

Thanks
LVL 1
razza_bAsked:
Who is Participating?
 
kamindaCommented:
After creating the linked server you can access any object in that server by

linkedservername.schemaname.objectname

i.e
SELECT * FROM SQLServer1.dbo.tblCustomer

You can access any functions or SP's in this manner
0
 
kamindaCommented:
Yes you need SAP DB credentials to do any sort of a call to that db. You can create a Link server to SAP DB and call any object in that db from your server.

About Linked Servers
http://msdn.microsoft.com/en-us/library/aa213778(v=sql.80).aspx
0
 
razza_bAuthor Commented:
Thanks Kaminda

Do you have any SP samples of doing this?
0
 
razza_bAuthor Commented:
Ah yes i know what you mean, thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.