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
84647members
353987posts

Migrating Historical DBs from Other Vendors

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.

bwill1177
Crewman
Crewman
0 Likes
2
173

Migrating Historical DBs from Other Vendors

Does anyone have any experience importing Historical DBs from other vendors (i.e. iFix or Wonderware) into a GeoSCADA historical database?  I've looked at some of the tools around History Import/Export, but it seems to be geared at GeoSCADA DB to GeoSCADA DB situations.  Are there any SQL-type tools for this migration?

2 Replies 2
BevanWeiss
Spock
Spock
0 Likes
1
170

Re: Migrating Historical DBs from Other Vendors

I've never tried to import historical data using the SQL interface (that I can recall).  The .NET API / Automation Interface provide methods which are typically much more efficient.

 

LoadDataValue / LoadDataValues / LoadDataFile

 

I've done a number of historical data imports for iFix, OSIsoft PI, Citect... there's nothing particularly magic about any of them.  The hardest part is generally exporting the historical data into a nice enough format to deal with (especially for a platform like Citect... it's annoying to get the data out in a nice format).

 

Once you've got the data into like a CSV type of format, then you can just use some .NET programming, or even VBA scripting in Excel to do either LoadDataValue or LoadDataValues to stuff it into Geo SCADA Expert.

 

If you go the extra distance to format it nicely for LoadDataFile then you can use this also, it's 'faster' to process... but I consider it takes longer to format the data into the first fashion for it, so overall I find it to take longer, hence just stick with LoadDataValues.


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..
bwill1177
Crewman
Crewman
0 Likes
0
152

Re: Migrating Historical DBs from Other Vendors

Thanks for the detailed reply!  I figured the answer was something similar with some CSV manipulation and .NET API methods as my best bet.  I may be adding to this topic as I dig into the details.  Cheers.