Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84612members
353911posts

[Imported] ODBC conection MySQL to ClearSCADA

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

Solved
sbeadle
Janeway Janeway
Janeway
0 Likes
1
530

[Imported] ODBC conection MySQL to ClearSCADA

>>Message imported from previous forum - Category:Scripts and Tips<<
User: lecadi, originally posted: 2019-01-11 20:46:48 Id:347
Dear all

We need to import the information of some variables from a database MySQL to points in ClearSCADA.
You could see in the image the dispnibility of information

For one point I could read the the value of variable, but we have an historical information for every single variable, so we need to import all historical to the historian to monitor in CLearSCADA the information.

![]((see attachments below) ol/vd7tsw3k9c2h.png "")


So we would like you help us with this issue

Attached file: (editor/ol/vd7tsw3k9c2h.png), imagen.png File size: 6212

Attachments

Accepted Solutions
sbeadle
Janeway Janeway
Janeway
0 Likes
0
529

Re: [Imported] ODBC conection MySQL to ClearSCADA

>>Responses imported from previous forum


Reply From User: BevanWeiss, posted: 2019-01-13 21:12:27
Have you looked at ODBC Points?
Look in the ClearSCADA help...


Reply From User: lecadi, posted: 2019-01-17 12:43:10
Thanks, it worked for me, but I have another question, the timestamp value in ClearSCADA its diferent from the original database, (there is a diferent of 5 hours). It looks like ClearSCADA assume the timestamp from original database were in another time zone. But in my case both server are in the same time zone


Reply From User: sbeadle, posted: 2019-01-17 12:57:56
ClearSCADA works in UTC/GMT, so timestamps need to be converted before the driver sees them (e.g. alter the query to add a function/expression to convert). Client settings control what you see, so you may not realise that underneath it's all UTC.

See Answer In Context

1 Reply 1
sbeadle
Janeway Janeway
Janeway
0 Likes
0
530

Re: [Imported] ODBC conection MySQL to ClearSCADA

>>Responses imported from previous forum


Reply From User: BevanWeiss, posted: 2019-01-13 21:12:27
Have you looked at ODBC Points?
Look in the ClearSCADA help...


Reply From User: lecadi, posted: 2019-01-17 12:43:10
Thanks, it worked for me, but I have another question, the timestamp value in ClearSCADA its diferent from the original database, (there is a diferent of 5 hours). It looks like ClearSCADA assume the timestamp from original database were in another time zone. But in my case both server are in the same time zone


Reply From User: sbeadle, posted: 2019-01-17 12:57:56
ClearSCADA works in UTC/GMT, so timestamps need to be converted before the driver sees them (e.g. alter the query to add a function/expression to convert). Client settings control what you see, so you may not realise that underneath it's all UTC.