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 ?
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.