I sync WaterGEMS and SewerGEMS with a GIS with modelbuilder.
In ArcGIS (10.6.0.831), using the Bentley WaterGEMS (10.01.01.04) (64) V8I ModelBuilder i can transfert the data from the MDB DB (OLEDB personal geodatabase connected to WaterGEMS ) into the ESRI File Geodatabase through the SYNC-OUT using the "Label" as a key in SQLServer.
Its work well, but i would like to know if its possible to automate the 'Sync-IN' with a periodic execution e.g with python or ArcPy ?
Nearly anything is possible if you try hard enough, but it might not be worth it in this case since ModelBuilder provides an easy solution.
There isn't a way to automate the Sync-In function in ModelBuilder. If changes are made to the GIS data, you can pretty easily update the WaterGEMS model by using the Sync In function.
Depeneding on what you are ultimately doing, one thing you could look into is SCADAConnect Simulator, which does allow you to import real-time SCADA data from some data sources. This won't necessarily do things like change pipe diameters or elevations, but it may be used in order to compute a model to compare to data in the field.
It is possible to run ModelBuilder from a command prompt (search the help for ModelBuilder Batch Import), so you should be able to write a script to automate this.
For more information about batch imports in ModelBuilder, see the section at the bottom of this article: Import and export Modelbuilder connections with a Modelbuilder Connection File
What kind of information are you trying to update periodically?
Jesse DringoliTechnical Support Manager, Haestad ProductsBentley Communities Site AdministratorBentley Systems, Inc.
Thank you for the documentation, it is very appreciated ! The idea is actually to write a script to automate the processing it would be more robust and efficient than a manual execution.