IDoc to JDBC and JDBC to IDoc Scenario

[Former Member]

Dear All,

I am working on IDoc to JDBC and JDBC to IDoc Scenario.

I have to send Idoc from SAP to Non SAP system(.NET application) i almost configured in XI but still i don't know when my INTEGRATION will INVOKE how my data will proceed from IDOC to Oracle database(Through JDBC) and in case of revese how and when Data flow will start.

Does anyone have completed STEP by STEP scenario document for this?

How my Idoc will sent to XI?

How XI will pick up data from IDoc?

How XI will Convert data to JDBC and UPDATE in Oracle Database?

And i reverse case(JDBC to IDoc) when my INTEGRATION will INVOKE?

Where and When i can watch my process and data?

How can i test the whole integration?

I AM GETTING ERROR WHILE TESTING CONFIGURATION IN Integration Directory "Error while refreshing the XI runtime cache" and when i check this in SXI_CACHE it gives me error

"Unable to refresh cache "NO_BUSINESS_SYSTEM"

"Error during last refresh to cache"LCR_GET_OWN_BUSINESS_SYSTEM - NO_BUSINESS_SYSTEM"

Please solve all the above problems i will reward u points

thanks,

RP

[Former Member]

Hi,

How my Idoc will sent to XI?

For sending IDoc to XI we need to write one ABAP program to trigger the IDoc.

How XI will pick up data from IDoc?

We will create the Port and partner profiles based on that the XI takes the IDoc.

How XI will Convert data to JDBC and UPDATE in Oracle Database?

We will write the update SQL statement in the Receiver Communication channel

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

And i reverse case(JDBC to IDoc) when my INTEGRATION will INVOKE?

When will the new data get to the Database at that time it invoke.

Where and When i can watch my process and data?

After process the data you can watch in the Database table or in RWB also we can watch.

How can i test the whole integration?

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e573e690-0201-0010-e098-f90e8dad...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d0111fef-d311-2a10-c0b9-f33a49c1...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3a67c790-0201-0010-89aa-d27d97dd...

http://help.sap.com/bp_bpmv130/Documentation/Operation/TuningGuide.pdf

[Former Member]

Dear RP,

IDOC to JDBC scenario:

Hope u have made the following configurations at R/3 side to send IDOC:

1. Create an RFC destination pointing to XI system

2. Create a port using the above RFC destination

3. Partner profile should have above created Port --This helps in sending the Idoc to XI

4. In XI system, create a Port and RFC destination pointing to the R/3 sytem - this helps in loading the metadata.

At receiver side: the target structure in XI should be declared as explained in the below attachment:

[http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm]

The above document gives a good insight towards the understanding of the JDBC adapter.

regards

Kiran

[former_member556603]

Hi,

While we working on IDOC to JDBC interface..

We have to deploy JDBC Drivers?

Go through this links,

/people/varadharajan.krishnasamy/blog/2007/02/27/configuring-jdbc-connector-service-to-perform-database-lookups

http://searchsap.techtarget.com/tip/0,289483,sid21_gci1246926,00.html

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password.

If the connection is not working find the correct port number.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d...

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

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

Please check the driver path as mentioned below.

JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

Connection:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//location of DB table.mdb;

No JDBC driver required.

Receiver JDBC scenario MS access - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

follow this thread

SAP Note 850116 has details

/people/michal.krawczyk2/blog/2005/12/04/xi-idoc-bundling--the-trick-with-the-occurance-change

Configuring the Sender JDBC Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/content.htm

Configuring the Receiver JDBC Adapter

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

Idoc Reveiver adapter..

http://help.sap.com/saphelp_erp2004/helpdata/en/b9/c5b13bbeb0cb37e10000000a11402f/content.htm

Thanks,

Satya Kumar

/people/michal.krawczyk2/blog/2005/12/04/xi-idoc-bundling--the-trick-with-the-occurance-change

Edited by: SATYA KUMAR AKKARABOYANA on May 8, 2008 5:51 PM

[former_member633453]

hi!!!

the idoc is not synchnous...could be by BPM

receiber idoc 1 asyn -> receiber jdbc sync -> sender idoc 2 asyn

idoc 1 send info

idoc 2 receibe info

jdbc MT select and MT rs

good luck