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 July 22nd, 2012, 09:23 AM   #1
Faja
Member
Poland

Faja is offline
 
Join Date: Jul 2012
Location: Rybnik
Posts: 6
Set up OPC Server and MySQL database

Hello, I have problem with set up some sofware to collect data. I have:

- GE Fanuc with program
- TopServer for getting information from PLC

And now I want to collect data to mySQL database and I found "MatrikonOPC Client for ODBC" but it's only saving my data to txt file. I was thinking this isn't piece of software I want, so I search and found "MatrikonOPC Server for GDA" but now I dont know if I must install and configure both of this matrikon sofware or only just need MatrikonOPC Server for GDA. Maybe in first one I can connect to mysql database but i dont know ho do it.

thanks for any help
  Reply With Quote
Old July 22nd, 2012, 09:44 AM   #2
parky
Member
United Kingdom

parky is offline
 
Join Date: Oct 2004
Location: Midlands
Posts: 979
Try using the Kepserver V5.xx this has the abillity to populate a DB directly, you can download it & it will run for 2 hrs at a time so for evaluation it;s great.
I have only tried on a MS SQL DB but it worked fine.
  Reply With Quote
Old July 22nd, 2012, 09:50 AM   #3
diat150
Lifetime Supporting Member
United States

diat150 is offline
 
Join Date: Mar 2006
Location: Louisiana
Posts: 1,260
you could also look into Ignition by inductive automation. you would only need the sql bridge to do what you want to do.

http://www.inductiveautomation.com/scada-software
  Reply With Quote
Old July 22nd, 2012, 02:26 PM   #4
Faja
Member
Poland

Faja is offline
 
Join Date: Jul 2012
Location: Rybnik
Posts: 6
Quote:
Originally Posted by parky View Post
Try using the Kepserver V5.xx this has the abillity to populate a DB directly, you can download it & it will run for 2 hrs at a time so for evaluation it;s great.
I have only tried on a MS SQL DB but it worked fine.

I understand that I must install kepserver instead of Matrikon OPC , yes?

I will write again what I mean:
- I have GE Fanuc with Proficy Machine edition where I export my variables and collect data in TopServer and it must be, now:

- I must collect historical data in mysql database(I have this database already in db4free.net)
- Now, with Kepserver I must have any OPC server(Matrikon OPC Client?)?

And is anywhere manual how export data to mysql database?


Sorry but I want clear with everything.
  Reply With Quote
Old July 23rd, 2012, 11:42 AM   #5
krutherford
Member
United States

krutherford is offline
 
Join Date: Jul 2012
Location: Farmington, NY
Posts: 1
TOP Server is a branded version of KEPServerEX, so the two wouldn't be able to co-exist on the same PC. The functionality being referred to is the DataLogger Plug-In option for TOP Server which allows ODBC data logging of any data you are receiving in TOP Server.

Typically, though, we recommend the OPC Data Logger (http://www.opcdatalogger.com/), which would act as an OPC Client to TOP Server.

OPC Data Logger has a native MySQL interface, which tends to be more robust than a generic ODBC interface, can log data from any OPC DA or UA compliant server, supports file spanning, writebacks and more. You can download a demo version at the link above.
  Reply With Quote
Old July 23rd, 2012, 03:41 PM   #6
parky
Member
United Kingdom

parky is offline
 
Join Date: Oct 2004
Location: Midlands
Posts: 979
If you are familiar with Vb you could write your own, kepserver (or badged version) has normally some vb code snippets on the disk + the opc interface dll to work with vb.
I have used this to log data to a SQL server I use the free download of SQLEXPRESS from MS
  Reply With Quote
Old July 23rd, 2012, 05:45 PM   #7
robw53
Member
United Kingdom

robw53 is offline
 
robw53's Avatar
 
Join Date: Nov 2009
Location: south yorks
Posts: 514
Parky,

can you recommend any good videos/PDF's for setting up a MS SQL database?
__________________
"So far as is reasonably practicable

"Not everything that can be counted counts and not everything that counts can be counted"
Albert Einstein
  Reply With Quote
Old July 24th, 2012, 01:01 PM   #8
parky
Member
United Kingdom

parky is offline
 
Join Date: Oct 2004
Location: Midlands
Posts: 979
You could use VB2012 Express it's free to download for personal use, it has all you need to create an SQL Database locally for trials, you will need SQLExpress as well.
There are many sites with VB & SQL programming like programmers heaven etc. search for specifics like vb2012 opening an SQL database etc. there are loads.
One thing think about the data you want to log, how you will filter the data etc.
for example always have a field with datetime so you can filter by datetime, also if some data ties in with say a batch code use this field in all tables as this will allow to filter by batch code, it's best to get the fields in the tables correct as adding or deleting fields after data has been added can remove previous data.
If you use the simple opc code supplied with kepserver just modify it to suit your application, I started this way then expanded it to include an editor for the tags & checks to reduce the overhead of lots of changing data, I also included reports so not only does it store the data in the database but also allows the operator to display & print reports & graphs.
Although the code is well documented, it can be quite difficult to understand how to access the data outside the callback function.
Good luck
  Reply With Quote
Old July 25th, 2012, 02:40 AM   #9
Faja
Member
Poland

Faja is offline
 
Join Date: Jul 2012
Location: Rybnik
Posts: 6
Quote:
Originally Posted by krutherford View Post
Typically, though, we recommend the OPC Data Logger (http://www.opcdatalogger.com/), which would act as an OPC Client to TOP Server.

OPC Data Logger has a native MySQL interface, which tends to be more robust than a generic ODBC interface, can log data from any OPC DA or UA compliant server, supports file spanning, writebacks and more. You can download a demo version at the link above.
I configured opc data logger and I have this error:
Quote:
Event Type: Error
Occurred At: 2012-07-25 07:54:29
From Location: Data Logger Logging
Message: Collector1 found errors with the following items:
Temp2 (0xc0040007). The item is no longer available in the server address space.
Attached Images
File Type: jpg blad.jpg (84.9 KB, 99 views)

Last edited by Faja; July 25th, 2012 at 02:57 AM.
  Reply With Quote
Old July 25th, 2012, 04:23 AM   #10
JesperMP
Lifetime Supporting Member + Moderator
Denmark

JesperMP is offline
 
JesperMP's Avatar
 
Join Date: Feb 2003
Location: Copenhagen.
Posts: 13,440
The OPC Items that the data logger has to access, can you access them via an OPC Test client ?

Always use an OPC Test client to find out if the problem is with the OPC Server or the OPC Client.
__________________
Jesper
3 strikes and you're out
  Reply With Quote
Old July 25th, 2012, 04:34 AM   #11
Faja
Member
Poland

Faja is offline
 
Join Date: Jul 2012
Location: Rybnik
Posts: 6
Quote:
Originally Posted by parky View Post
Try using the Kepserver V5.xx this has the abillity to populate a DB directly, you can download it & it will run for 2 hrs at a time so for evaluation it;s great.
I have only tried on a MS SQL DB but it worked fine.
Quote:
Originally Posted by JesperMP View Post
The OPC Items that the data logger has to access, can you access them via an OPC Test client ?

Always use an OPC Test client to find out if the problem is with the OPC Server or the OPC Client.

I tested in OPC Test client and everything works fine :-/
  Reply With Quote
Old July 25th, 2012, 04:46 AM   #12
JesperMP
Lifetime Supporting Member + Moderator
Denmark

JesperMP is offline
 
JesperMP's Avatar
 
Join Date: Feb 2003
Location: Copenhagen.
Posts: 13,440
Then the problem is in the OPC Client Datalogger.

Have you managed to get anything to work ? Or is it just one item that does not work ?
Are you sure you have the OPC Item name absolutely correct ?
Do you define the OPC Item by typing the name manually, or can you browse for the OPC Items ?

Unfortunately I have no experience with either GE Fanuc nor OPC Datalogger.
__________________
Jesper
3 strikes and you're out
  Reply With Quote
Old December 6th, 2018, 12:21 PM   #13
Ramirez2018
Member
United States

Ramirez2018 is offline
 
Join Date: Dec 2018
Location: USA
Posts: 1
Help me

Quote:
Originally Posted by parky View Post
Try using the Kepserver V5.xx this has the abillity to populate a DB directly, you can download it & it will run for 2 hrs at a time so for evaluation it;s great.
I have only tried on a MS SQL DB but it worked fine.


Hi, recently I've been interested in the OPC server, right now I need to send analog values ​​(pressure meter). I have already been able to cominicar the keeperver and an S7-1200, now I only need to send these values ​​to MySQL, how do I configure MySql?
  Reply With Quote
Old December 11th, 2018, 04:47 AM   #14
k_w
Member
United States

k_w is offline
 
Join Date: Jan 2015
Location: Houston
Posts: 33
You can use Integration Objects OPC EasyArchiver
  Reply With Quote
Old December 11th, 2018, 05:10 AM   #15
JesperMP
Lifetime Supporting Member + Moderator
Denmark

JesperMP is offline
 
JesperMP's Avatar
 
Join Date: Feb 2003
Location: Copenhagen.
Posts: 13,440
Hi k_w.

Every single post form you, you link to Integration Objects products.
Are you affiliated with them or are you just very fond of their products ?
If you are affiliated with them you should write that in your profile.
Apart from those links, you dont contribute much.

IMO it is OK to suggest a product that you are connected with as long as it is relevant to the topic, and you openly state your connection with it.
__________________
Jesper
3 strikes and you're out
  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
using c to access MySql database in Linux nirmal LIVE PLC Questions And Answers 5 February 19th, 2004 09:27 PM


All times are GMT -5. The time now is 01:13 PM.


.