SCADAConnect Simulator adding a "#" symbol to SQL query

Product(s): WaterGEMS
Version(s): CONNECT Edition


When importing historical SCADA data from the SQL server, a "#" is being added to the SQL query, which will not allow the data to be imported properly.


This can be resolved by adjusting the prefix and suffix for the data/time delimiters. To do this, go to the Database Connection in SCADAConnect Simulator and click the Advanced button. There you will find the Prefix and Suffix for SQL Query Date/Time Delimiters. Change these to an apostrophe (') symbol. This should help with the issue.

See Also

Using SCADAConnect Simulator

  • Created by Bentley Colleague
  • When:
  • Revisions: 1
  • Comments: 0