Setting Up an ODBC Data Source For MS SQL Server

Every channel in Iguana needs to be associated with a database. At minimum, this database is used for logging the HL7 messages that flow across the interface. In many cases, the database also acts as a source or target for data mappings. In cases where you want to use an ODBC Database API for your channel, you will need to ensure that you have configured an appropriate ODBC data source.

Creating the ODBC Data Source
Changing the Iguana Log On Properties

This example shows you how to set up a new ODBC connection to an MS SQL Server database. Note that the steps and screenshots will be similar but slightly different when you set up other supported databases like MS Access.

Iguana supports some databases, such as MySQL and Oracle, through their native interfaces (i.e. not through ODBC). In such cases, the Data Source name specified in the channel configuration only needs to be the name of the database itself and no ODBC data source needs to be configured.

iNTERFACEWARE™ Inc.

Setting Up an ODBC Data Source For MS SQL Server