MySQL JDBC Sender Sample for PI 7.1

Firstly, download mysql jdbc driver (type 4) from http://www.mysql.com

Deploy jdbc driver by installation guide http://www.sapnew.com/index.php?action=blog&id=401

Restart SAP instance

Create a table named 'people' in database 'sapbc' in mysql server by phpMyAdmin, table instructure is like following feature

Create a user 'sap' of database, grant all access rights of table 'people' to it. 

ESR configuration

JDBC Communication Channel in ID