Idoc to jdbc

[Former Member]

Hello all plz tell me step by step of idoc to jdbc.

[Former Member · Accepted solution]

Hello Santosh,

you create the

Data Type for as per your JDBC table structure

Assign the Data type to your Message type

Assign The Your JDBC message Type to message interface

In mapping you can take source message as IDOC message type and target message type as your JDBC message type .

than you can map. please go through the blogs

<a href="/people/laxman.molugu/blog/2006/08/13/integration-with-databases-made-easy-150-part-1:///people/laxman.molugu/blog/2006/08/13/integration-with-databases-made-easy-150-part-1

<a href="://

<a href="/people/michal.krawczyk2/blog/2005/09/01/xi-idoc-adapter--edidc40--demystified:///people/michal.krawczyk2/blog/2005/09/01/xi-idoc-adapter--edidc40--demystified

<a href="://

With Regards,

Raju.

Please give points if useful...

[former_member190313]

hi

find the following procedure:

1 . Do the ALE Settings to send the Idoc to XI

2 In XI your Sender Interface will be IDoc

3 For reciever data type :

Record

<TableName> (Field) ( Name of the table in database)

action (attribute of table name) ( will be Insert /Update/delete / Update_insert)

access (field under tablename )

- here you create fields under this for all columns in the oracle tables

Key (field under tablename )

- here you create field under this for all columns in the oracle tables that is primary key

4 . Do the Mappings accordingly and create other interface objects

5 You have to Configure JDBC Reciever In that give the following parameters

JDBC Driver : oracle.jdbc.driver.OracleDriver

Connection : jdbc:oracle:thin: uid/pwd @ip address of ur oracle server:1521:Global database name

do the other id settings

regards

Sheetal

plz reward points for helpful answer

[Former Member]

Refer these for details

File to JDBC

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

IDoc to File

/people/prateek.shah/blog/2005/06/08/introduction-to-idoc-xi-file-scenario-and-complete-walk-through-for-starters

Mudit