osipi_geek
Member
Hi All,
First post here.
I am having some issues extracting large amounts of tag history from WonderWare into another historian.
Unfortunately OPC isn't performing the best, so my only other options is through ODBC.
(For more details on OPC.. I am using HDA so I know the performance won't be the best as it's constantly pulling values from the last time stamp that was collected.. Also I notice that the OPC Server for inSQL just connects to Microsoft SQL Server and executes queries... and my whole intent is to try and eliminate MS SQL Server from the equation)
Does anybody know if there is a native ODBC driver for WonderWare inSQL (Historian), and by this i mean an ODBC connection that does not connect to inSQL through Microsoft SQL Server?
If there were an ODBC that connected directly to inSQL rather than using 'linked server' through SQL Server, I would assume the performance may increase.
If you dont know, but have experience with polling large amounts of data from WonderWare historian, any information would be appreciated.
Thanks!
RDS
OSISoft PI System Administrator
First post here.
I am having some issues extracting large amounts of tag history from WonderWare into another historian.
Unfortunately OPC isn't performing the best, so my only other options is through ODBC.
(For more details on OPC.. I am using HDA so I know the performance won't be the best as it's constantly pulling values from the last time stamp that was collected.. Also I notice that the OPC Server for inSQL just connects to Microsoft SQL Server and executes queries... and my whole intent is to try and eliminate MS SQL Server from the equation)
Does anybody know if there is a native ODBC driver for WonderWare inSQL (Historian), and by this i mean an ODBC connection that does not connect to inSQL through Microsoft SQL Server?
If there were an ODBC that connected directly to inSQL rather than using 'linked server' through SQL Server, I would assume the performance may increase.
If you dont know, but have experience with polling large amounts of data from WonderWare historian, any information would be appreciated.
Thanks!
RDS
OSISoft PI System Administrator