Database Schema Configurator

You can use this tool to configure database connections in the Network Configurator and map database schemas in the Translation Configurator. With these supports, you can significantly reduce Tcl script writing and improve usability on database-related configurations.

Before using the Database Schema Configurator, you must have already prepared a database, user, table, and data in the database.

Each database connection schema set is shown as a single document

For example, the IDE attempts to gain the file lock when opening the schema set for a selected database connection. Each database connection schema set is shown as a single document

If any other user has already acquired the lock, then a Lock Conflict dialog box opens.

  • Click Yes to acquire the lock.
  • Click No to open the connection as read-only. Only users who acquire the write lock can import, synchronize, and save the schemas.

BLOB/CLOB support

The large object BLOB/CLOB is supported on the Database Schema Configurator. BLOB and CLOB are listed on the Schema Data Type list.

Oracle, MS SQL SERVER, and SQLite support the BLOB/CLOB datatype in the Cloverleaf Database protocol. The other database BLOB/CLOB datatype operations in Cloverleaf could vary, subject to its implementation against the JDBC standard.

For additional information, see BLOB and CLOB.

VRL file for database schema

When you import table/view schema, all visible columns are saved into a VRL file.

Database schemas are imported into Cloverleaf and stored in VRL format. To parse data from a file, the fields and line terminations must be recognizable to the corresponding VRL format. Fields must be separated with "," and rows must be separated with "\x0d\x0a."

XML schema file for table/view definition

When you import a table/view schema, the table/view schema is saved into a XML file. This file is prepackaged by the installation under $HCIROOT\formats\dbschema.

The dbschema.xsd file table schema file is located at $HCISITE\formats\dbschema\sqlserver_connection.

Folder structure and the ini file

Each database connection has an individual folder in which to store the table/view schemas.

The dbconfiguration.ini file is used to store all the database connection configurations. This is under the $HCISITE folder.

Each section is a database connection configuration.

The password key is 64-bit encoded.