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
JDBC Adapter – Deploy SQLite JDBC Drivers in PI 7.31 using JSPM
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