Scenario: SAP Tables Data to XML File

[Former Member]

Hi ,

I need to create a Xml file at inbound by taking input as SAP Tables Data at outbound. What are adapters to be used at outbound and inbound interfaces. Please correct me if iam wrong. At outbound side iam taking jdbc adapter and at inbound side iam taking file adapter. Can anybody guide me how to do this scenario with screen shots. Is it possible to use proxies for this scenario.

Thanks in advance.

Regards,

Prem.S

[prateek]

<i>What are adapters to be used at outbound and inbound interfaces.</i>

JDBC and File

<i>At outbound side iam taking jdbc adapter and at inbound side iam taking file adapter. </i>

Will do

<i>Can anybody guide me how to do this scenario with screen shots</i>

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

<i>Is it possible to use proxies for this scenario.</i>

Yes, but it would be easier to use JDBC

Regards,

Prateek

[Former Member]

Prateek,

My scenario is not file to Jdbc, it is Sap Data Base Tables data to File.

Regards,

Prem.S

[prateek]

That was just an additional help

But all other questions were answered i think

This could also be helpful

/people/ravikumar.allampallam/blog/2005/03/14/abap-proxies-in-xiclient-proxy

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

[Mark helpful answers]

Regards,

Prateek

[Former Member]

Prateek,

Thanks a lot , the info which u have provided is very useful.

Regards,

Prem.S

[prateek]

u may also reward points for the helpful answers

Regards,

Prateek

[Former Member]

>>At outbound side iam taking jdbc adapter

No. Do not do this. You are not allowed to access a R/3 database table directly.

You have 3 options

1. ABAP Proxy

2. IDOC adapter

3. RFC adapter.

Choose one among the above.

The selection among these can be made with ref to this blog

/people/ravikumar.allampallam/blog/2005/08/14/choose-the-right-adapter-to-integrate-with-sap-systems

Regards,

Jai Shankar

[Former Member]

Jai,

Thanks a lot, i think the suggestion which u have given is correct. Can u guide me how to do this scenario using ABAP proxies, do u have any documentation on proxies.

Regards,

Prem.S

[Former Member]

Prem,

For steps in Proxy to File, follow the blog given by Prateek.

For using ABAP proxies, you need to activate them first.

For activating ABAP proxies

/people/vijaya.kumari2/blog/2006/01/26/how-do-you-activate-abap-proxies

This is mostly a BASIS activity.

Regards,

Jai Shakr