Creating a VDB
- Aryn Wiebe
There are two ways to create a VDB:
Build the VDB database table schemas using the Iguana GUI editor
Have Iguana import your database table schemas directly from your database
You can follow along the steps below for each method:
Note: It is recommended that column names do not contain spaces (ex. First Name). If column names have spaces, db.merge will not be able to be used and instead will have to write and execute SQL statements from the Translator.
Building a VDB in Iguana:
Click Add File in the Project pane (see Adding Files to a Project if this is your first time)
Enter a filename, choose the .vdb file type, and click create.
In the VDB viewer, click the ellipsis button to edit, and then + Add Table Definition.
A table editor window will appear, click the ellipsis to edit the table definition.
Build your table schema and click Save:
Enter a Table Name and Description.
Click Add Column and enter your the Name, Description, Data Type, and identify key fields.
You can also re-order your columns by dragging the column to the desired position.
Import Database Table Schemas:
Â
Â