Setup Live Database - CADWorx - Help

CADWorx Plant

Language
English
Product
CADWorx
Subproduct
Plant
Search by Category
Help
CAESAR II Version
12
I-Configure Version
6.0(2016)
Smart Isometrics Version
8
Spoolgen Version
10
CADWorx Version
20.1 (2020 R1)
CADWorx Structure Version
2020 R1 (4.1)

CADWorx Plant I tab: Database > Setup

Plant menu: Accessory > Database > Setup

Command line: LIVEDB

CADWorx supports a fully functional live external database using MS SQL, MS Access, or Oracle. Use this command to define the database settings that are saved to the configuration file listed. When a drawing is opened and a configuration file is located in the same folder, the drawing initializes according to that configuration file using a live database or not.

  • When you delete a component from a drawing with an active live database, the database marks that component for deletion. When you close the drawing without saving, then the item does not deleted from the database. If you save the drawing, then the item deletes from the database.

  • When a component or a group of components are copied from a drawing to a new drawing that uses the same live database, the copied components are duplicated in the live database with the new drawing name.

  • When a component or a group of components are cut from a drawing and placed in another drawing that uses the same live database, the components duplicate in the live database with the new drawing name. When the old drawing is saved and closed any duplicate items from the first drawing are deleted from the live database because they are no longer on the first drawing.

  • All changes to live database settings take effect in the next drawing session.

On/Off

Turns the live database system on and off. When on, all components drawn are updated instantaneously to the database. Changes can be made in the drawing or in the database. When off, all CADWorx component information is stored only within the drawing.

Database Type

Select the type of database to use as the live database. Depending on the type chosen, the path to the database or schema is displayed.

We recommend using Microsoft SQL Database for shared and multi-user environments.

Access Path

Defines the Microsoft Access database information. Click Create Table to create the PIPE table in the database when creating a new database. Click Select File to specify an existing database.

SQL Server Database Name and Schema

Defines the Microsoft SQL Server database information. You must have already created the ODBC schemas (refer to the installation guide for help). Type the database name in the Database box, such as Plant_SQL_SERVER. Type dbo for the ODBC schema name in the Schema box.

Oracle Schema

Defines the Oracle database information. Type the ODBC schema name in the Schema box.

Startup Dialog Options

Sets the database option on CADWorx startup.

  • No dialog (new drawings are in Live DB)

Select to place new drawings automatically in the database. Selecting this option requires that a new drawing be named and saved immediately on creation. Drawings that use a live database must be in the same folder with the appropriate configuration file.

  • No dialog (new drawings are not in Live DB)

Select to not add new drawings to the database. You can add drawings to the live database later using this command.

  • Show dialog

Select to display a dialog box during startup of CADWorx on which you can choose to use a database or not.

Save and Close saves the current settings to the configuration file when you select the Piping Live Database Settings check box in Miscellaneous CFG Content in the CADWorx Plant Setup. For more information, see Miscellaneous CFG Content, and Setup.

Existing components in drawings can be added to the database by using DBFGEN. For more information, see Export Pipe.