Solved

SP call to SAP

Posted on 2011-03-21
4
329 Views
Last Modified: 2012-08-13
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
Comment
Question by:razza_b
  • 2
  • 2
4 Comments
 
LVL 9

Expert Comment

by:kaminda
ID: 35179299
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
 
LVL 1

Author Comment

by:razza_b
ID: 35179559
Thanks Kaminda

Do you have any SP samples of doing this?
0
 
LVL 9

Accepted Solution

by:
kaminda earned 500 total points
ID: 35179596
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
 
LVL 1

Author Closing Comment

by:razza_b
ID: 35179626
Ah yes i know what you mean, thanks.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Viewers will learn how the fundamental information of how to create a table.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question