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
File Adapter – Sender – Convert Multiple Fixed Length Structure to XML Using Key Field Name
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,
File Adapter – Sender – Convert Single Fixed Length Structure to XML
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
File Adapter – Sender – Content Conversion to Convert CSV file to XML
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.
Simple Any File To File Scenario In ID Only Without ESR Objects
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,