| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Query SAP Tables |
« View previous topic :: View next topic » |
| Author |
Message
|
| kirankinnu |
 Posted: Tue Jun 17, 2008 10:47 am Post subject: Query SAP Tables |
 |
|
Centurion
Joined: 12 Jun 2004
Posts: 128
Location: Chicago, IL
|
We are using WMB6.1. Is there a way we could query SAP tables from the WMB apart from using IDOC's or BAPI calls. We have a requirement to read a SAP table and get a single field from it.
Thank You,
Kiran |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Tue Jun 17, 2008 9:03 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi kirankinnu,
What do you mean by SAP table, the SAP database that you are using ? If yes, then ofcourse you should be able to access the Db from MB...
Regards. |
|
| Back to top |
|
|
| kirankinnu |
| Posted: Wed Jun 18, 2008 5:11 am Post subject: |
|
|
Centurion
Joined: 12 Jun 2004
Posts: 128
Location: Chicago, IL
|
What I mean was SAP tables within SAP client using SAPRequest node.
Regards,
Kiran |
|
| Back to top |
|
|
| kirankinnu |
| Posted: Wed Jun 18, 2008 8:02 am Post subject: |
|
|
Centurion
Joined: 12 Jun 2004
Posts: 128
Location: Chicago, IL
|
This problem is solved.
Using the adapter connection Wizard we could configure to query the SAP tables. You have to select 'Query Interface for SAP software' under the Configuration settings for Discovery Agent panel while creating the new Adapter Connection. From there you have to select the desired table and fileds...
Regards,
Kiran |
|
| Back to top |
|
|
| TJParsons |
| Posted: Wed Jun 18, 2008 8:08 am Post subject: |
|
|
Newbie
Joined: 19 Jun 2007
Posts: 3
Location: Winchester, UK
|
Use the "Start from adapter connection" option in the top left,
Choose the adapter for SAP software (6.1),
Select Outbound (although it feels like an inbound),
Enter your longon details an select a "SAP interface name" of "Query interface for SAP software (QISS)",
Click on QISS on the next screen and press the filter button above it,
In the popup box, enter the name of the table (or part of the name surrounded with *),
You table should now be shown - double click on it,
Select the fields you want and the where clause if wanted. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
