Workflow: Database Connectivity
Workflow: Database ConnectivityThe Vectorworks Design Series products include the ability to communicate with external databases according to Open Database Connectivity (ODBC) and SQLite standards. A set of data in a database can be used to automatically update the records (record formats, as well as IFC and COBie records) attached to objects. Similarly, Vectorworks objects can send object data to a database, updating it.
To successfully use ODBC in Vectorworks Design Series products, a database management system is required, and steps need to be followed to set up the connection and manage the data flow.
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary files. A complete SQL database with multiple tables, indices, triggers, and views is contained in a single file.
Configure and set up data in the database program of your choice. Database connectivity in the Vectorworks Design Series is supported for the following database systems:
● Microsoft Excel
● FileMaker Pro
● Microsoft Access and Microsoft SQL Server
● MySQL
● SQLite*
● Any database that supports ODBC and has either Mac or Windows drivers
Database and/or operating systems typically include a separate ODBC Administrator or Manager application, which defines drivers and data sources. Database drivers may need to be installed. See ODBC Driver Information.
The installation, setup, and usage of database systems is beyond the scope of this help system and is not described here. Please consult the documentation related to your operating system or database software for information.
* SQLite database files do not require an ODBC manager or server. For information on SQLite, visit sqlite.org.
Set up the connection between the Vectorworks product and the database system. A “key” column with unique values is designated, to establish and maintain the communication between the database system and Vectorworks record formats.
Define a link between the database and the record formats of the object types.
Identify the object instances of each type of object to be connected and link them to a row in the database table.
When connections have been established, determine the settings to update the Vectorworks record formats from the database, and to update the database from the Vectorworks object records. The two-way communication process can be automated.
~~~~~~~~~~~~~~~~~~~~~~~~~