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
Steps I went through, the PI server is dual-stack PI 7.31: 1) Check what JDBC drivers installed. 1a) Check path “\usr\sap\<SID>\DVEBMGS00\j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib”, found default “com.sap.aii.adapter.lib_api.jar” only. 2) Download JDBC drivers. I’m using sqlite JDBC driver, from https://bitbucket.org/xerial/sqlite-jdbc/downloads. The latest available driver
This example convert 2 different recordsets inside single file to xml. First recordset is “SINGER”, second recordset is “SONG”. First column is 1 character length. It is a key column to identify different recordset. “A” from first half mean SINGER,
Previous example tested the CSV file with delimiter, now look at fixed-length file. The objective is to convert fixed-length file to xml representation. ABB, FULLNAME, GENDER and COUNTRY, each is with length 5,20,7,10 respectively. Example: The target message type
The objective is to convert csv file to xml representation. Example: The target message type is 2 columns that repeatable at node row. Document Name is the target message type. Document Namespace should be the namespace of the message type.
The simplest integration scenario I can think of is just simple data files copy, from one location to another. This can be easily done using any scripting language. Using SAP PI to do file copy only, is too over-kill. However,