How to Log a Rockwell Automation FactoryTalk View SE Datalog to a SQL Database
HTML-код
- Опубликовано: 22 дек 2024
- McNaughton-McKay's Systems Engineer, Justin Wyman shows you an inexpensive way to get Rockwell Automation's FactoryTalk View SE Datalog information into a SQL Database? In this video, Justin will show you how to use native tools within FactoryTalk View SE to log a datalog directly to a SQL Database.
Website: www.mc-mc.com
Contact Us: 844-687-6262 or www.mc-mc.com/...
Subscribe on RUclips: www.youtube.co....
LinkedIn: / mcnaughton-mckay
Facebook: / mcnaughtonmc. .
Twitter: / mcnaughtonmckay
Blog: www.mc-mc.com/...
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
This is the best chanel, nobody teaches What you teach. Congratulations guys!!!
Thank you, David. We're happy to hear you're enjoying the videos and hope it brings you value!
Hello, Thanks for this useful information, question, is it possible do exactly the same but using an Excel file to storage the data instead SQL?
Hello,
In View SE, there is an ActiveX control object called ME DataStore Plus that can be used. You can search the Rockwell Automation Knowledgebase for more details on configuration: rockwellautomation.custhelp.com/
There is also a paid software called XLReporter that gives more ease of use and customization for logged data in Excel. Please reach out to your local Rockwell Automation distributor for more information on this product or if you have further questions or concerns.
Hi, i am getting error ODBC data source for datalog model TEST is unavailable. it worked well for 3 days and logged data in SQL but after this error it is not logging any data. can you please help me out in this? Thanks
Hello,
There could be multiple things that can cause your SQL Database to stop logging data. For further support we recommend contacting your local Rockwell Automation distributor. If you are local to one of our branches, we would be happy to assist you. www.mc-mc.com/LocationFinder
If you are not local to us, you can find your local Rockwell Automation distributor here: locator.rockwellautomation.com/
Hi it’s possible to read the sql values to ftview? For example if I read a value since last month I put the date on ftview and then show the values? Tnx
FactoryTalk View SE does not have any built in support for creating reports from SQL data logs. A third-party program must be used. Chapter 21 of the FactoryTalk View SE User’s Guide explains the features and limits of datalogging in more detail: literature.rockwellautomation.com/idc/groups/literature/documents/um/viewse-um006_-en-e.pdf
If you have further questions or concerns, please reach out to your local Rockwell Automation distributor.
@@mcnaughtonmckay ill try to follow your steps but in sql server selection I don’t have any server. What is the sql software necessary to install for obscure works?
@@alfredoratti1290 In factory talk view Studio, it requires a Microsoft SQL Server for SQL data logging.
You can download an express version for free from Microsoft’s website. We still recommend reaching out to your Rockwell Automation distributor for personalized support.
@@mcnaughtonmckay yes but which version of sql? 2012? O more?
@@alfredoratti1290 Please refer to this page : compatibility.rockwellautomation.com/Pages/home.aspx
Search for FactoryTalk view site edition, then click the version you have. Then click compare. It depends on which version of FactoryTalk you are using.
Hi i have factorytalk view SE , do i need to buy SQL server software/license separately For data logging ?
Hello, you will want to use Microsoft SQL Server Express. This is free software but will be needed to be downloaded separately. The link to the download:
www.microsoft.com/en-us/sql-server/sql-server-downloads
Thank you for this video, was super helpful - fellow sys int
Thank you for taking the time to voice your appreciation. It is encouraging to know we are delivering great educational videos, and we will strive to continue to do so.
How to setup SQL management studio pls help thx
Hello and thanks for reaching out! To best answer your question we would need a bit more information and suggest a conversation with our technical team, or that of your local distributor, who can speak with you on your specific setup. To contact us: www.mc-mc.com/AllLocations or to find your local Rockwell Automation Distributor use: partners.rockwellautomation.com/en-US/partner-locators/
Hello, how are you? Does the option to start DataLog not appear in the SE Local version?
Hi Samuel, Thank you for reaching out. If you are referring to 3:48 in the video, yes the “Start” option should still appear in a SE Local Station project. If you have further questions or concerns, please reach out to your local Rockwell Automation distributor.
followed the procedure but no tag found in SQL
Hello, Please refer to the FactoryTalk View SE Users guide that is linked here:
literature.rockwellautomation.com/idc/groups/literature/documents/um/viewse-um006_-en-e.pdf
If you have further questions or concerns, please reach out to your local Rockwell Automation distributor for personalized assistance.
Hi, How to extract this SQL data to external report? Can you explain please?
Hi Jagadeesh, Unfortunately, FactoryTalk View SE does not have any built in support for creating reports from SQL data logs. A third-party program must be used. Chapter 21 of the FactoryTalk View SE User’s Guide explains the features and limits of datalogging in more detail: literature.rockwellautomation.com/idc/groups/literature/documents/um/viewse-um006_-en-e.pdf
If you have further questions or concerns, please reach out to your local Rockwell Automation distributor.
You can use Power BI to extract data and create reports.
how can I make automatically delete the accumulated DATA LOG when it reaches 20 GB in factory talk view Release 6.10.00(CPR 9SR4)? if you can send me video & I appreciate your cooperate
Hello, If you would like to delete based on size, that has to be done with a schedular using tools appropriate to the ODBC Database you are logging to. For SQL, you would run a SQL Stored Procedure to delete oldest records based on size. However, if you have an idea of how much data you are logging in a specific time period, you could use the built in tool in FTView SE to delete oldest records based on time in the file management tab of the data log setup. These are some good KB docs to both show how to setup a data log to SQL as well as some purging methods using VBA. The VBA example is for RSView32, but will work for FTView as well:
FactoryTalk View SE ODBC Datalog Fails to Purge Records from SQL Tables
rockwellautomation.custhelp.com/app/answers/answer_view/a_id/724625/loc/en_US
FactoryTalk View SE - How to Setup SQL Datalogging
rockwellautomation.custhelp.com/app/answers/answer_view/a_id/1082092/loc/en_US
Datalog purge records in ODBC database does not work
rockwellautomation.custhelp.com/app/answers/answer_view/a_id/39675/loc/en_US
If you have further questions or concerns, please reach out to your local Rockwell Automation distributor.
This project is only to Site Edition. Do you have a sample for Machine Edition? Thanks
Hello, the Machine Edition datalog is local to the HMI. As a result Machine Edition cannot be used to log to an SQL Database. If you have further questions or concerns, please reach out to your local Rockwell Automation distributor for personalized support.
@@mcnaughtonmckay Thank you for your answer.
Hi, I am getting error once pressing "Start" datalog. the error message is "unable to access ODBC
Hi Ayyub, To resolve this error, a LOCAL SERVICE user must be added using the SQL Server Management Studio with sysadmin privileges. The FactoryTalk View SE User’s Guide may also be a good reference: literature.rockwellautomation.com/idc/groups/literature/documents/um/viewse-um006_-en-e.pdf
If you have further questions or concerns, please reach out to your local Rockwell Automation distributor.