Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

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
0
razza_b
Asked:
razza_b
  • 2
  • 2
1 Solution
 
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
 
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
 
razza_bAuthor Commented:
Ah yes i know what you mean, thanks.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now