Shared Database Library Support in Iguana |
Iguana supports three database APIs:
- The MySQL database API;
- The Oracle OCI;
- The Open Database Connectivity (ODBC) API, which is supplied with Windows.
These are the database APIs that you choose from when creating a channel whose source or destination is a database.
 | ||
|
Iguana supports using Oracle with the ODBC API, but using the Oracle OCI is more efficient. In theory, any database that can interact with the ODBC API can work with Iguana. At present, only the following databases have been tested and are supported:
| ||
 |
Iguana uses the following methods to find shared libraries on your system:
- If your Iguana server is running on Windows, Iguana first searches the registry for any installed shared libraries. If MySQL and Oracle are installed properly, there will be registry entries for their shared libraries. (This search method is new in Iguana 4.0.) If you are using MySQL 3.23, a registry entry will not be detected.
- If a shared library is not found using a registry search, Iguana will check the directories contained in the system search path.
| ||
|
Iguana supports the following MySQL shared libraries: 3.23, 4.0, 4.1, 5.0, 5.1 and 5.5. You can use Iguana with any MySQL database that can successfully interact with any of these libraries.When searching for an Oracle library, Iguana uses the default installation specified by Oracle, if one exists. Otherwise, Iguana picks the first supported version it finds. You can use Iguana with any database that can successfully interact with this library. If you have multiple versions of a MySQL or an Oracle OCI shared library installed on your computer, you can use the Database Settings page to specify the version of the shared library to use. Normally, the version that Iguana detects will be safe to use. If your Iguana server is using a MySQL shared library or an Oracle OCI shared library, and you change the shared library that Iguana is using, you must restart your Iguana server before you can use it again. | ||
|