on 02-07-2014 3:09 AM
Dear All,
I have a requirement to integrate My Sql data base with PI. Basically wanted to have a batch job running in PI which will pull out data from the database table , thenlocally create the required xml msg in PI based on the pulled data & submit the xml to another interface in PI.
Wanted to know ways to do this in PI . Data volume is very high so any particular recommendation for scenario.
Thanks
Tusar
Hi Tusar,
You can achieve this using JDBC Adapter. It can process huge data as well.
Maintaining Poll Intervals based on your requirement.
Regards,
Sid.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Tushar,
Addition of few points to Hareesh's message,
Basically wanted to have a batch job running in PI which will pull out data from the database table ,
In SAP PI we have sender channels which will poll as per the requirement, which means u can schedule the channel which will pick or say will pull the data from the database.
Wanted to know ways to do this in PI . Data volume is very high so any particular recommendation for scenario.
you can use Select query in sender communication channel to select one row at a time to handle the load.
reference which can help
Configuring the JDBC Adapter - Advanced Adapter Engine - SAP Library
http://www.riyaz.net/sap/jdbc-adapter-configuration/1200/
hope this helps,
thanks and regards,
Praveen T
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Basically wanted to have a batch job running in PI which will pull out data from the database table
I hope you are referring to communication channel. You can schedule the channels in PI to pull the data from database.
SAP PI Adapter Series: JDBC Adapter Configuration
thenlocally create the required xml msg in PI based on the pulled data & submit the xml to another interface in PI
When PI picks the data from tables, it automatically converts into XML. What do you mean by other interface in PI?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.