If you use an ODBC data source to interact with your Oracle database, and you want to use Iguana with this database, you need to supply the following when specifying a database in an Iguana channel:

• The name of the ODBC data source;
• The username that you use when accessing the database;
• The password for that username.

How you will interact with your Oracle database depends on what version of Iguana you are using:

• If you are using Iguana 4.0 or later, you can use a From Database component to read information from a database to generate an HL7 message, and you can use a To Database channel component to populate your database tables with information from an HL7 message.

• If you are using a version of Iguana that is older than version 4.0, you can use your Oracle database to store your channel logging information. This database will also be used by any From Database or To Database channel components that you create.

In all versions of Iguana, set the following fields to ensure that your channel can access your Oracle database through an ODBC data source:

• From the Database API list box, select ODBC - Oracle.

• In the Data source field, type the name of the ODBC data source.

	To locate the name of the ODBC data source: Open the Control Panel. Select Administrative Tools and Data Sources (ODBC). Click the System DSN tab. The name of the ODBC data source for your Oracle client should be listed there.

• In the Database username field, type the username that you use to access the Oracle database.

• In the Database password field, type the password for your username.

The following is an example of an Iguana channel that uses an ODBC Oracle database as its destination component:

For more details on using a database in a channel:

• See From Database for information on using a database as a source component when creating a channel.
• See To Database for information on using a database as a destination component when creating a channel.
• See Configuring the Channel Level Details for information on using a database in a version of Iguana that is older than version 4.0.

	For information on how to create an ODBC data source for an Oracle client, see Setting Up an ODBC Data Source for Oracle. If you do not have an Oracle client and need to access an Oracle database from Iguana, the Oracle Database Instant Client is recommended. See Setting Up an Oracle Database Instant Client for more details.

	If Iguana is writing to or reading from a database, and your database is using an ODBC driver to interact with Iguana, the trace log from your ODBC driver (sql.log) could use up all available disk space on your hard drive. See Disk Space Problems When Using Iguana With an ODBC Driver for more information.

	If you are using a version of Iguana that is older than version 4.0 and you are having trouble getting it to work with your Oracle database, you may need to use an updated version of Iguana 3.3.2. See Oracle Issues With Older Versions of Iguana for more details.