C O N N E C T I V I T Y
ODBC

The industry standard for Open DataBase Connectivity.

ODBC is the industry standard method for connecting applications to database servers. This widely accepted Application Programming Interface (API) allows a common interface to access database systems through SQL (Standard Query Language) and by more direct methods. The goal of ODBC is to enable ODBC compliant applications to access any ODBC compliant databases. This adds a layer between the application and the DBMS, which is referred to as the Database Driver. The DBMS vendor must implement the ODBC API on the DBMS and provide a client driver in order for this to work.

Most database vendors ship their DBMS with an ODBC driver.

D³ 7.0 and above comes standard with an ODBC server/driver. The D³ ODBC package consists of an ODBC server and an ODBC client driver. D³ data can be accessed using SQL through this ODBC layer or through the D³ Class Library. If SQL is used, the D³ multidimensional file structure needs to be 'flattened' or 'normalized'. Though the data itself is not changed, a datamap is created with the TCL verb 'SQL-CREATE-TABLE'. The D³ class library can also be used through the ODBC layer. For more information on these features, please refer to the D³ ODBC Manual.

The D³ ODBC server is available on all D³ platforms. The D³ ODBC client driver is only available on Microsoft Windows platforms. The client driver can be ordered from Raining Data or downloaded from our ftp://ftp.rainingdata.com/pub/ODBC/2.0.x/Releases/

Further documentation can be found on our documentation pages.

Beta Program

For information on our Beta programs, please refer to this page.