We have target source as Oracle / Energy Component. Event based data (data set/ record) from PI needs to push to Oracle. Which tool is better & why?
KB01481 - Features of PI Integrator for Business Analytics
In this KB, you can find benefits about PI Integrator for BA at "Features" part.
Asset and Event Centric Views
Variety of Publish Targets
Shaping and Filtering
Publishing on a Schedule
Web Based User Interface
For more details, please see KB01481.
Of cause if you have right knowledge of programming, almost the same things can be done by PI OLEDB Enterprises.
However, it requires customize settings/ configurations.
The good thing is that you can buy PI Integrator for BA and you can get support from OSIsoft.
(If you configure it manually by PI OLEDB Enterprise, you need to maintenance this configuration)
Also for using PI OLEDB Enterprise in production environment, it requires PSA(PI System Access) license.
Retrieving data ...