Migrating Historical DBs from Other Vendors

[bwill1177]

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?

[BevanWeiss]

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.

[bwill1177]

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.