You are not registered yet. Please click here to register!


 
 
plc storereviewsdownloads
This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
 
Try our online PLC Simulator- FREE.  Click here now to try it.

---------->>>>>Get FREE PLC Programming Tips

New Here? Please read this important info!!!


Go Back   PLCS.net - Interactive Q & A > PLCS.net - Interactive Q & A > LIVE PLC Questions And Answers

PLC training tools sale

Reply
 
Thread Tools Display Modes
Old March 9th, 2018, 06:43 AM   #1
rleon
Member
Argentina

rleon is offline
 
Join Date: Aug 2008
Location: Baires
Posts: 125
Best database option for FTView historical Datalogs?

According to your experience, what is the best database to use in Datalogs?

Historian sucks. A ultra expensive software, a real headache. Too many bugs, it usually hangs up and suddenly stops registering data, with which you have to restart the server. I also hate the way interpolation of number transitions. For example, if I change a Set Point from 40 to 60, instead of showing it as a straight step, it shows it as a sawtooth. Or when there are zero values ​​for a long time, it does not register them and when that value stops being zero, it connects the new data with a wrong curve that does not correlate with reality, because it connect the 1rst zero value with a sawtooth with the new data. Everytime you open a TrendX display, you have to pray that the pens still there drawing curves.

SQL Server: Excellent because it supports large databases. Easy to integrate with VBA for SQL queries. The problem is that sometimes it hangs and stops registering with which you have to restart the DatalogOn command. Why? I dont know. I do not even know if the problem is in FTView or in SQL Server.

DBase: The most robust of all, almost never hangs, but due to its limited database capacity, forces me to create new files (weekly in my case), which is more cumbersome if you want to make a query SQL with date range. I had planned to continue using DBase and when I want to do a query by dates, create a SnapShot to TrendX in that range of dates and send that data to a unique dbf file.

What database do you use? Experiences, recommendations?

Thanks!
  Reply With Quote
Old March 9th, 2018, 07:25 AM   #2
Dravik
Member
United States

Dravik is offline
 
Join Date: Jun 2008
Location: New York
Posts: 1,316
We use SQL and FT Historian with FTView in various places.

SQL Server - No issues beyond normal 'IT' stuff when we have to patch or tempdb walks in front of a moving bus.

Historian - No issues, but getting all the point configs right takes a fair bit of forethought. The live data interfaces do die from time to time, but I run the critical ones as warm fail overs anyhow, so we don't lose data.

Another one we use locally is Ignition, the PLC to SQL bits are rock solid and don't give me any trouble.
  Reply With Quote
Old March 12th, 2018, 09:36 AM   #3
rleon
Member
Argentina

rleon is offline
 
Join Date: Aug 2008
Location: Baires
Posts: 125
Angry

Quote:
Originally Posted by Dravik View Post

Another one we use locally is Ignition, the PLC to SQL bits are rock solid and don't give me any trouble.
It seems nice. I will check the demo. I don't wanna experience again the creepy moment when you open the TrendX display and see NO live and NO backward data.

Thanks
  Reply With Quote
Reply
Jump to Live PLC Question and Answer Forum

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Topics
Thread Thread Starter Forum Replies Last Post
Discrete processes : OPC Servers to database: historians or SQL database? Christ0phe LIVE PLC Questions And Answers 7 December 18th, 2012 03:21 PM
FT Transaction Manager to SQL Database accidentalengineer LIVE PLC Questions And Answers 14 December 14th, 2011 10:22 PM
WinCC Historical Database suppaman LIVE PLC Questions And Answers 0 January 4th, 2011 05:29 AM
CIMPLICITY 7.5 Historical Alarm Viewer/SQL Server PLBoudette LIVE PLC Questions And Answers 3 October 20th, 2008 05:27 AM
Need WinCC Option for truck loading system huynt LIVE PLC Questions And Answers 7 July 14th, 2005 01:18 AM


All times are GMT -5. The time now is 01:27 AM.


.