0

SQL Data Collector for generic ODBC data source

Forum / Questions & Answers

I had an ODBC data source that I wanted to collect data from; looking at the SQL data collector, I see that it only supports MSSQL, MySQL, and Oracle, but a generic ODBC connection is not possible.

I wanted to confirm that my only choice was to do something like ODBC -> MSSQL -> Canary. 

2 replies

null
    • smason
    • 8 mths ago
    • Reported - view

    Hi jerome. lefebvre ,

    We have an ODBC connector, but that is only used for reading data from the historian. If you are trying to write to the historian, you would need use the SQL Collector in conjunction with MSSQL.

    • jerome_lefebvre.1
    • 8 mths ago
    • Reported - view

    Thank you for the confirmation.

    I hope this can be considered. Setting up a linked table in MS is always possible, but it is an extra hoop to jump over for little benefit.

Login to reply

Content aside

print this pagePrint this page
  • 8 mths agoLast active
  • 2Replies
  • 80Views
  • 2 Following