Can we use PI OLEDB to transfer bulk data like around 1 lakh records from OLEDB to SQL server?
We have a Web application which needs the data of PI Server in a processed format. To achive this we want to get the data from PI Server into our SQL database where in the data gets processed and then used by the web application. We want the transfer to be done within 2 secs for 1 Lakh records.
We would also like to know if there are any other ways of doing bulk data transfer from PI to SQL database.
Thanks & Regards