Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Notifications
Login / Register
Community
Community
Notifications
close
  • Forums
  • Knowledge Center
  • Events & Webinars
  • Ideas
  • Blogs
Help
Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Login / Register
Sustainability
Sustainability

Join our "Ask Me About" community webinar on May 20th at 9 AM CET and 5 PM CET to explore cybersecurity and monitoring for Data Center and edge IT. Learn about market trends, cutting-edge technologies, and best practices from industry experts.
Register and secure your Critical IT infrastructure

ClearSCADA: external data to Historian at regular intervals

EcoStruxure Geo SCADA Expert Forum

Schneider Electric support forum about installation, configuration, integration and troubleshooting of EcoStruxure Geo SCADA Expert (ClearSCADA, ViewX, WebX).

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Home
  • Schneider Electric Community
  • Remote Operations
  • EcoStruxure Geo SCADA Expert Forum
  • ClearSCADA: external data to Historian at regular intervals
Options
  • Subscribe to RSS Feed
  • Mark Topic as New
  • Mark Topic as Read
  • Float this Topic for Current User
  • Bookmark
  • Subscribe
  • Mute
  • Printer Friendly Page
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
Top Experts
User Count
sbeadle
Kirk sbeadle Kirk
307
AndrewScott
Admiral AndrewScott
95
BevanWeiss
Spock BevanWeiss
89
AdamWoodlandToo
Lt. Commander AdamWoodlandToo
36
View All
Related Products
product field
Schneider Electric
EcoStruxure™ Geo SCADA Expert

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague Invite
Solved Go to Solution
Back to EcoStruxure Geo SCADA Expert Forum
Solved
Anonymous user
Not applicable

Posted: ‎2020-10-01 08:41 PM . Last Modified: ‎2023-05-03 12:09 AM

0 Likes
5
2731
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-10-01 08:41 PM . Last Modified: ‎2023-05-03 12:09 AM

ClearSCADA: external data to Historian at regular intervals

Hi All

 

There have been some similar questions [1], but I haven't found one that quite matches my use case.

 

* we are using the site ClearSCADA 2017 R3 historical data for reporting: summary, performance metrics, etc.

* the site ClearSCADA historical data is also used as a data concentrator for the national headquarters.

* we'd like to push report results back into the ClearSCADA historical database. Writing to live data is not preferred - the reports happen up to a day later, so pushing timestamped values back is very much preferred to time-of-data-arrival timestamps, i.e. if the data is pushed back in at 8 pm and shows values that happened at 2 pm, we'd like the values to be recorded as happening at 2 pm rather than 8 pm.

* if possible, it would also be good to be able to back-fill report data for several months. I believe there might be complications with this, however.

 

Currently we are pulling data from the database using the ODBC driver, querying CDBHistoric. However, CDBHistoric is read-only from ODBC (makes sense), so we need another way to get the data in.

 

Does anyone know if any of these work?

 

* ODBC to push timestamped historical data to a different table?

* Web API?

* Other scripting languages?

 

The only issue with the solution in the footnote is it's meant for manual data loading when someone clicks a mouse (deal-breaker) and is only good for data up to around 2 weeks old (not a deal-breaker). We need it to happen without user input e.g. every day at 6 am. Not clear if that's easy / possible / etc. Happy to RTFM, if someone could point me to the FM.  🙂

 

Thanks in advance

 

Jason

 

 

[1] https://community.se.com/t5/Geo-SCADA-Expert-Forum/Imported-CDBHISTORIC-table-SELECT-INSERT-UPDATE-e...

Labels
  • Labels:
  • SCADA
  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA control
  • SCADA data
  • SCADA integration
  • SCADA network
  • SCADA programming
  • SCADA software
  • scada system
  • SCADA tutorial
  • SCADA web application
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

  • All forum topics
  • Previous Topic
  • Next Topic

Accepted Solutions
AdamWoodland
AdamWoodland Schneider Alumni (Retired)
Schneider Alumni (Retired)

Posted: ‎2020-10-06 10:09 PM . Last Modified: ‎2023-04-25 04:01 AM

In response to BevanWeiss
0 Likes
0
2678
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-10-06 10:09 PM . Last Modified: ‎2023-04-25 04:01 AM

https://community.se.com/t5/Geo-SCADA-Knowledge-Base/Comparison-of-Methods-to-Transfer-Point-Data-Be... might be useful, Ecostruxture Web Services might be a good option to transfer data

See Answer In Context

  • Tags:
  • Ecostruxure looks like the winner here.
  • english
  • scada
  • SCADA app
  • SCADA control
  • SCADA data
  • SCADA integration
  • SCADA network
  • SCADA programming
  • SCADA software
  • scada system
  • SCADA tutorial
  • SCADA web application
  • Telemetry and SCADA
  • Thanks Adam
Reply

Link copied. Please paste this link to share this article on your social media post.

Replies 5
geoffpatton
Captain geoffpatton
Captain

Posted: ‎2020-10-02 07:19 AM

0 Likes
1
2718
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-10-02 07:19 AM

Are you sure you can't write to it from ODBC, if your ODBC connected program is logged in with a user that has the right to edit history?

 

You can do this using the .net api. You could simply have a Windows task Scheduled the runs you program, or make your program run all the time and check for the file update.

 

We have a program that imports history and it is run all the time. It checks if the input file timestamp has changed and when it has it processes the data.

 

I really don't know the details of how the data is loaded into the history, I did not write the program.

  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA control
  • SCADA data
  • SCADA integration
  • SCADA network
  • SCADA programming
  • SCADA software
  • scada system
  • SCADA tutorial
  • SCADA web application
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

BevanWeiss
Spock BevanWeiss
Spock

Posted: ‎2020-10-04 03:14 AM

0 Likes
1
2700
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-10-04 03:14 AM

What are the 'report results'?

From the way that you've currently described it, you have all this data in the ClearSCADA server, and then you send it to national headquarters for reporting... but then all the data should already existing in ClearSCADA... so I'm not sure what you'd be planning to push back in.

 

ClearSCADA can 'import' data from a wide range of sources via its Drivers.  One of those is ODBC.. so you could have it retrieving the report data from your national headquarters ODBC-compliant database if you wanted.. Using the driver you would then get this data into separate points (i.e. it wouldn't be the same point as you're reading from the field devices), so that might work for you.


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA control
  • SCADA data
  • SCADA integration
  • SCADA network
  • SCADA programming
  • SCADA software
  • scada system
  • SCADA tutorial
  • SCADA web application
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

AdamWoodland
AdamWoodland Schneider Alumni (Retired)
Schneider Alumni (Retired)

Posted: ‎2020-10-06 10:09 PM . Last Modified: ‎2023-04-25 04:01 AM

In response to BevanWeiss
0 Likes
0
2679
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-10-06 10:09 PM . Last Modified: ‎2023-04-25 04:01 AM

https://community.se.com/t5/Geo-SCADA-Knowledge-Base/Comparison-of-Methods-to-Transfer-Point-Data-Be... might be useful, Ecostruxture Web Services might be a good option to transfer data

  • Tags:
  • Ecostruxure looks like the winner here.
  • english
  • scada
  • SCADA app
  • SCADA control
  • SCADA data
  • SCADA integration
  • SCADA network
  • SCADA programming
  • SCADA software
  • scada system
  • SCADA tutorial
  • SCADA web application
  • Telemetry and SCADA
  • Thanks Adam
Reply

Link copied. Please paste this link to share this article on your social media post.

Anonymous user
Not applicable

Posted: ‎2020-10-07 05:50 PM . Last Modified: ‎2020-10-07 05:57 PM

0 Likes
0
2670
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-10-07 05:50 PM . Last Modified: ‎2020-10-07 05:57 PM

Not a bad idea @BevanWeiss , but they're not in a position to do this. For better or worse, the data workflow from site to office is:

 

(collect data on site) -> (perform performance and reliability calcs on site) -> (export to head office: subset of ClearSCADA data, plus on-site calcs).

 

They're expecting not every point at headquarters, and they are absolutely expecting on-site calcs to appear with certain tags. The sites are variable enough that this makes sense. It might not be how I'd do it, but it's not insane and it's what I have to work with.

  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA control
  • SCADA data
  • SCADA integration
  • SCADA network
  • SCADA programming
  • SCADA software
  • scada system
  • SCADA tutorial
  • SCADA web application
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

Anonymous user
Not applicable

Posted: ‎2020-10-07 05:52 PM . Last Modified: ‎2020-10-07 05:56 PM

In response to geoffpatton
0 Likes
0
2667
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-10-07 05:52 PM . Last Modified: ‎2020-10-07 05:56 PM

Thanks @geoffpatton for letting me know it's possible.

 

Other threads suggested that CDBHistoric is read-only to ODBC, and the error message I get simply says I'm not permitted to write to it. So I suspect it really can't be written to this way.

  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA control
  • SCADA data
  • SCADA integration
  • SCADA network
  • SCADA programming
  • SCADA software
  • scada system
  • SCADA tutorial
  • SCADA web application
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

Preview Exit Preview

never-displayed

You must be signed in to add attachments

never-displayed

 
To The Top!

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practice
  • Experts Leaderboard
  • Contact Support
Brand-Logo
Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Forum-Icon

Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account? Login

Terms & Conditions Privacy Notice Change your Cookie Settings © 2025 Schneider Electric

This is a heading

With achievable small steps, users progress and continually feel satisfaction in task accomplishment.

Usetiful Onboarding Checklist remembers the progress of every user, allowing them to take bite-sized journeys and continue where they left.

of