First Look: ODBC and InterSystems Databases
If you want to use ODBC with InterSystems IRIS™ data platform, this document provides an introduction to how to set it up.
InterSystems provides a fully compliant (ODBC 3.5) ODBC driver, which you can use to access an InterSystems IRIS database via ODBC. The driver is installed by default when you install InterSystems IRIS.
In order to start using ODBC with InterSystems IRIS, you simply need to configure the driver on your InterSystems IRIS instance. This First Look document provides an overview of that process.
If you are not already familiar with ODBC, see the links in the Learn More
section at the end of this document for further information.
Before You Begin
To use this procedure, you need a Windows systems with an installed instance of InterSystems IRIS. For instructions on how to install and license a development instance of InterSystems IRIS, see InterSystems IRIS Basics: Installation
This section describes how to create a DSN for an InterSystems IRIS database on Windows.
The instructions in this section assume that you have the InterSystems ODBC driver installed. By default, the standard InterSystems IRIS installation process installs the driver, so unless you performed a custom installation, the driver should be present on your instance.
To enable your applications to access an InterSystems IRIS database via ODBC, you need to create a DSN that defines the location of the database for the ODBC client driver. On Windows, you can do this from the Windows Control Panel, as follows:
Open the Windows Administrative Tools control panel.
Select Data Sources (ODBC).
On the User DSN tab, select Add.
Select InterSystems ODBC and click Finish.
The DSN is created, and the InterSystems ODBC Data Source Setup dialog box is shown.
InterSystems ODBC Data Source Setup Dialog Box
Enter the necessary configuration details:
Enter a name and description for the DSN.
Enter the IP address, port number, and namespace corresponding to the InterSystems IRIS database that this DSN represents.
Select an authentication method, and enter or select other security information as appropriate for the InterSystems IRIS instance.
Select the Test Connection button to test that your setup is correct.
If the connection test was successful, congratulations! You have finished setting up your InterSystems IRIS database to use ODBC. Now you can modify your ODBC-aware applications to use the DSN that you just created.
To use SSL/TLS to secure an ODBC connection on Windows, see the “Using SSL/TLS with InterSystems IRIS
” chapter of the Security Administration Guide
To learn more about ODBC and InterSystems IRIS, see:
Content Date/Time: 2019-10-14 06:33:38