What is best way to near real-time load 1800 tags per second from OSIsoft PI Historn into Teradata
My goal is to keep a rolling few days of the 1 second data in Teradata. 1800 PI tags per second = 180,00 measurements per minute. Loading as frequently as can. Without writing code, here's what I see are my PI options:
1. PI OLEDB Enterprise Connector with the Teradata OLEDB provider and setting up jobs on Teradata every few minutes to pull in the data
2. PI Web Services and the Teradata XML adapter
Want to leverage Teradata FASTLOAD capabilities as well. Appreciate your thoughts.