Author : Arun Mehta
Configuration steps in Integration Repository
1> Create two data types

And the second datatype as in the fig.

2> Create the 2 message types for the corresponding data types


And similarly the second message type.

3> Now create the 2 message interfaces

Make sure that the category and mode are entered as shown.

4> Now create the Message Mapping , make sure the table is created prior to this and the action field is hard coded with “insert” value under CONSTANT function. Please refer to the figure below.


5> Now create the Interface Mapping. Make sure to select the correct mapping Program.


Configuration steps in Integration Depository
1>As a first step create two Communication channel, as in the figure
Make sure that the Service selected is of 3rd party in system landscape directory.
Set Processing Mode value as delete (this option will delete the file once it is read by SAP XI adapter) and transfer mode as binary.

Similarly configure the Receiver channel. Use the JDBC 2.0 Transport protocol. Make sure that connection parameter has your local machine name.

2> Now create the Sender Agreement connecting to the channel of sender as shown in figure below:

Now create the Receiver Determination as shown in the figure below:

3> Configure the Interface Determination as shown in the figure below:

4> As a last step create the Receiver Agreement as shown in the figure below:


This completes configuration with Integation Repository and Intregation Directory.
Testing:
• Log in to Adapter monitor and check for the File adapter and Jdbc adapter.The status should be green.
• Insert the source xml in the root folder path of the FTP adapter that you used. It will be detected and deleted according to the time set in your polling interval.
• Check message and flag status in SXMB_MONI. A chequered flag should be present.
• Log in to SQL Studio and look for your table under the DBA path (or the path you used to create the table), and right click->show content for the values, you should get the new values as shown in the slide below:

It should reflect the new values in the tuple of the table that we have created .This is shown in the slide below.

Cool !!!View other tutorials!________________________Submit a tutorial