Database connectivity

The open database interface allows the connection of factual data from different database formats of different manufacturers to drawing objects, provided that the manufacturers of these database programs allow this (password protection by the manufacturer). Object properties (areas, lengths, etc.) and freely defined attributes from the CAD drawing can be written into the database or drawing objects can be generated from the database.

The interface is used, for example, for the connection of drawing objects to AVA programs for quantity determination or for the connection of a cadastral program with which objects can be automatically generated in the drawing.

Since a configuration consists of many SQL commands, the flexibility is very high. Almost every database can be accessed via the ODBC driver. In particular, the large databases Oracle, Sybase and Informix should also be mentioned here. The creation of configurations for new databases can be done via dialog control.

Limits in the application of the ODBS can possibly be set by the ODBC driver used, as these sometimes only support a subset of SQL commands. A database with a "simple" ODBC driver usually has a relatively simple structure and the ODBS configuration is therefore easier to create.

A thorough knowledge of SQL is required to create configurations. We recommend the reference book: SQL. The Key to Relational Databases - ISBN No. 3-499-61245-3

A basic knowledge of the ODBC interface is also an advantage. For this we recommend the MSDN as a reference work, as well as the book: Inside ODBC - ISBN No. 1-55615-815-7

Creation of new configurations (eg for AVA programs) can also be done directly from DATAflor be taken over. Ask your local branch office about this.