On-premise and Cloud Databases

Model data is maintained in a database.

The following types of databases are available with InfoWorks software:

• Workgroup - An on-premise database intended for use by individuals and groups of users. Requires the use of the Workgroup Server software, provided by us to manage access to these types of databases. The software was designed to improve the performance and reliability of database operations in a workgroup environment. To share the database as part of a workgroup, it must be located on a machine where it can be accessed by all users. Refer to the InfoWorks ICM help for details on Workgroup Servers.

  The following types of on-premise workgroup databases are available:

  • Standard (WorkGroup) Database
  • SQL Server (WorkGroup) Database
  • Oracle (WorkGroup) Database

  SQL Server and Oracle workgroup databases requires your own Microsoft SQL Server or Oracle database installation.

• Standalone - An on-premise database intended for use by individual users working on a single PC. This type of on-premise database is only appropriate for use on a standalone machine.
• Cloud - A cloud database intended for use by individual and multiple users. Access to cloud databases is handled by the cloud data service, which is managed by Autodesk. This lets you take advantage of the unlimited storage and increased processing capabilities of the cloud and removes the need to set up and maintain an internal server that is required for workgroup on-premise databases.
  Note: Cloud databases are not available in ICMLive Operator Client.

When a database is created, local working copies of parts of this data are then made available in each user's local root. Simulation results are stored in the remote results root. These two roots are set in InfoWorks ICM Ultimate or ICMLive Configuration Manager. See the InfoWorks ICM help for more information.

Database identifiers

Each database has a Unique Database Identifier. When a new database is created, this identifier is generated automatically as a string of letters and numbers taking the form 629810C2-3F6B-11D3-9BF3-00600891B690.

Database versions

Each database has a version number. For example, a database created with version 2023.0 of the software will have a database version of 2023.0. You can choose which version of the database is to be used when you create a database. This can be useful if you collaborate with other users who do not work with the same version of ICMLive Operator Client as you.

Note:

• If you work with a database that is earlier than the version of the software you are using, for example, database version 2023.0 with software version 2023.1, you may not be able to access all the new features that are available in the newer version of ICMLive Operator Client. The availability of a new feature depends on whether or not it requires database tables and fields, such as object properties or a database item, that are only available in the newer version of the database, or if there have been other changes that may affect results.
• You can update an earlier version of a database to a newer one. This lets you access all the features available in the newer version of the software. However, the updated database cannot be used, by you or any other user, in an earlier version of the software.