SAP R3 or File to JDBC

[Former Member]

Hi All,

I want to transfer something from SAP R3 or file to my Database.How can i achieve it? Can you also tell me the syntax that i should use while defining the data types and the message types as i think it is a bit different in this case.

Thanks and Regards,

Satpreet Singh

[Former Member]

use RFC to JDBC Scenerio...

Design RFC in R/3 System...

Creat RFC (TCP/IP)Destination in R/3 system points to R/3 itself.. Give unique Program id there...

Import RFC in SAP XI...

use it in message mapping, interface mapping....

Create XML SQL Format for Receiver JDBC MT..

in Design , create Business system,

in sender RFC , give ur login details and program id u gave in RFC destination....

run ur scenario

[Former Member]

FILE to JDBC Adapter using SAP XI 3.0

Configuring the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

JDBC Driver Deployment Guide...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

Regards

Monika

[Former Member]

hi

Refer these blogs

-

(part-1)

(part2)

- jdbc reciver adapter

Refer this link

http://help.sap.com/saphelp_nw70/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a04cd6f9-9eb0-2a10-07b8-a0fc6e88...

Refer this wiki

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/file%2bto%2bjdbc

Regards,

Suryanarayana

[Former Member]

HI,

While Defining the JDBC side structure you need to follow the pre-defined format of Data type.

Please refer

http://help.sap.com/saphelp_nw04s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

See at bottom of this page

http://help.sap.com/saphelp_nw04s/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

Thanks

Swarup

Edited by: Swarup Sawant on Jul 22, 2008 8:36 AM

[Former Member]

Not sure how different is yours, but there is a blog on File to JDBC did you chekc that

[Former Member]

hi satpreet,

yours is of FILE TO JDBC scenario pls go thru the below blogs for complete understanding:

JDBC receiver

SAP Network Blog: JDBC Stored Procedures

and also

performing sql joins in xi

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1725 [original link is broken] [original link is broken] [original link is broken]

how to install and configure external drivers for JDBC and JMS adapters

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

Connecting to MS Access using receiver JDBC Adapter (Without DSN)

JDBC Receiver Adapter -- Synchronous Select u2013 Step by Step

JDBC Stored Procedures

XI : Recent Enhancements to JDBC Adapter

JDBC Adapter execution mode Chained or Unchained ??

Using JDBC Connection Pool in XI Message Mapping

XI JDBC Adapter managing XML fields

RDBMS system integration using XI 3.0 JDBC Sender/Receiver adapter

XI: How-to on JDBC receiver response

calling stored proc s in MAXDB

inegrating with DATABASES made easy part1

Tips and Tutorial for Sender JDBC Adapter

Save time with generalized JDBC datatypes

Configuring JDBC Connector Service To Perform Database Lookups

<removed by moderator>

regards

kummari

Edited by: kummari on Jul 22, 2008 8:36 AM

Edited by: Mike Pokraka on Jul 24, 2008 12:40 PM