on 07-22-2008 7:16 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
Regards
Monika
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
Refer these blogs
Refer this link
http://help.sap.com/saphelp_nw70/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm
Refer this wiki
https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/file%2bto%2bjdbc
Regards,
Suryanarayana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
8 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.