Understanding Databases in Iguana
In addition to allowing you to work with databases like Oracle, SQL Server, MySQL etc.
IguanaX comes with built in support for the SQLite database format which is a good choice for learning before you use your preferred database.
This can be very helpful for simple requirements when you are operating Iguana in an environment which does not make it easy to operate other databases.
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.
If you want to use merge with spaces in column names you can use the custom merge module (you will need to modify it to use the correct column name delimiters for your target DB) Customize custom_merge.lua for table and field names with spaces - iNTERFACEWARE Help Center
Here are steps to use the SQLite database in IguanaX GUI:
This is part of your product Getting Started