The objective is to transfer table SINGER from SOURCE_DB to XML row, XML SQL, then to TARGET_DB, using SAP PI JDBC sender and receiver adapter. The JDBC driver is SQLite that deployed in previous post.
jdbc_test_sourcedb_xmlrow_xmldbstatement_targetdb

STEP 1: From “SOURCE_DB” to “XML ROW”
Reference : Configuring the Sender JDBC Adapter
The SOURCE_DB’s SINGER table have additional SYNCED column, to use as flag to know which record already synced to TARGET_DB’s SINGER table. Configure the Sender Agreement as well.
jdbc_test_sender_jdbc

STEP 2:FROM” XML ROW” to “XML DB STATEMENT”.
Reference: Defining XML Documents for Message Protocol XML SQL Format
action = “UPDATE_INSERT”, mean if found existing record, then do an update, else do an insert.
table = “SINGER”, access = “SINGERID” and “FULLNAME”, key = “SINGERID”
jdbc_test_mm_singer_to_singer_db
STEP 3: FROM “XML DB STATEMENT” to “TARGET_DB”
Reference :  Configuring the Receiver JDBC Adapter
Configure the Receiver JDBC Adapter and Receiver Agreement as well.
jdbc_test_receiver_jdbc

Keep on learning!

 

JDBC Adapter – SourceDB Send Table to XML format and Receive to TargetDB
Tagged on:         

2 thoughts on “JDBC Adapter – SourceDB Send Table to XML format and Receive to TargetDB

  • July 19, 2015 at 7:52 pm
    Permalink

    Nice presentation Yee-Loon 🙂
    Just would like to know, in JDBC sender adapter which SQL language we need to use for “Query SQL Statement” and “Update SQL Statement” fields?
    Does it according to the database we are using or any generic syntax to follow?

    Thanks.

    Reply
  • July 21, 2015 at 5:53 pm
    Permalink

    Hi,
    Thanks! Yes, you are right, the SQL depend on the database we are using, different DB driver. If using standard generic SQL (mean basic CRUD and not DB specific) then should working fine too.

    Reply

Leave a Reply

Your email address will not be published.

Time limit is exhausted. Please reload CAPTCHA.