| View previous topic :: View next topic |
| Author |
Message |
nitol
Junior
Joined: 07 Mar 2017
Posts: 6
|
 Posted: 29/04/2017 17:25 Post subject: KEPServerEX OPC Server to SQL Database |
 |
|
| I can connect my Modbus RTU Temperature and Humidity sensor to KEPServerEX OPC Server v5.xx. I can see the current values of the sensor. I want to save the values to any sql database so that I can analyze the data for my operation. Can you help me how to connect KEPServerEX OPC Server to Sql server. Can you provide any sample code? |
|
| Back to top |
|
 |
sorella
Junior
Joined: 07 Apr 2017
Posts: 3
|
| Posted: 29/04/2017 18:59 Post subject: Re: KEPServerEX OPC Server to SQL Database |
|
|
| nitol wrote: | | I can connect my Modbus RTU Temperature and Humidity sensor to KEPServerEX OPC Server v5.xx. I can see the current values of the sensor. I want to save the values to any sql database so that I can analyze the data for my operation. Can you help me how to connect KEPServerEX OPC Server to Sql server. Can you provide any sample code? |
TRy this for a professional solutions
Log OPC Data to Databases
https://www.youtube.com/watch?v=MkTphBT6bsQ
or these if you want for logging occasionally
http://plc.myforum.ro/advanced-opc-data-logger-vt7981.html
http://plc.myforum.ro/opc-datalogger-pro-vt7235.html
http://plc.myforum.ro/opc-logger-vt5498.html |
|
| Back to top |
|
|
km/h
Junior
Joined: 03 Apr 2017
Posts: 8
|
| Posted: 29/04/2017 21:35 Post subject: OPC Easy Connect |
|
|
| nitol wrote: | | I can connect my Modbus RTU Temperature and Humidity sensor to KEPServerEX OPC Server v5.xx. I can see the current values of the sensor. I want to save the values to any sql database so that I can analyze the data for my operation. Can you help me how to connect KEPServerEX OPC Server to Sql server. Can you provide any sample code? |
Try this
OPC Easy Connect is a family of OPC middleware products that help you save time and money. The OPC Easy Connect Suite eliminates the complications that frequently arise in OPC communication between remote computers. It also simplifies the commissioning and use of OPC clients and servers and optimizes the performance of your OPC interfaces.
OPC Easy Connect Suite comprise products which make communication between OPC clients products possible, e.g. between DA and XML-DA products or between OPC clients easier by avoiding time-consuming DCOM configuration uniform by concentrating several OPC data sources into one OPC server more efficient through intelligent management when multiple OPC clients access the same data on an OPC server
All in one:
You only need one license! With the Easy Connect Basic License, you receive all OPC Easy Connect products: the OPC Tunnel, Bridge, Optimizer, Concentrator, Filter and Collector, as well as OPCtoDataBase and OPCtoFile (in development). You can combine the "filter", "concentrate", "optimize", "tunnel" and "save" functions in any way you like.
Simplify your OPC Connectivity!
The OPC Easy Connect Suite family currently comprises following products:
OPC Storage - Emulating any type of OPC server, for client-client communication
OPC Bridge - OPC gateway between any kind of DA or XML-DA implementations
OPC Optimizer - Optimizing access of numeroase OPC clients to one OPC server
OPC Tunnel - Establishing OPC communication between networks within just a few minutes
OPC Concentrator - Consolidating data from several OPC servers into a single OPC server
OPC Filter - Restricts access to data on an OPC server and hides individual items
OPC Collector - freely configurable client which collects OPC data from any DA or XML DA server
OPCtoDataBase - saves OPC data in ODBC-enabled databases
It's demo but is a nice tool
[URL=https://userscloud.com/zshyphg2q0jm]Softing_Easy_Connect_Suite.exe - 23.5 MB[/URL] |
|
| Back to top |
|
|
nitol
Junior
Joined: 07 Mar 2017
Posts: 6
|
| Posted: 30/04/2017 08:57 Post subject: |
|
|
| Thanks for your replay. Can you help me with the KepServer as I have the licence for the software. |
|
| Back to top |
|
|
tomsen
Junior 2
Joined: 30 Apr 2015
Posts: 20
|
| Posted: 04/06/2017 05:41 Post subject: |
|
|
| Did u not install the datalog add-on for the kepware? |
|
| Back to top |
|
|
joomla
Junior
Joined: 02 Jun 2017
Posts: 7
|
| Posted: 04/06/2017 18:15 Post subject: Connect to kepware via VB via OPC |
|
|
| nitol wrote: | | Thanks for your replay. Can you help me with the KepServer as I have the licence for the software. |
some source code on
Connect to kepware via VB via OPC
http://plc.myforum.ro/kepware-kepserverex-v45004650-vt8392.html
https://www.kepware.com/en-us/support/resource-library/legacy-technical-notes/odbc-and-sql/ |
|
| Back to top |
|
|
joomla
Junior
Joined: 02 Jun 2017
Posts: 7
|
| Posted: 04/06/2017 19:01 Post subject: |
|
|
http://plc.myforum.ro/viewtopic.php?p=27476#27476
KepserverEX Server Specific Manual Downloads and ESI Store Links
http://www.eternity-sales.com/Kepware/kepwaredownloads.htm |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
