iNTERFACEWARE™ Inc.

Getting Unsupported Databases to Work with Iguana

	iNTERFACEWARE does not guarantee that this solution will work with all types of unsupported databases. If possible, iNTERFACEWARE strongly suggests that you use a database supported by Iguana instead.

Iguana supports all the major databases, including MS Access, Oracle, MySQL, MS SQL Server, Sybase ASA/ASE and Postgre SQL. Although other databases are not fully supported, it may still be possible to get your database to work with Iguana by following the solution below.

	Important Notes An existing channel must be used since you will not receive a preview of the SQL statements if the connection to the database does not work when initially setting up a channel. Technically, the type of ODBC connection that's used should not matter. If the first one you try does not work, try using a different ODBC connection. This section explains how get your unsupported database to function when parsing data into a database. The steps may vary slightly when generating messages from a database.

To get your unsupported database to work with Iguana:

• Open Iguana and stop the channel you want to modify.

• Under Export Database Tables, ensure that the Channel Log Tables and Destination Data Tables options are checked.

Export Database Tables

• Click the Export Tables button. The Export Tables Preview window appears as shown below.

Export Tables Preview

• Click the Confirm Table Export button. If the tables are successfully exported, a confirmation message appears. If the tables are not successfully exported, try the next solution.

	The screenshot used below is from the SQL Query Analyzer tool by MS SQL Server. If you are using another SQL Analyzer tool the screen will be slightly different, depending on the database.

• Copy and paste the SQL statements from the Export Tables Preview into a SQL Analyzer tool.

• In the SQL Analyzer tool, change the VALUES from (?,?,?) to (0,0,0). Depending on the database, these values could be different (e.g. in MySQL it's already (0,0,0) and in Oracle it's (:CHANNEL_NAME_dest1_to_dat_err,:CHANNEL_NAME_source1_fro_dat_err,:CHANNEL_NAME_cha_suc_log).

• Edit the other Data Types to match the data types for the corresponding database. For example, LONG, MEMO and DATETIME are data types that may be slightly different for each database.

• After you have edited all the applicable data types, run the SQL query.

Running the SQL Query

If the SQL query was successful no error messages appear.

	If the SQL analyzer tool you are using supports syntax highlighting, you can use it as a guide to check if the data type is properly labelled. Since data types can still be colored but be incorrect, it should only be used as a guide. In the above example, the data types would appear as plain text if they were incorrectly edited (e.g. if you change the above INTEGER value to MEMO, it would appear as plain text because SQL Analyzer would not recognize it as a valid data type).

• Open Iguana and turn on the applicable channel, and check your database tables to see if they are populating with data (see Problems Inserting Data into a Database for more information). If there is still no data, try the next solution.

• Check the Iguana logs for relevant errors to try and correct the problem (by default, they are stored in C:\Program Files\iNTERFACEWARE for versions 3.2.153 and below; starting in version 3.2.154, they are stored in C:\Program Files\iNTERFACEWARE\Iguana).