Skip to Content
This Scenario explains about the retrieval of records from Oracle DB and transfers them to SAP R/3 via SAP XI. Query has to be triggered daily at a particular time (e.g.: daily at 14.00 hours).So Scheduling is done in JDBC Sender Adapter. XI Receiver Adapter is used to connect SAP R/3.imagePrerequisites: *  SLD should be configured. Topics covered in this Scenario are: 1.  IR development 2.  ID configuration 3.  Scheduling a Channel Following are steps of the Scenario. I. _Integration Repository:_ 1) Import the Software Component Version created in SLD.image2) Specify the Namespace in the Software Component Version imported 3) Not Permitted option is checked for the Interface Import as we are not importing anything from R/3.image  4) Create a Source Data type with the same field structure that is going to be retrieved from DB. 5) Here I have created a Target data type similar to the Source data type.image  6) We create the corresponding Message types for both the Source and Target Structures. 7) Right-Click on Message type in Interface Objects to create a new Message Type MT_Source. 8) Using F4, select DT_Source (Source Data type) in Source Message type MT_Source. 9) Similarly, create Target message type where DT_Target is included in MT_Target.image  10) Now we have to create the Outbound & Inbound interfaces. 11) Right-click on the Message Interfaces to create the corresponding interfaces. 12) MI_oa_Source is a Outbound Asynchronous interface. Select the corresponding Message type MT_Source.image  13) Similarly create MI_ia_Target which is a Inbound Asynchronous interface. Select MT_Target message type.image  14) Create a Message mapping object MM_Source_to_Target. Select source as MT_Source and target as MT_Target. 15) Here for simplicity in mapping, we do a One-to-One mapping.image  16) Interface mapping Object IM_Source_to_Target is created. 17) Select Source interface as MI_oa_Source and Target interface as MI_ia_Target. Save & Click on Read Interfaces. The corresponding Message types are displayed. 18) Select the Message mapping object MM_Source_to_Target created previously.image 19) *Save* & III. *Steps to Schedule a Communication Channel:*    1) Go to Communication Channel Monitoring in Runtime Work Bench.image2)  Go to the corresponding Communication Channel i.e., CC_211G_JDBC_Serverimage3) Click on “Availability Time Planning”image  4) Create a Daily Schedule for the Communication Channel “CC_211G_JDBC_Server”image5) Schedule at 14:00 CET for a duration of 2 hour. 0.1. Click on “Details” tab 0.2. Select the “Active” checkbox 0.3. In “Time” field , enter “14:00 CET” for 2 hoursimage6) Click on “Communication Channels” tab             Select “CC_211G_JDBC_Server” channel.image Then “*SAVE*” the settings done.     7) In Communication Channel monitoring Screen “Automatic Control” should be active for the scheduler to run. Check the following to see whether Scheduler is active. 0.1. Start & Stop button are both active and Automatic Control button is disabled. 0.2. “Availability Times” tab is displayed.image  8) “Availability Times” is displayed as seen in the Screenshot.image9) After the Successful trigger at the Scheduled time, the Channel starts.image
To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

    1. Anonymous
      Hello Ganesh,

      Your blog looks a its been taken from a training manual. There is nothing new that you are presenting in the blog. There are many articles around JDBC scheduling.

      Hope you take the input in a positive way. We want to make sure the quality of XI blogs are not sacrificed.

      Regards,
      Naveen

      (0) 
      1. Ganesh Karicharla Post author
        Hi Naveen,

        Thanks for going through the blog.

        I would also like to mention that this blog is not taken from any training manual. This is the actual implementation done in one of my project.

        Thanks,
        Ganesh Karicharla

        (0) 
  1. Sridy Kasturi
    Hi Ganesh,

    Nice work and good explanation regarding the process flow. Meaningfull screen-shots.

    This blog explains clearly that how the process  takes place from ORACLE DB to SAP R/3 sytem.

    Good work and

    Keep Blogging..

    Regards,
    Sridhar Kasturi

    (0) 
  2. Wagner Biasi
      Hi,
      I realy like it. That´s what i needed for a financial tax interface with oracle legacy system, but didn´t see that option “Availability Times” in my XIP. Had to schedule in oracle side.
    (0) 

Leave a Reply