formerpigeek

Using PI OLEDB for bulk data transfer

Discussion created by formerpigeek on Aug 18, 2010
Latest reply on Aug 27, 2010 by pcombellick

Hi

 

 

 

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

 

Kavita

Outcomes