intouch + data base link

rancalifa

Member
Join Date
Oct 2005
Location
israel
Posts
18
hi guys,

i am planning a control sys with an HMI base on intouch . i want to make a connection between the DB (MY SQL) to the intouch ( the intouch would store relevat data in the SQL and the user would see and analyze the data with the help of a GUI (develop with c#) . any way how can i make this connection ? does INTOUCH got any built in function for it ?


thanks for you'r help

ran
 
I've linked it with Access a few years back. You have to ensure you set up links in the ODBC manager and connect links in a start-up script.
 
What version of InTouch are you using? You could use an add on called SQL Access Manager. Here is a quote from the PDF.

WonderwareFactorySuiteSQL Access Manager allows you to access,modify, create and delete tables in a database. A database stores information in tables that share a common attribute or field. Structured Query Language (SQL) is the language used to access that information.


This PDF file comes with your copy of InTouch if you are having problems finding let me know and I can send it to you.

It's 45K over the limit on this board or I would have uploaded it....
 
Last edited:

Similar Topics

Hi All, I currently looking to set up Wonderware Intouch 2014 R2 v 11.1.08 to SQl Data Base For logging alarms, I keep getting An error when I...
Replies
2
Views
3,424
Hello everyone, I am developping an application and i want to be able to consult the info in a certain period of time. For example ÁreaX...
Replies
0
Views
3,772
Dear All, Can anyone please tell me how to configure USERNAME, PASSWORD & ACCESS LEVEL from an excel file to Intouch . ie.. All the users and...
Replies
4
Views
6,007
Hi All, I'm keep getting double quotes in between selections rather than the beginning and the end. Here's the script and please help to find...
Replies
7
Views
798
Hi, does anyone know how to tell in Aveva InTouch (v2020) whether the primary or secondary data source is active (i.e is failover active or...
Replies
3
Views
577
Back
Top Bottom