|
Featured Reviews
|
 SqlSpec |
|
Includes a comment editor supporting SQL Server, Oracle, and more.
|
|
| Universal SQL Editor |
|
Support Oracle, DB2, SQL Server, Sybase and other ODBC databases.
|
|
| Softerra LDAP Browser |
|
A premier explorer like LDAP client designed for Windows and admins.
|
|
| Secure Auditor |
|
IT security assessment software which performs database auditing.
|
|
| DBA Easy Control |
|
A unique versatile database management suite for Oracle DBA.
|
|
| Secure Bytes |
|
Solution for conducting automated audits on Windows, Oracle and SQL.
|
|
|
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.
D3 7.0 and above comes standard with an ODBC server/driver. The D3 ODBC package consists of an ODBC server and an ODBC client driver. D3 data can be accessed using SQL through this ODBC layer or through the D3 Class Library. If SQL is used, the D3 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 D3 class library can also be used through the ODBC layer. For more information on these features, please refer to the D3 ODBC Manual. |
|
|
|
|