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.
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.
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”
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.
Keep on learning!