|
|
IDL DataMiner Guide: DataMiner Overview |
|
The IDL DataMiner is an Open Database Connectivity (ODBC) interface that allows IDL users to access and manipulate information from a variety of database management systems. We developed IDL DataMiner so that IDL users can have all the connectivity advantages of ODBC without having to understand the intricacies of ODBC or SQL (Structured Query Language).
| Note The IDL DataMiner is not supported on 64-bit IDL platforms. To run DataMiner on a 64-bit platform, you must install the 32-bit IDL libraries and launch IDL in 32-bit mode by using the command-line flag -32 (either idl -32 or idlde -32). |
IDL DataMiner is a database-independent API for accessing and manipulating data store in a database from within IDL. The IDL DataMiner allows you to do the following:
ODBC stands for Open Database Connectivity, an interface that allows applications to access data in database management systems (DBMSs) using Structured Query Language (SQL) as a standard for accessing data.
SQL is ODBC's standard for accessing data and is a widely accepted industry standard for data definition, data manipulation, data management, access protection, and transaction control. The IDL DataMiner was designed so that users would not be required to have a knowledge of SQL to access data sources. However, DataMiner does provide an execution routine which allows users to perform any valid SQL statement (including creating, retrieving, and deleting tables in a database).
The ODBC specification defines a vendor-independent API for accessing data stored in relational and non-relational databases. The Core functions and SQL grammar are based on work done by the X/Open SQL Access Group. The ODBC architecture is made up of four components:
An ODBC-compliant driver allows you to communicate between an ODBC-compliant application and a DBMS. For example, the SYBASE SQL Server 10 driver allows you to connect your ODBC-compliant application to a Sybase SQL Server 10 database.
An ODBC driver is available on most major platforms. The information in the initialization file that the drivers use, the functions and SQL grammar that the drivers support, and the error message formats are the same across all platforms.
The ODBC DriverSet is made up of two ODBC components—the Driver Manager and a set of database drivers. With the ODBC DriverSet, you can access, query, and update data in a number of different databases.
The IDL DataMiner includes a set of ODBC drivers known as Connect ODBC. These drivers were originally provided by Intersolv, and later by Merant. In November 2001, Merant's DataDirect group became an independent company named DataDirect Technologies. Information is available at:
IDL version 6.4 supports version 5.0 of the Connect ODBC drivers for most platforms, and version 3.11 for SGI IRIX platforms. Version 5.0 was branded by Data Direct, and version 3.11 was branded by Intersolv.
The following tables describe the ODBC drivers that are included with and supported by the IDL DataMiner, by platform.
| Note DataDirect Wire Protocol drivers do not require that database client software be installed. All other drivers require that the appropriate client software be present. For more information on DataDirect drivers, specific platform requirements, issues, and how to configure the ODBC driver for use with your database, see the appropriate version of the DataDirect Connect ODBC Reference manual. See About This Volume for further information on which manual is appropriate for your installation. |
|
Database
|
Versions
|
IRIX
|
|---|---|---|
|
Informix
|
7, 9
|
|
|
Oracle
|
7, 8
|
|
|
Sybase System 10
|
non-threaded,
threaded |
|
IDL Online Help (March 06, 2007)