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.
Oracle drivers are installed.
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.
2) 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.
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.
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.
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.
13) Similarly create MI_ia_Target which is a Inbound Asynchronous interface. Select MT_Target message type.
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.
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.
19) Save & Activate all the objects created.
II. ID: Configuration
1) Create a Configuration Scenario CS_GO211G_FXRATES
2) Add Business System/Business Service i.e., Sys_DBZebra to the Configuration Scenario.
3) Now Sender Communication Channel has to be created which would fetch data from Oracle database.
4) Communication Channel : CC_211G_JDBC_Server
5) Following fields have to filled
. Adapter Type: JDBC
. Check Sender option
. Transport Protocol: JDBC 2.0
. Message Protocol: JDBC
. Adapter Engine: Integration Server
Under Connection tab:
. JDBC Driver: (For Oracle) oracle.jdbc.driver.OracleDriver
. Connection: Field parameter is specific to the connecting DB system. SID- Name should be provided.
. User Name: XXXXX
. Password: XXXXX
Under Processing tab:
. Quality of Service: EO/EOIO
. Poll Interval: Requirement Specific
. Query SQL Statement: SELECT
BASE_CURRENCY, RATE, TS_CREATE, TS_MODIFY from
. Document Name: ZEBRA (whichever name fits as per the requirement)
. Update SQL Statement: (as per my requirement I should not update the DB. So this is a Dummy statement.)
Under Advanced tab:
o) Status: Active
6) Assign the Receiver Business System configured in SLD to the corresponding Configuration Scenario.
7) Create a Receiver Communication Channel CC_XI_Client_Proxy. A
8) Fill the following fields in XI Adapter.
. Transport Protocol: HTTP 1.0
. Message Protocol: XI 3.0
. Adapter Engine: Integration Server
. Addressing Type: HTTP Destination
. HTTP Destination: D67CLNT300
9) Sender Agreement is created with Sender Service & Interface details.
10) Select the Sender Communication Channel CC_211G_JDBC_Server.
11) R/3 system is the receiver in the present Scenario. So the corresponding Receiver Determination has to be created.
12) In the Configured Receivers section, select the receiver service "MCLNT103".
13) "MCLNT103" service is visible in Configured Overview for Receiver
14) The Receiver(Partner/Service) & Interface Mapping are created by selecting the "New Specific" option.
15) Select the corresponding Inbound Interface and Interface mapping. Save it.
16) Click on "Refresh" button. The created objects are displayed.
17)Receiver Agreement has to be created.
18) Select the corresponding Receiver Communication Channel.
CC_XI_M57CLNT103. Save it.
19)Click on "Refresh" in Receiver Determination. Now the above created objects are displayed.
20)Activate all the components.
21)Check whether the Cache is updated or not. If not, refresh it.
III. Steps to Schedule a Communication Channel:
1) Go to Communication Channel Monitoring in Runtime Work Bench.
2) Go to the corresponding Communication Channel i.e., CC_211G_JDBC_Server
3) Click on "Availability Time Planning"
4) Create a Daily Schedule for the Communication Channel "CC_211G_JDBC_Server"
5) Schedule at 14:00 CET for a duration of 2 hour.
Click on "Details" tab
Select the "Active" checkbox
In "Time" field , enter "14:00 CET" for 2 hours
6) Click on "Communication Channels" tab
Select "CC_211G_JDBC_Server" channel.
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.
Start & Stop button are both active and Automatic Control button is disabled.
"Availability Times" tab is displayed.
8) "Availability Times" is displayed as seen in the Screenshot.
9) After the Successful trigger at the Scheduled time, the Channel starts.
10) For manually triggering, click on "Start" button.
11) To again activate Scheduling, activate "Automatic Control".