Design SuiteObject database connection

The final step in setting up a database connection is to connect object instances to the database. The procedure for connecting a single object follows. If you are connecting multiple objects, see Multiple object connection.

Once connected, the connection can be edited. The connection can also be removed.

Single object connection

Command

Path

Object Connection

Tools > Database

To connect a database to an object:

Select an object.

On the Data tab of the Object Info palette, click the box for the selected format to attach the record format to the object instance. (See Attaching record formats to symbols, objects, and materials.)

The Record Fields display with default values from the record format.

Select the command. Alternatively, click Object Database Connection from the Data tab of the Object Info palette.

The Object Database Connection dialog box opens. If a row was previously selected for the object, it appears highlighted and bolded.

ObjectConnect.png 

Click to show/hide the parameters.Click to show/hide the parameters.

Parameter

Description

Available Records

Lists the record formats available for the selected object (including IFC and COBie records)

Database Connection

Opens the Record Formats Database Connection dialog box, to connect a record format to a database table

Add New Database Table Row

Inserts a new row in the database table, and associates it with the object

Use Selected Database Table Row

Allows the database table row from the linked database table list to be selected, associating an existing row with the object

Database Table Rows

Selects a table row to associate with the object; this row provides data for the selected object or receives data from the selected object

Click Use Selected Database Table Row, and then select the appropriate row for the selected object.

The record fields are populated from the database table for the record instance attached to the object.

Multiple object connection

Editing object connections

Removing object connections

Database setup

Database connection

Record format database connection

Specifying update settings

Concept: Records, reports, and schedules

Database-Vectorworks communication

 

Was this page helpful?