Solved

SP call to SAP

Posted on 2011-03-21
4
341 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

737 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