Is there any mechanism to store Historian Data directly into any RDBMS like Oracle/SQL Server instead of Files

GridProtectionAlliance / openHistorian

The Open Source Time-Series Data Historian

MIT License

172 stars 51 forks source link

Is there any mechanism to store Historian Data directly into any RDBMS like Oracle/SQL Server instead of Files #49

Closed ankitshah-it closed 5 years ago

ankitshah-it commented 5 years ago

Dear All, As i must store data into RDBMS Oracle or SQL Server, So can we store the Data which we are storing into the Files instead can we store directly (not import-export) Oracle or SQL Server Database. If yes then how it is possible if no what are the limitations. Thanks in Advance

ritchiecarroll commented 5 years ago

You can use the ADO output adapter for this exact purpose. However, there are real limitations on the volume of data you can archive into a database. If you are looking to archive synchrophasor data, you will be limited to a small set of devices.

ritchiecarroll commented 5 years ago

@ankitshah-it - since this is not technically an issue with openHistorian I am going to close this ticket. Note that we have a discussion board where you can ask general questions and search for previous answers, see here:

https://discussions.gridprotectionalliance.org/c/gpa-products/openhistorian

Thanks! Ritchie

ankitshah-it commented 5 years ago

Thanks